sound like a format field problem. In your Database, what is the UserID datatype?
If userID datatype is number,etc, so you must use userID = 3. If userID datatype is a
text, you must use userid='3' or userid='#userid#'
good luck
gabriel
-----Mensaje original-----
De: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
Enviado el: Thursday, February 01, 2001 7:52 PM
Para: CF-Server
Asunto: 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
