You can write the query in such a way that you do not select the
records with the filenames u have listed below
You can use not in ( 'test1.txt','text2.txt','tst3.txt',... ) clause
Then in that case u need not have any loop to ignore these...
> -----Original Message-----
> From: phumes1 [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, May 06, 2002 6:25 PM
> To: CF-Talk
> Subject: Re: Looping...
>
> Hi,
>
> I have the following code that lists a directory structure but ignores the
>
> files listed below.
>
>
> Is there a way to have the files below read in from a database and then
> loop through field to eliminate all the code below?
>
> The database field would be as follows:
>
> test1.txt,text2.txt,tst3.txt,txt4.txt,test5.txt,text6.txt,tst7.txt,txt8.tx
> t
>
>
> <cfloop index="LineNo" from=#i# to=#i#>
> <cfif Session.stDirFileType[i] eq "File">
> <cfif Session.stDirFileName[i] is not "test1.txt"
> and
> Session.stDirFileName[i] is not "text2.txt" and
> Session.stDirFileName[i] is not "tst3.txt" and
> Session.stDirFileName[i] is not "txt4.txt" and
> Session.stDirFileName[i] is not "test5.txt" and
> Session.stDirFileName[i] is not "text6.txt" and
> Session.stDirFileName[i] is not "txt7.txt" and
> Session.stDirFileName[i] is not "txt8.txt">
> </cfif>
> </c
>
>
> +-------------------------------------------------------------------------
> ----------+
>
> Philip Humeniuk
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> +-------------------------------------------------------------------------
> -----------+
>
>
>
______________________________________________________________________
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
