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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists