RE: Query of queries oddness
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 +, you wrote: >I can't see that the code is correct, could I suggest that you try >(i.e. remove the qualification altogether) > > >#DATELASTMODIFIED#,#NAME#,#SIZE#,#USERNAME# > > >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? > > > > > > >> > > > >> > > > >> #GETDIR.DATELASTMODIFIED#,#GETDIR.NAME#,#GETDIR.SIZE#,#Q1.USER > > > >> NAME# > > > >> > > > > > > > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query of queries oddness
I had the same problem. I usually solve it with aliases
SELECT getdir.name as name, getdir.size as size,
getdir.datelastmodified as datelastmodified , q1.UserName as
UserName
FROM getdir, q1
WHERE getdir.name = q1.fileName
#qq.DATELASTMODIFIED#,#qq.NAME#,#qq.SIZE#,#qq.USERNAME#
Pascal
-Original Message-
From: Cary Gordon [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 16 juli 2002 20:47
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.
SELECTfiles.fileName, users.UserName
FROM files, users
WHERE files.fileOwner = users.UserID
SELECT getdir.name, getdir.size, getdir.datelastmodified,
q1.UserName
FROM getdir, q1
WHEREgetdir.name = q1.fileName
#GETDIR.DATELASTMODIFIED#,#GETDIR.NAME#,#GETDIR.SIZE#,#Q1.USERNAME#
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
__
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query of queries oddness
I can't see that the code is correct, could I suggest that you try (i.e. remove the qualification altogether) #DATELASTMODIFIED#,#NAME#,#SIZE#,#USERNAME# 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? > > > > >> > > >> > > >> #GETDIR.DATELASTMODIFIED#,#GETDIR.NAME#,#GETDIR.SIZE#,#Q1.USER > > >> NAME# > > >> > > > > > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query of queries oddness
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? > > >> > >> > >> #GETDIR.DATELASTMODIFIED#,#GETDIR.NAME#,#GETDIR.SIZE#,#Q1.USER > >> NAME# > >> > > > 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 __ 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
RE: Query of queries oddness
> Errr- could it be because you _reference_ the first query? >> >> >> #GETDIR.DATELASTMODIFIED#,#GETDIR.NAME#,#GETDIR.SIZE#,#Q1.USER >> NAME# >> > 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 __ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query of queries oddness
Errr- could it be because you _reference_ the first query?
>
>
> #GETDIR.DATELASTMODIFIED#,#GETDIR.NAME#,#GETDIR.SIZE#,#Q1.USER
> NAME#
>
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.
>
> name="getdir">
> SELECTfiles.fileName, users.UserName
> FROM files, users
> WHERE files.fileOwner = users.UserID
>
>
> SELECT getdir.name, getdir.size,
> getdir.datelastmodified,
> q1.UserName
> FROM getdir, q1
> WHEREgetdir.name = q1.fileName
>
>
>
>
>
>
> #GETDIR.DATELASTMODIFIED#,#GETDIR.NAME#,#GETDIR.SIZE#,#Q1.USER
> NAME#
>
>
>
>
>
>
> 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
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.
SELECTfiles.fileName, users.UserName
FROM files, users
WHERE files.fileOwner = users.UserID
SELECT getdir.name, getdir.size, getdir.datelastmodified,
q1.UserName
FROM getdir, q1
WHEREgetdir.name = q1.fileName
#GETDIR.DATELASTMODIFIED#,#GETDIR.NAME#,#GETDIR.SIZE#,#Q1.USERNAME#
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
