Are you using cfqueryparam to specify the type of the fields? That would probably solve your problem - show us the query!
On Friday, Nov 2, 2001, at 19:57 US/Pacific, jason kufner wrote: > 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. "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com
