----- Original Message -----
From: Jeff Garza
To: CF-Talk
Sent: Monday, November 10, 2003 5:29 PM
Subject: Re: Dynamic SQL
You probably have to wrap your query in a PreserveSingleQuotes() function. By default, CF will escape single quotes in variables passed to a CFQUERY tag.
HTH,
Jeff
----- Original Message -----
From: brob
To: CF-Talk
Sent: Monday, November 10, 2003 4:11 PM
Subject: Dynamic SQL
Hey guys I am allowing user to run SQL scripts by typing them into a textarea and submitting them. But for ome reason i keep on getting some syntax error, even though I did an output test of the script on the page and the script looks alright. Any hints? thanks
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
