How are you getting the data that you want to insert into the DB? So are you getting the data from one database and then looping through them to insert them into another? Or are they being input manually through a form?
Josh Trefethen http://exciteworks.com -----Original Message----- From: Seamus Campbell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:41 PM To: CF-Talk Subject: looping and updating records I have some records that need to be updated to a database. recordID is 37651 and this recordID has 3 Keywords: AAsian, AIndian, ABurma My query outputs them as 37651 AAsian, AIndian, ABurma I have to put AAsian, AIndian, ABurma as 3 separate records in one table KeywordsAT then put recordID Keywords 37651 AAsian 37651 AIndian 37651 ABurma into a join table which has recordID and Keywords as fields. I know I have to loop thru the records somehow, but cannot work out how to do it. (I'm pretty thick when it comes to looping) Can anyone help me please MTIA Seamus ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists