I was wondering if anyone could help me out as I am stuck on this part. I
have a csv file that I would like to read and then issue an update query based
on the contents.
Basically I would like to read the file and then loop over the file and issue
and update query for each line (maybe I could convert it to stored procedure
later).
The file looks like this:
"5388120","12345678IL"
"5388150","FDX123FD45"
"5388165","FFFFRT6789"
"5388198","12345HY890"
"5388204","123SEDFRT"
"5388205","1ASEFFBH6"
"5388209","12890HFS23"
"5388212","124300HGFS"
"5388231","123567UHJK"
"5388235","12WWE4DD45"
"5388281","1234RFGT76"
"5388284","313SFFS67"
"5388361","23DS455555"
"5388366","4422442242"
"5388372","42242FDFSF"
"5388403","FDXUPSDELD"
"5388409","1234567890"
"5388414","ASWDERF455"
"5388415","123EDCVBH6"
"5388417","12WSED56YH"
"5388424","12WSC56HBN"
"5388428","123WSE456H"
"5388510","313DADDADA"
"5388511","HFH678947S"
"5388597","3131ADADAD"
"5388654","ADA5DFA5RD"
"5388655","AD4242DDAA"
"5388661","1331XSSA4D"
And what I want to do is loop over it and issue an update:
PUSEDOCODE:
<CFLOOP over the file>
update table
set track_nbr = '2345678il'
where header_id = 5388120
</cfloop>
What is the best way to do this. I can process the file but I am lost as to
what to do.
This is what I have so far:
<cfset RecordDelimiter = Chr(10) & Chr(13) />
<cfset ColumnDelimiter = chr(34) & chr(44)& chr(34) />
<cffile action = "" file = "G:\inetpub\wwwroot\mario\fedex_input.csv"
variable = "Variables.SourceFile">
<cfloop index="index" list="#Variables.SourceFile#"
delimiters="#RecordDelimiter#">
<cfloop index="recordIndex" list="#index#" delimiters="#ColumnDelimiter#">
<cfoutput#RecordIndex#<br>
</cfloop>
<hr>
</cfloop>
Thanks
Mario
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
