Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Weird Replace Problem
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Weird Replace Problem

 Post Reply Post Reply
Author
WookMaster View Drop Down
Newbie
Newbie


Joined: 29 November 2003
Status: Offline
Points: 15
Post Options Post Options   Thanks (0) Thanks(0)   Quote WookMaster Quote  Post ReplyReply Direct Link To This Post Topic: Weird Replace Problem
    Posted: 09 December 2003 at 6:06am

Im using this: 

Response.write Replace(rsJobsearch("jobdesc"),Chr(13) & Chr(10),"<br>")

I dont know why it quit working it was working great,  jobdesc is a memo in the access database.  Any ideas why I would get this error?  Thanks

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'Replace'

Back to Top
TYSON View Drop Down
Groupie
Groupie


Joined: 18 August 2002
Location: Australia
Status: Offline
Points: 142
Post Options Post Options   Thanks (0) Thanks(0)   Quote TYSON Quote  Post ReplyReply Direct Link To This Post Posted: 09 December 2003 at 6:29am

My guess would be that JobDesc of one of your rows is Null , You could try something like this

If rsJobsearch("jobdesc") <> "" Then
   Response.Write(Replace(rsJobsearch("jobdesc"),Chr(13) & Chr(10),"<br>"))
Else
   Response.Write(rsJobsearch("jobdesc"))
End If

 

Back to Top
Scotty32 View Drop Down
Moderator Group
Moderator Group


Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
Post Options Post Options   Thanks (0) Thanks(0)   Quote Scotty32 Quote  Post ReplyReply Direct Link To This Post Posted: 09 December 2003 at 6:29am

maybe becose there is nothing IN "rsJobsearch("jobdesc")"

try

Dim strJobDesc
strJobDesc = rsJobsearch("jobdesc") & " "
strJobDesc = Replace(strJobDesc,vbCrlf,"<br>")

Response.Write(strJobDesc)

if that doesnt work try

if isNull(rsJobsearch("jobdesc") = True then
     Response.Write(Replace(rsJobsearch("jobdesc"),vbCrlf,"<br >"))
end if

basically you cant do a Replace() if there is nothing in the field (ie "JobDesc") so its giving an error

S2H.co.uk - WebWiz Mods and Skins

For support on my mods + skins, please use my forum.
Back to Top
WookMaster View Drop Down
Newbie
Newbie


Joined: 29 November 2003
Status: Offline
Points: 15
Post Options Post Options   Thanks (0) Thanks(0)   Quote WookMaster Quote  Post ReplyReply Direct Link To This Post Posted: 09 December 2003 at 11:33am
Worked great you guys on this forum know your stuff
Back to Top
MorningZ View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793
Post Options Post Options   Thanks (0) Thanks(0)   Quote MorningZ Quote  Post ReplyReply Direct Link To This Post Posted: 09 December 2003 at 1:40pm

btw.. you can avoid the if..then by doing:

Response.Write Replace("" & rsJobsearch("jobdesc"),vbCrlf,"<br>")

Contribute to the working anarchy we fondly call the Internet
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.