single quotes & double quotes in query string

Hi All,

I have few text fields in my form. On submit I want to collect all the
data from the form fields and insert into a database(Microsoft Access). I
use Connection.Execute method.

This string fails, when there is a single or double quote in the string
variables. Can somebody suggest me how to overcome this. Also I want to
display the data to user as he entered(including quotes), when he wants to
edit the data he entered at a later date.

Thanks
Vasanth

Re: single quotes & double quotes in query string

vasanth kumar wrote:
> Hi All,
>
> I have few text fields in my form. On submit I want to collect all
> the data from the form fields and insert into a database(Microsoft
> Access). I use Connection.Execute method.
>
> This string fails, when there is a single or double quote in the
> string variables. Can somebody suggest me how to overcome this. Also
> I want to display the data to user as he entered(including quotes),
> when he wants to edit the data he entered at a later date.
>
> Thanks
> Vasanth

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&c2coff=1& selm=eHYxOyvaDHA.4020%40tk2msftngp13.phx.gbl

http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&sel m=e6lLVvOcDHA.1204%40TK2MSFTNGP12.phx.gbl

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"