> 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
I tried using
<cfloop query="CSVData">
<cfquery name="CSVInsert" datasource="">
Insert into tableName (#ColumnList#)
Values ( ???)
</cfquery>
</cfloop>
How can I set values dynamically here from the query loop from above?
-DG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271074
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
