All Forums >> [Scripting] >> WSH & Client Side VBScript >> (Un)escape function and Null Values Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!
I have a script that writes out a bunch of db entries. When these entries are entered into the database, I use the escape function to get rid of unwanted characters and then use the unescape function to write the entry like it was intended to look. My problem is that some of the entries contain blank fields and when I use the escape or unescape funciton on on of these fields it returns the following error: Microsoft VBScript runtime error '800a005e' Invalid use of Null: 'Unescape' . This means that the blank fields are interpreted as NULL so...I wrote the following function to deal with this.
function fixUnescape(str) if IsNull(str) then fixUnescape = "" else fixUnescape = Unescape(str) end if end function
instead of calling Unescape(var), I call fixUnescape(var) and It ought to work...right? Well it doesn't. I actually get the exact same error as before which to me means that it is not catching those blank field entries as NULL in the IsNull if statement. This, of course provides more confusion because the error message suggests that we are dealing with a NULL value.
This one is giving me a huge headache so I would greatly appreciate any help.
Thanks for the help. Unfortunately, I still get the same error. Right now I am just doing it this way: (Un)escape(str & "") which I guess is satisfactory but its one of those things that bothers me to have not solved the problem the right way.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> (Un)escape function and Null Values 
Printable Version
(Un)escape function and Null Values - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread