I think I have known this, but my brain is refusing to divulge the details.
I have strings from a form that will be complete prose sentences and paragraphs that need to be inserted into SQL 2000 char and varchar fields with all their possible punctuation. What I can't remember is the best way to handle the string so that the punctuation won't cause error's in the SQL statement. For Example, I would be inserting text such as this: As I'm sure you know, all this punctuation would probably "cause" problems when inserted. Don't you all think so? What is the easiest way to correctly insert strings such is this? On a related side problem. Anybody know any elegant work around that allow the values from a set of related Form controls returned as a list to contain commas (,)? For Example: <input type="text" name="TextField" value="Testing, one two three."> <input type="text" name="TextField" value="You see, there are commas here. And, multiple sentences."> <input type="text" name="TextField" value="Comma, Comma, Comma"> Of course this then returns a Form.Field element with the following value. Form.TextField = Testing, one two three.,You see, there are commas here. And, multiple sentances.,Comma, Comma, Comma As you can see, parsing this as a list with a default comma delimiters is going to return 8 items instead of the correct 3. Is there an easy way to incorporated a text qualifier and/or alternate list delimiters into the values returned by a Form list? A compounding issue, is that I don't know how many "TextField" fields that will be returned, the user can dynamically create as many has he needs. Thanks for you help. Ian Skinner Web Programmer BloodSource Sacramento, CA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
