Try this:
<!----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>
Use the commas around each entry desired.
- Ron
-----Original Message-----
From: Bruce, Rodney S HQISEC/SIGNAL
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 12:36 PM
To: CF-Talk
Subject: QOQ with <CFDIRECTORY>
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
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
