Re: FN-FORUM: storing single quote

date posted 6th September 2007 15:17

On 6 Sep 2007 14:30:50 -0000, pamela @ gconnect [EMAIL REMOVED] wrote:
>
> How do most people store a single quote in an access database using asp? As
> far as I can see you can only store it as two single quotes or its char
> value.
>
>
> Pam
>
Just store it as a single quote. If you're using a SQL UPDATE to
update it rather than rsObj.Update then so this first on the field ...

strDescription =Replace(strDescription,"'","''")

... it just stores it as a single quote though.
HTH
Paul