Re: quotation marks in text fields

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 07/04/04 

Date: Sun, 4 Jul 2004 07:41:48 -0400

Several of these posts include instructions on how to run the queries from
ASP.

http://www.google.com/groups?as_q=saved%20parameter%20query&safe=images&ie=UTF-8&as_uauthors=Bob%20Barrows&lr=&hl=en

Bob Barrows

SteveG wrote:
> Bob,
>
> 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
> news:%23nKtKRPYEHA.1224@TK2MSFTNGP09.phx.gbl...
>> 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
>>> when
>>> 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"

Relevant Pages

  • Re: Access 2000 and creating stored procedures
    ... >> Bob Barrows ... saved queries created from external applications are not visible within ... I think Aaron has an introductory article about ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Local tables or linked local database?
    ... How good of a job does Access do mitigating the amount of ... You have used passthrough queries. ... network load - with a network full of people sending emails, printing, ... My posts come from my experience. ...
    (comp.databases.ms-access)
  • Re: The newbies dilemma!
    ... i do answer your queries about me and i correct ... Does Andrew Taylor, the group Moderator, now have power to delete posts? ... i do not have control over Annexcafe newsgroups to remove any posts ... if you want to mention i have control to remove any posts from my ...
    (microsoft.public.security.virus)
  • Re: Fighting Ring this Way
    ... I've been a lurker for a long time and have wanted to join in. ... Whereever I've thought of replying, all I see are your posts, threats ... why do you say nasty threats and abuse others? ... group are very pleasant, so put your queries, and if she should answer you ...
    (uk.rec.gardening)
  • Re: Totals query with an expression
    ... After reading some more posts in the query group, ... All of my queries still return the right number but I still got the same error. ... Hi Linda, ...
    (microsoft.public.access.gettingstarted)