Storing quotationmarks in variables? (escape-char?)

Results 1 to 3 of 3

Thread: Storing quotationmarks in variables? (escape-char?)

  1. #1
    Roger Norrlén Guest

    Default 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>

  2. #2
    Mark Wilson Guest

    Default 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

  3. #3
    P B Guest

    Default 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •