Query To Database

[Deepak Gupta]

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

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271078
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4