Storing quotationmarks in variables? (escape-char?)
Is there any way of storing quotaionmarks in a variable?<BR><BR>Perl, or instance, has the as a escape character which makes it possible to handle reserved characters like ".<BR><BR>thanx in advance<BR><BR>
RE: Storing quotationmarks in variables? (escape-char?)
strTest = """Hello"""<BR><BR>or strTest = chr(34) & "Hello" & chr(34)<BR><BR>In general you can add any character with chr(ASCII value), VBScript also defines some useful constants<BR><BR>vbCR = Carriage Return (ASCII 13)<BR>vbLF = Line Feed (ASCII 10)<BR>vbCRLF = Carriage Return followed by Line Feed
RE: Storing quotationmarks in variables? (escape-c
But to answer the question, use the ADO Command object and a parameterized query.<BR><BR>In this way ADO will automagically handle your quotes and apostrophes. Plus, this will give you a bit of a performace boost when doing the queries.