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
>
______________________________________________________________________
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
