Tips for handling special characters within scripts...???
Posted on 2006-10-20
I often find myself having to deal with special characters causing errors in my scripts. Usually it's where SQL is involved because an apostrphy is included in the value that's getting used in the SQL statement which causes a parsing error. I fix this in these instances by using something similar to:
var = Replace(var, "'", "''")
So that works for small things like a name field, or an address field, and for SQL with apostrophy's. But here's an instance where I'm actually saving an XML response to disk like this:
set fs = CreateObject("Scripting.FilesystemObject")
filename = Server.MapPath("../xml/eBay/GetItemResponse_"&eBayItemID&".xml")
set tfile=fs.CreateTextFile(filename, true)
set tfile = nothing
set fs = nothing
This works 98% of the time, however, I came across an order today where the address included in the response was the following:
Upong trying to save the file to disk I get an error:
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument
I don't think the same fix would work on this because that's an entire XML response. Replacing all single ' with double '' will just break something else most likely.
Is there any particular way to easily handle these types of things in vbscript so that I don't have to constantly find work-arounds for them? any info would be great. thanks!