Re: mdb access to names containing "'"

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Kevin Spencer (kspencer_at_takempis.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 10:53:43 -0400

Replace(myname, "'", "''") ' Replaces single quotes with doubled single
quotes in the value 

-- 
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"G.F.Schl" <anonymous@discussions.microsoft.com> wrote in message
news:2c1c01c470c0$8117f840$a401280a@phx.gbl...
> The following statement works unless "myname" contains
> a '.
> sqltemp="select * from logindata where lastname='" &
> myname & "' "
>
> I tried using your suggestion but get only exec errors.
> How do you suggest to code?
> >-----Original Message-----
> >Double your single quotes in the string.
> >
> >-- 
> >HTH,
> >Kevin Spencer
> >..Net Developer
> >Microsoft MVP
> >Big things are made up
> >of lots of little things.
> >
> >"G.F.Schl" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:280e01c47079$566415d0$a601280a@phx.gbl...
> >> In an ASP I access an Access DB containing names. I
> tried
> >> everthing I can imagine to use """ instead of '"
> including
> >> defining a constant (X37) but it either fails with an
> exec
> >> error or fails when names containing ' are processed.
> >> MY current code is:
> >> sqltemp="select * from logindata where lastname='"
> >> sqltemp=sqltemp & myname & "'"
> >> (It doesn't work when I try to make it with one
> statement)
> >> I am using FP2002.
> >> Can anyone tell me how to code this for handling names
> >> that contain '.
> >> Thanks 10to6
> >
> >
> >.
> >

Relevant Pages

  • Re: mdb access to names containing ""
    ... Double your single quotes in the string. ... Kevin Spencer ... Microsoft MVP ... > error or fails when names containing ' are processed. ...
    (microsoft.public.frontpage.programming)
  • Re: Filter and two wildcars error
    ... You need to put wildcards into single quotes inside the string ... Val Mazur ... Microsoft MVP ...
    (microsoft.public.data.ado)
  • Re: HtmlEncoding, SQL Encoding in ASP.NET
    ... doubled single quotes to escape them. ... Microsoft MVP ... "Chris" wrote in message ... > handy functions like php's addslashes, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Dlookup function criteria w/wo single quotes
    ... Pamphlet is a text field. ... When I use single quotes it works fine but I get into trouble because ... And yes it was the same database in both cases. ... A client site runs the FAILS version ok with MS Access 2003 11.6566.8132, ...
    (microsoft.public.access.modulesdaovba)