Jason, Parentheses should not be a problem within a string. You need to post your SQL statement and the error itself.
Are you doing processing of the variable and then passing the variable to SQL? If so, it is likely a ' that is doing it, and not the parentheses. And if so, use the PreserveSingleQuotes() function. --- Ben -----Original Message----- From: jason kufner [mailto:jasonkufner@;rio.com] Sent: Friday, November 02, 2001 10:58 PM To: CF-Talk Subject: HELP!! sql wierdness and the clients coming tomorrow!!! Help! I'm at zero hour with a project and I just discovered an "issue" with SQL (the language, not the database): Here it goes: I have an Array holding some text and I'm inserting that text into the database, simple enough. But within this text the author used parentheses just like you would write a story. The problem is that SQL seems to run across the parentheses within the chunk of text I'm trying to insert and (I think) it trys to interrupt the contents of the parentheses as part of The SQL statement rather than text to be inserted into the database. The result is a syntax error. Is there some way I can escape the text? I know about the UrlEncoded format and the HTMLCodedFormat but this database is going to be used by a lot of people so I want to store the text as straight forward and unadulterated. Is there a SQL escape function? Any ideas? I know the underling coded works -I looped over 55 records just fine until I hit this one with the parentheses. Thank you in advance for your help in I a big hurry and I don't have time to figure it out on my own!! Thank you ,thank you ,thank you! Jason ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
