check out <cfqueryparam> Doug
>-----Original Message----- >From: Ian Skinner [mailto:[EMAIL PROTECTED] >Sent: Thursday, March 13, 2003 10:03 AM >To: CF-Talk >Subject: SQL This (') > > >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
