RE: Looping through a CSV File

2002-03-21 Thread Carlisle, Eric
Read the contents of the file into a variable. Then use something like this. INSERT INTO myTable (column1, column2, column3) VALUES ('#listGetAt(cvsfile,1)#','#listGetAt(cvsfile,2)#','#listGetAt(cvsfile,3)#') Yo

RE: Looping through a CSV File

2002-03-21 Thread Jason Larson
Subject: Re: Looping through a CSV File If the csv structure will always be the same, you could set up an ODBC connection and treat it like a table. - Original Message - From: "Mike Townend" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday,

Re: Looping through a CSV File

2002-03-21 Thread Zac Spitzer
Mike Townend wrote: >Or theres a custom cfx tag called something like ... Cfxcsvtoquery that >will take a csv file and convert it into a query variable > there are mercant text database drivers installed with cf, then u can do it via ODBC select * from c:\data\file.csv z

Re: Looping through a CSV File

2002-03-21 Thread Marlon Moyer
If the csv structure will always be the same, you could set up an ODBC connection and treat it like a table. - Original Message - From: "Mike Townend" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 10:26 AM Subject

RE: Looping through a CSV File

2002-03-21 Thread Mike Townend
Or theres a custom cfx tag called something like ... Cfxcsvtoquery that will take a csv file and convert it into a query variable HTH -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: 21 March 2002 16:14 To: CF-Talk Subject: Looping through a CSV File I have a C

RE: Looping through a CSV File

2002-03-21 Thread Mike Townend
Treat the file as a list of lists... List 1 - Delimiter = #Chr(10)##Chr(13)# And each element of that list is a list with delimeter , HTH -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: 21 March 2002 16:14 To: CF-Talk Subject: Looping through a CSV File I ha