You might be able to use the List functions to acheive what you want.
You can find them in the CF Documentation.
Here are a few.
ListToArray()
ListFind()
ListFindNoCase()
ListFirst()
ListSort()
Etc.
Also, <cffile> might come in handy to read the TXT file.
David Livingston
General Bandwidth
512.681.5794
[EMAIL PROTECTED]
-----Original Message-----
From: Jean [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 2:41 PM
To: [EMAIL PROTECTED]
Subject: querying a comma delimited list
I have NO idea how to write a query on a comma delimited list. I know
that a txt file can be a datasource, but what are the limitations on
the setup of the file itself, registering the datasource, and querying
it? The extent of use that we will have from this file are selects and
select where -blank- starts with "R" etc.
=====
Veni, Vedi, Velcro.
I came, I saw, I stuck with it.
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
