Re: quotation marks in text fields
From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: Sun, 4 Jul 2004 07:41:48 -0400
Several of these posts include instructions on how to run the queries from
> Thanks for the response. I've never used QueryDef or saved parameter
> queries. I've now read most of the related articles on google and am
> still unsure how to code it in ASP. M/S KBase article # 142938 comes
> closest but I don't think the example is for ASP. Can you point me
> to a KB article or one of yours that might help?
> Steve G.
> "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
>> SteveG wrote:
>>> I'm using an sql INSERT statement to add text data to an Access
>>> database. If the text includes an embedded quotation mark, the text
>>> is truncated at that point - without an error. This only happens
>>> I am hosted on Windows 2003 sever. When hosted on Windows 2000 it
>>> works fine.
>> Really? Delimiter problems should not depend on the OS being used ...
>>> Is there something similar to using the Replace function to add a
>>> 2nd apostrophe (eg: Replace(textstream,"'","''") to avoid errors
>>> with embedded apostrophes?
>>> Thanks, Steve G.
>> Switch to using saved parameter queries and never worry about
>> delimiters again. Just Google for posts by me containing those words
>> for details.
>> Bob Barrows
>> Microsoft MVP - ASP/ASP.NET
>> Please reply to the newsgroup. This email account is my spam trap so
>> I don't check it very often. If you must reply off-line, then remove
>> the "NO SPAM"
-- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"