Errr- could it be because you _reference_ the first query? > <cfoutput query="qq"> > > #GETDIR.DATELASTMODIFIED#,#GETDIR.NAME#,#GETDIR.SIZE#,#Q1.USER > NAME#<br> > </cfoutput>
Notice you say getdir.whatever? This is the first query. You are looping over 'qq' though. ======================================================================= Raymond Camden, ColdFusion Jedi Master for Macromedia Email : [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Cary Gordon [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 2:47 PM > To: CF-Talk > Subject: Query of queries oddness > > > 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.USER > NAME#<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
