1. The only problem is the single quotes, which need to be converted to two single quotes in a row. The easiest way to do this is:
<cfset string=REReplace(string,"'","''","All")> If someone is crazy enough (and aren't those end users crazy!) to put two single quotes in a row in their text field, I'm not sure what happens -- the RERelpace above should onvert that to 4 single quotes in a row, which I believe would insert correctly. 2. I don't know if this will work for you, but if you name each of the <input> fields a different name (ie. text1, text2, etc), then when the form is submitted you can concat them using a different delimiter than a comma. I usually use chr(182) which is the "paragraph mark" (the backwards "p"), since it's not usually used in text, but you could use something more obscure, or you could even search the text first to make sure there is no occurance of your chosen delimiter, and if so choose another. Then you can use all your list functions defining this as as the delimiter. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
