In an ASP I read an MS-Access DB containing names. I tried everything 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

Hi:
I don't know the answer, but if you do this Google search:
http://www.google.com/search?sourcei...ery+apostrophe
you should find the answer.

--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/



G.F.Schl <(E-Mail Removed)> wrote:
> In an ASP I read an MS-Access DB containing names. I tried everything
> 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