David Hannum wrote: > I have a survey building wizard. It works great except for one issue > (there's that word again). If the survey author creates a question > with multiple choices, (checkboxes) and any of those checkboxes has a > single quote (apostrophe) in the value, the INSERT query chokes. > (Multiple choices produce a comma delimited list for the field) > Logically, it should, so that's why PreserveSingleQuotes exists, > correct? However, when I use PreserveSingleQuotes, I get an ODBC > error that says "String not properly terminated". This is Oracle 8i > using Oracle ODBC drivers. In the debug, everything looks great. > > What is the best practice for doing a direct insert of text and > textarea form fields directly into the database?
cfqueryparam Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
