I have a list with at least 3 items. And I want to insert it into table.
right now, I'm looping through the list to insert them into db, but this is
like writing multiple cfquery's. and what happens if my list has 20 items.
<cfloop index="index" list="#mylist#>
<cfquery >
insert into my_table
(id, itemName)
values
(#ID#, '#index#' )
</cfquery>
</cfloop>
Is there a better way to do this?
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
