Thanks It's always the small stuff that trips you ;o)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 9:37 AM To: CF-Talk Subject: Re: QOQ with <CFDIRECTORY> WHERE drawinfo.name IN('B10000-MAN-R1-TOP.jpg','B10000-R1051-R1.jpg') You need more single quotes in there. On Thu, 6 Jun 2002, Bruce, Rodney S HQISEC/SIGNAL wrote: > Hello all > > Can anyone see any errors in this code?? > > The <cfdirectory> works the files are displayed in the output. > but the qoq "filelist" returns 0 records. No errors a being thrown I can > see. > I have verified the two records in the list are in the directory, they can > be seen in the list when displayed. I have double checked the spelling of > the file names in the list. > Was wondering if the "-" in the file names could be causing a problem?? > > > <cfdirectory name="drawinfo" action="LIST" directory="#DIR#" > > > <!----out put file list to show cfdirectory is working-----> > <CFOUTPUT query="drawinfo"> > #drawinfo.name#<br> > </CFOUTPUT> > > <!----select files in a list---------> > <cfquery name="filelist" dbtype="query"> > SELECT * > FROM drawinfo > WHERE drawinfo.name IN('B10000-MAN-R1-TOP.jpg , > B10000-R1051-R1.jpg') > </cfquery> > > <CFOUTPUT> > ---#filelist.recordcount#--- > </CFOUTPUT> > > Thanks for any help > Rodney > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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