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]
