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]
