Why does Oracle have so many Issues? It's like they're trying to be Microsoft or something. I have read where Larry Ellison says he plans to be richer than Bill Gates - oh well, follow the leader!
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? =============================== David R. Hannum Web Analyst/Programmer Ohio University Computer Services Administrative Systems (740) 597-2524 "If your wife is having fun, and you're not . . . You're still having a lot more fun than if you're having fun, and she's not!" (Red Green) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
