Thanks a lot Man.. it worked... >On 2/28/07, Deepak Gupta <[EMAIL PROTECTED]> wrote: > >Cut and paste a bit of your other code (but don't tell anyone I said to >do that!) with a tweak or two: > ><cfloop query="csvdata"> > > <cfset rowVals = ""> > <cfloop list="#csvdata.columnlist#" index="colName"> > <cfset rowVals = >listAppend(rowVals,'"#csvdata[colName][csvdata.currentRow]#"')> > </cfloop> > > <cfquery name="CSVinsert"> > INSERT INTO tableName (#columnList#) > VALUES (#rowVals#) > </cfquery> > ></cfloop> > >untested, but something like that.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
