Can anyone out there, help me with the problem with double quotes.



I have an asp page and people are filling in the data, but of cause the

query does not like double quotes.





Many thanks



Damian Lefebvre





********************************************************************************************



The information in this email is private and confidential and may be legally 

privileged. It is intended solely for the addressee. If you are not the intended 

recipient or the employee or agent responsible for delivering this message to 

the intended recipient you are hereby notified that any dissemination or 

distribution of this message or its attachments is strictly prohibited and you 

should please delete this email. If you have received this email and its 

attachments in error please notify us by return email or by telephone 

immediately and please destroy the email and attachments. Any views 

expressed in this message are those of the individual sender, except where 

the sender specifically states them to be the views of 

Standard Bank Offshore Group Limited.



Visit our web site at www.sboff.com



********************************************************************************************

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Lefebvre, Damian D" <D.Lefebvre@s...>

Subject: [access_asp] double quotes.





: Can anyone out there, help me with the problem with double quotes.

: 

: I have an asp page and people are filling in the data, but of cause the

: query does not like double quotes.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Why not? Single quotes need to be doubled:

www.adopenstatic.com/resources/code/SafeSQL.asp



Double quotes should be fine.



Please post error message, plus code, plus what you think is the problem.



Cheers

Ken

Maybe you can try to escape these quotes, but I don't know if you can do 

this in ASP.

Anyway, is it meaningful to search on double quotes? If not you can check 

the input field first for quotes, and if they contain quotes don't do the 

query.



regards,

Pieter

You can escape double quotes by doubling them.



Response.Write("Here is some text with "" in it")



That said, you shouldn't need to escape double quotes in an SQL statement,

because double quotes aren't reserved in SQL statements.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Pieter" <pieter.schockaert@c...>

Subject: [access_asp] Re: double quotes.





: Maybe you can try to escape these quotes, but I don't know if you can do

: this in ASP.

: Anyway, is it meaningful to search on double quotes? If not you can check

: the input field first for quotes, and if they contain quotes don't do the

: query.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~