I had this happening just a few days ago, wrap the SQL with a
PreserveSingleQuotes() and you should be fixed right up!
Hatton
-----Original Message-----
From: brob [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 6:12 PM
To: CF-Talk
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]
- CF MX 6.1 Migration issue Andrew Santos
- Re: CF MX 6.1 Migration issue Matt Liotta
- RE: CF MX 6.1 Migration issue chris kief
- RE: CF MX 6.1 Migration issue Andrew Santos
- Dynamic SQL brob
- RE: Dynamic SQL Barney Boisvert
- RE: Dynamic SQL Philip Arnold
- Re: Dynamic SQL brob
- Re: Dynamic SQL C. Hatton Humphrey
- Re: Dynamic SQL Jeff Garza
- RE: Dynamic SQL Mosh Teitelbaum
- Re: Dynamic SQL brob
- RE: CF MX 6.1 Migration issue Dave Watts