Try replacing the () with their HTML or ASCII equivs before the insert..
-----Original Message----- From: jason kufner [mailto:jasonkufner@;rio.com] Sent: Friday, November 02, 2001 9: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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
