Re: quotation marks in text fields

From: SteveG (steveg1_at_tampabay.rr.com)
Date: 07/03/04 

Date: Sat, 03 Jul 2004 22:07:12 GMT

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

Relevant Pages

  • Re: Automating Searches
    ... its for a once off educational project. ... There is a set number of queries, ... Google is being "ripped off" iff you do something like: ... Firefox with manually-typed queries ...
    (comp.lang.java.programmer)
  • Re: Automating Searches
    ... There is a set number of queries, ... Google is being "ripped off" iff you do something like: ... Then we have Firefox with a MRU for queries; ... using the search engine proper, though the SEO will impact the latter ...
    (comp.lang.java.programmer)
  • Re: Does natural language skill translate to programming skill?
    ... The natural language processing of google is the reason for a Flemish site in the search result;-) ... KMO-IT Dag werd geschreven door Bart op 27-02-2007 - Reageer ... ... Google tries to guess the main language of a page. ... formulating SQL queries? ...
    (sci.lang)
  • Re: building a meta search engine
    ... I am building a web application, which involves submitting search ... license from Google which will give you something like 1000 queries per day. ... "Please do not write to Google to request permission to "meta-search" Google for a research project, as such requests will not be granted." ...
    (comp.lang.java.help)
Quantcast