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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
