Re: mdb access to names containing "'"

From: G.F.Schl (anonymous_at_discussions.microsoft.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 13:10:04 -0700

Thanks, I misunderstood. I used a "replace" prior any
references to myname since there are subsequent queries.
>-----Original Message-----
>I tried all combinations I can imagine but I like to
>learn. Do you know what could work?
>1. (using thre ")
>sqltemp="select * from logindata where lastname=""" &
>myname & """"
>yields the following error:
>Microsoft OLE DB Provider for ODBC Drivers
>error '80040e10'
>[Microsoft][ODBC Microsoft Access Driver] Too few
>parameters. Expected 1.
>
>2. (using two ' and one ")
>sqltemp="select * from logindata where lastname=''" &
>myname & "''"
>yields the following error:
>Microsoft OLE DB Provider for ODBC Drivers
>error '80040e14'
>[Microsoft][ODBC Microsoft Access Driver] Syntax error
>(missing operator) in query
>expression 'lastname=''Testing'''.
>
>3. (using two ')
>sqltemp="select * from logindata where lastname='' &
>myname & ''"
>yields the following error:
>Microsoft OLE DB Provider for ODBC Drivers
>error '80040e10'
>[Microsoft][ODBC Microsoft Access Driver] Too few
>parameters. Expected 1.
>
>4. (using one ' and one ")
>sqltemp="select * from logindata where lastname='" &
>myname & "' "
>works fine unless myname contains ' than error:
>Microsoft OLE DB Provider for ODBC Drivers
>error '80040e14'
>[Microsoft][ODBC Microsoft Access Driver] Syntax error
>(missing operator) in query
>expression 'lastname='O'Test''.
>
>>-----Original Message-----
>>Try
>>sqltemp="select * from logindata where lastname=""" &
>myname & """"
>>
>>Ron
>>--
>>Reply only to group - emails will be deleted unread.
>>
>>
>>"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
>>> >
>>> >
>>> >.
>>> >
>>
>>
>>.
>>
>.
>