Oops The datasource thing is what you're after.
Sorry
-----Original Message-----
From: David DiPietro [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 4:37 PM
To: CF-Talk
Subject: RE: ODBC and cvs files
This is how I do it
<cfset RostersOut='#session.userID#'&'PreceptorRosters.csv'>
<cfset RostersFile='DriveLetter:\Path\Path\Path\Path\#RostersOut#'>
<cfset RostersPath='\Path\Path\Path\Path\#RostersOut#'>
<cfset RostersFileName='#RostersOut#'>
<form action='../GeneratedFiles/#RostersFileName#' method="Get" target=_Self
enablecab="No">
<input type='hidden' name='file' value='#RostersPath#'>
<input type="Submit" value = "Send #RostersOut# File to Excel">
</form>
<cfset toutput="something1,something2,something3">
<CFFILE ACTION="Write" FILE="#RostersFile#" OUTPUT="#toutput#" ADDNEWLINE="Yes">
<cfset toutput =
'"#attributes.something1#","#attributes.something2#","#attributes.something3#"'>
<CFFILE ACTION="Append" FILE="#RostersFile#" OUTPUT="#toutput#" ADDNEWLINE="Yes">
The user then clicks the form button and it appears
HIH
David
-----Original Message-----
From: Mario Martinez R. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 1:49 PM
To: CF-Talk
Subject: ODBC and cvs files
Hi friends:
I'm trying to make a query from a csv file
(test1.csv).
The way I thought was to make an ODBC entry for text
files . In the ODBC entry I only can specify the
directory not the file name.
So I guessed I had to include that in the final query.
There is something I'm missing .
I will appreciate your help.Any new ideas could be
great too.
Down the code and what I see in my browser .
Thanks for any help
Mario
//my code
<cfquery name="InstrLedAttQuery"
datasource="EkOutsideFiles" dbtype="ODBC">
SELECT * FROM test1.cvs
</cfquery>
//What I get in my browser
Error Diagnostic Information
ODBC Error Code = 42000 (Syntax error or access
violation)
[Microsoft][ODBC Text Driver] Cannot update. Database
or object is read-only.
The error occurred while processing an element with a
general identifier of (CFQUERY), occupying document
position (199:1) to (199:75).
Date/Time: 03/11/02 12:20:20
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows
NT 5.0)
Remote Address: 66.109.35.50
_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
