Hi I am doing this <cfset LocalFilePath="c:/..."> <cfquery name="CSVData" datasource="file_csv"> SELECT * FROM #LocalFilePath# <cfquery>
I have here the query CSVdata, this is basicaly converting CSV to query and now I have to insert this query in the database. I already have a dummy table with these column names in the database.here the column names are dynamic. How i can do that? -DG ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
