I am having what I see as an anomalous issue with a query of queries. The code and the results are below.
One of the queries is a cfdirectory listing. cfdump'ing the query of queries ("qq") returns the correct data, but outputting it does not. Somehow, the cfoutput of the query of queries is returning the info from the first row of the cfdirectory listing, rather than the row that matches the test. <cfdirectory action="LIST" directory="D:\NISO-AZ\files\" name="getdir"> <cfquery name="q1" datasource="#DSN#"> SELECT files.fileName, users.UserName FROM files, users WHERE files.fileOwner = users.UserID </cfquery> <cfquery name="qq" dbtype="query"> SELECT getdir.name, getdir.size, getdir.datelastmodified, q1.UserName FROM getdir, q1 WHERE getdir.name = q1.fileName </cfquery> <cfdump var="#qq#"> <cfoutput query="qq"> #GETDIR.DATELASTMODIFIED#,#GETDIR.NAME#,#GETDIR.SIZE#,#Q1.USERNAME#<br> </cfoutput> <cfdump var="#getdir#"> <cfdump var="#q1#"> Results... TDIR.DATELASTMODIFIEDGETDIR.NAMEGETDIR.SIZEQ1.USERNAME 07/11/2002 11:53:30 AM testfile.txt 9 Cary Gordon 07/11/2002 04:50:31 PM,.,0,Cary Gordon ATTRIBUTESDATELASTMODIFIEDMODENAMESIZETYPE 07/11/2002 04:50:31 PM . 0 Dir 07/11/2002 04:50:31 PM .. 0 Dir A 07/11/2002 11:53:30 AM testfile.txt 9 File FILENAMEUSERNAME testfile.txt Cary Gordon ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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