Thanks chaps...spot on.
> -----Original Message-----
> From: Philip Arnold - ASP [SMTP:[EMAIL PROTECTED]]
> Sent: 10 July 2001 14:49
> To: CF-Talk
> Subject: RE: Using a text file as a datasource
>
> > I'm trying to set up a text or csv file as a datasource in the CF
> > administrator. Each time I try to set up an ODBC datasource with the
> > Microsoft text driver, the connection to the datasource fails.
> > Does anybody
> > know how to get this to work? The server is an NT box.
>
> Text ODBC datasources are actually set to directories, not the file, then
> in
> the query you use;
> select field1, field2
> from myFile.txt
>
> where "myFile.txt" is the name of the file
>
> I've used them before - not particularly quick, but they work
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **********************************************************************
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
