> 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.
The parens shouldn't cause any problems at all. In effect the value is a string delimited by quotes (usaully single quotes). So SQL sees the first quote and says "this must be a string!" - it then waits until it finds another quote before it treats anything like SQL logic. Are you using "PerserveSingleQuotes()" for any reason (perhaps erroneously)? Post the query and the "bad" value - it's the best way to get help. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
