Re: Dynamic SQL

[Jeff Garza]

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]

---