Do not create another table - bad design and unecessary.
"This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Dave Francis To: CF-Talk Sent: Sat Aug 05 14:58:42 2006 Subject: RE: problem with insert NO!!! You don't!!! Create another table. You'll thank me later. Ask Jochem. Ask Claude. -----Original Message----- From: Doug [mailto:[EMAIL PROTECTED] Sent: Saturday, August 05, 2006 9:26 AM To: CF-Talk Subject: problem with insert I know this is probably basic stuff, but I will ask anyway. I have two tables categories: [id] pri key (This table is populated with the categories already) category sub_categories [id] pri key cat_id FK to categories.id (This table is empty) sub_category I want to insert a comma delimeted list into the sub_categories table. Any help is appreciated. I am thinking I need to use a cursor or something and loop through till the end. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:248878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4