Please search the archives. This question comes up a lot and in fact
examples were just posted within the last two days, along with a large
discussion. There's a really straightforward solution that gives you full
power of dynamic connection strings in CFMX.
Good luck,
Sam
-----------------------------------------------
Blog: http://www.rewindlife.com
Charts: http://www.blinex.com/products/charting
-----------------------------------------------
> -----Original Message-----
> From: Richard Castrios [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 25, 2003 5:23 PM
> To: CF-Talk
> Subject: RE: connectString workaround?
>
> Thanks!
>
>
> Could you give an example of how to approach this using
> dynamic data sources?
>
> Rick
>
> -----Original Message-----
> From: Ben Forta [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 25, 2003 3:41 PM
> To: CF-Talk
> Subject: RE: connectString workaround?
>
> If you have text files then you should still be able to use
> the ODBC text driver, specify the directory, and use the
> JDBC-ODBC connector to use it in CF. The "table" is the file
> name. I have not tried this with CFMX, but I think it should work.
>
> --- Ben
>
> -----Original Message-----
> From: Richard Castrios [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 25, 2003 3:25 PM
> To: CF-Talk
> Subject: connectString workaround?
>
> Hi,
>
> I am trying to find a workaround for the (deprecated from
> CFMX) connectString attribute in CFQUERY. Has anyone been
> able to get around this new limitation. We were previously
> using the MERANT text driver in ver.
> 5
> that allowed us to read a .txt file into a query while
> getting the schema information from the QETxt.ini file in the
> same directory. We need the dsn'less connection because we
> have hundreds of potential text files that can be accessed
> dynamically from the client. See code sample below.
>
> thanks
>
> Rick
>
> <cfquery
> name="QueryMyFile"
> dbtype="dynamic"
> connectstring="DRIVER={MERANT 3.70 ColdFusion OEM 32-BIT
> TextFile (*.*)}; SERVER=local);
> UID=user;PWD=;DBQ=#fName#.txt;DB=#fDir#;APP=;WSID="
> blockfactor="50"
> >
> SELECT '#trim(Col_desc_NameArray[iCol])#' as CountBy,
> count(distinct #trim(arrColNames[iCol])#) as CountD,
>
> count(#trim(arrColNames[iCol])#) as CountResult FROM #myfile#
> </cfquery>
>
> _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
