There's a custom tag (http://www.halhelms.com/index.cfm?fuseaction=code.detail) and a udf (http://www.cflib.org/udf.cfm?ID=255), either of which should help with creating the recordset, and personally, i'd say that was prefereable to using CFHTTP for a number of reasons.
Having said that, looking at your example data, they may have trouble dealing with escaped delimiters and might need a bit of tweaking...
HTH
Bert
-----Original Message-----
From: Jim T [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 10:55 AM
To: CF-Talk
Subject: Query of a text file
I am Stuck .. can someone help?
I am getting this error:
Attribute validation error for tag cfoutput.
The value of the attribute query, which is currently "thefile", is
invalid.
this is the text filetop of the text file:
Code,page,title,unit,price
884,248,LIGHTED ROSE BASKET,1 EA,9.95
1402,194,3 PC BRASS BUTTERFLY WALL SET,1 SET,6.30
1506,91,BRASS/SHIPS CARGO LANTERN,1 EA,53.30
1875,175,10 PC PORC COBALT BLUE TEA SET,1 SET,3.65
1932,54,"CHILDREN'S PLAQUE",1 EA,2.65
2018,303,100 BR/BELL WIND CHM,1 EA,2.95
This is the code:
<!--- Get the file --->
<cfhttp url=""> method="GET"
Name="thefile">
</cfhttp>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
