Query from Text File without Field Names

[PetersWeb]

Hi,

I have some comma delimeted text files from which I need to run various queries. My only problem is that they don't have the field names on the first line!

I've checked the CF documentation which suggested something like this:

<CFHTTP METHOD=&quot;Get&quot;
URL=&quot;

http://127.0.0.1/orders/june/orders.txt&quot;

NAME=&quot;juneorders&quot;

COLUMNS=&quot;ID, Number,Date&quot;
DELIMITER=&quot;,&quot;
TEXTQUALIFIER=&quot;&quot;&quot;&quot;>

<CFOUTPUT QUERY=&quot;juneorders&quot;>
Order ID: #ID#<BR>
Order Number: #Number#<BR>
Order Date: #Date#<BR>
</CFOUTPUT>

I've used the model shown above and produced the output from the query - without the first line of data!

Can anyone please suggest how I could overcome this? [sig]<p>Peter Toby<br><a href=mailto:webmaster@petertoby.com.au>webmaster@petertoby.com.au</a><br><a href=

http://www.petertoby.com.au>PetersWeb</a><br>My

site is under construction but getting better![/sig]