I am not sure..what your question is... You have multiple checkboxes with the same name... so when u submit the form.. you get something like form.checkBoxName="white,yellow,blue" Are you saying sometimes the values are like form.checkBoxName="white's,yellow's,blue" If thats the case.. Oracle or most other databases dont like that.. you have to replace single "'" quotes with "''".
Why are u using PreserveSingleQuotes again? Joe On Thu, 21 Nov 2002 09:40:53 -0500 David Hannum <[EMAIL PROTECTED]> wrote: > 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
