You might be interested in another approach which is a little more efficient than 
CFHTTP. Set up an ODBC datasource using the CSV driver and point it at a directory. 
Then all you need to do is perform a query with that datasource, using the filename of 
the csv where you would use a tablename in your SQL.

Steve

> -----Original Message-----
> From: Tim Blair [mailto:[EMAIL PROTECTED]
> Sent: 01 March 2004 12:11
> To: [EMAIL PROTECTED]
> Subject: RE: [ cf-dev ] CSV to query
> 
> 
> Ignore me - it's done in <cfhttp>.
>  
> Thanks for the help.  ;)
>  
> Tim.
> 
> ________________________________
> 
> From: Tim Blair [mailto:[EMAIL PROTECTED]
> Sent: Mon 01/03/2004 12:10
> To: [EMAIL PROTECTED]
> Subject: [ cf-dev ] CSV to query
> 
> 
> 
> Brain ache...
> 
> Trying to read in a CSV file and use it as a query object.  I 
> know there's something that can do it but I'm having Monday 
> issues...  Any suggestions?
> 
> Tim.
> 
> 
> 
> 

--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]

Reply via email to