Actually, that is where I started. All it did was generate column not found errors.
I suspect that the problem lies in the fact that one of the queries is really a cfdirectory call. At 01:55 AM 7/17/2002 +0000, you wrote: >I can't see that the code is correct, could I suggest that you try >(i.e. remove the qualification altogether) > ><cfoutput query="qq"> >#DATELASTMODIFIED#,#NAME#,#SIZE#,#USERNAME#<br> ></cfoutput> > >Cheers > > >From: Cary Gordon <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: CF-Talk <[EMAIL PROTECTED]> > >Subject: RE: Query of queries oddness > >Date: Tue, 16 Jul 2002 15:18:20 -0700 > > > >The code is correct. I did try your suggested changes though. > > > >Apparently, the query of queries needs the original query identifier. You > >can see this in the cfdump and also by outputting a query column list. > > > >At 03:02 PM 7/16/2002 -0400, you wrote: > > > > 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. > > > > > >And #Q1.UserName# should be #qq.UserName# also > > > > > >Isaac Dealey > > >www.turnkey.to > > >954-776-0046 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
