Your insert statement probably looks like this:
...., '#myTextareaValue#', ...
Use PreserveSingleQuotes:
...., '#PreserveSingleQuotes(myTextareaValue)#', ...
-David
On Sunday, July 08, 2001 6:53 AM, [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
wrote:
> I'm having a problem and can't figure out why.
> Using Access97 for the backend, I submit a form with a textarea tag. If there
>
> are quotation marks in the textarea tag, everything in the textarea from
> where the quotation marks begin is stripped out when the textarea formfield
> is inserted into the database.
>
> Why is everything from the quotation mark on, stripped out upon insert???
>
> How can I get that stuff to NOT be stripped out?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
