This may spark a huge debate, but shouldn't you be using a seaprate cross-join table for this?
On 8/29/06, Doug Brown <[EMAIL PROTECTED]> wrote: > > duuuh...Never mind!!! How bout using a different delimeter Doug > > > > ----- Original Message ----- > From: "Doug Brown" <[EMAIL PROTECTED]> > To: "CF-Talk" <cf-talk@houseoffusion.com> > Sent: Tuesday, August 29, 2006 5:37 PM > Subject: Insert question > > > > Sorry for the lame question...I am inserting a comma delimeted list and > the list itself has commas seperating different items > > > > > > > > IE: cars,trucks & other vehicles, antiques, baby items, > > > > How do I insert the commas that seperate the names without sql thinking > it > is a seperate item for insert? > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251444 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
