You can set up a datasource to an empty access database, send sql comments
to that, and use either the from or in clause to redirect the query to
another odbc datasource.  I have an explanation and example here:

http://www.rewindlife.com/archives/000118.cfm

Best regards,

Sam

> -----Original Message-----
> From: Claude Schneegans [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 28, 2004 4:17 PM
> To: CF-Talk
> Subject: Using DNS-Less connections
>
> Hi,
>
> Since CF 5, it is possible to CFQUERY directly DNS-Less
> databases using dbtype="DYNAMIC"
>
> For some drivers like text drivers for CSV files (Microsoft
> or Merant), some optional parameters
> may be used to specify delimiters, column names in first row, etc.
>
> Can some one tell me where I can find a good documentation
> about all these parameters?
>
> Thanks.
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to