This might help you although I haven't tested it <cfloop query="CSVData"> <cfquery name="insert" ...> INSERT INTO TableName ( <cfloop list="#CSVData.columnlist#" index="i"> #i#, </cfloop> ) VALUES ( <cfloop list="#CSVData.columnlist#" index="i"> '#i#', </cfloop> ) </cfquery> </cfquery>
On 2/28/07, Deepak Gupta <[EMAIL PROTECTED]> wrote: > > Hi > > My code > > <cfloop query="CSVData"> > > <cfquery > name="CSVInsert" datasource""> > > > Insert > into TableName (#ColumnList#) > > > Values > (?,?,?...) > > > </cfquery> > > > </cfloop> > > > How can I dynamically place the column values from the CSVData query here > ? I will appreciate if someone can answer this. > > I need something like Values ( #Time#, #Date#, #NOW()#,....) > > Date and time is coming dynamically from the query. > > -DG > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271221 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
