One other question for you, this works but it gives me all the records for
the first query in the output. How would I based on the first query output
the second, which is then based on the third.
ex:
first tbl = clients
second tbl = projects
third tbl = tasks
I want the output based on client and then their projects then the
tasks. how would the code differ from what you have already supplied?
At 04:06 PM 9/25/00 +0100, you wrote:
><cfoutput query="qry_numberone">
>
> ... HTML here ...
>
> <cfloop query="qry_numbertwo">
>
> .. HTML here ...
>
> <cfloop query="qry_numberthree">
>
> ... HTML here ...
>
> </cfloop>
>
> </cfloop>
>
></cfoutput>
>
> > -----Original Message-----
> > From: Dan Donnick [SMTP:[EMAIL PROTECTED]]
> > Sent: 25 September 2000 15:42
> > To: CF-Talk
> > Subject: how to nest queries
> >
> > I have 3 queries, what would the code look like to output HTML in the
> > middle.
> > ______________________________
> >
> > Dan Donnick
> > Cold Fusion Developer
> > Bixler Incorporated
> > 1250 24th Street
> > Suite 250
> > Washington, DC 20037
> >
> > Phone: (202) 686-5800
> > Fax: (202) 686-5801
> > Email: [EMAIL PROTECTED]
> > ______________________________
> >
> > --------------------------------------------------------------------------
> > ----
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> > the body.
>
>
>-----------------------------------------------
>Any opinions expressed in this message are those of the individual and not
>necessarily the company. This message and any files transmitted with it
>are confidential and solely for the use of the intended recipient. If you
>are not the intended recipient or the person responsible for delivering to
>the intended recipient, be advised that you have received this message in
>error and that any use is strictly prohibited.
>
>Sapphire Technologies Ltd
>http://www.sapphire.net
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
______________________________
Dan Donnick
Cold Fusion Developer
Bixler Incorporated
1250 24th Street
Suite 250
Washington, DC 20037
Phone: (202) 686-5800
Fax: (202) 686-5801
Email: [EMAIL PROTECTED]
______________________________
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.