DB access to names containing '

[G.F.Schl]

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

 

[Kathleen Anderson [MVP - FrontPage]]

Hi:
I don't know the answer, but if you do this Google search:
http://www.google.com/search?sourceid=navclient&ie=UTF-8&q=asp+query+apostrophe
you should find the answer.

--

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