Got it.
#PreserveSingleQuotes(FORM.QRYTEXT)#
----- Original Message -----
From: "Bryan LaPlante" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 4:51 PM
Subject: CFQUERY and single quotes
> I am having a problem with a textarea that I use to send queries through
CF
> via the CFQUERY tag.
> If I write a query that references a string value like [ select * from
users
> where name = 'me' ] the database says syntax error or access violation. If
> on the other hand the query goes [ select * from users where userID = 3 ]
> then the query runs fine.
>
> Has anyone else found a work-a-round for this?
>
> Bryan LaPlante
> 816-347-8220
> [EMAIL PROTECTED]
> http://www.netwebapps.com
> Web Development
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
