You cannot nest CFOUTPUT tags with different queries. You CAN, however, nest CFLOOP tags inside CFOUTPUT tags, as well as other CFLOOP tags.
-- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -----Original Message----- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 10:43 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE!!!! Actually after I get the result which are dates I take the dates from query1 and put up against the dates in query2, but query1 returns all the dates I need query2 returns only one result, but if I go outside the cfoutput tags and use query="query2" attribute on the cfoutput it will return the right amount of results, but I just can't find a way to do it in the cfouput statement that I have. I tried an array and a list function neither one worked.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -----Original Message----- From: Sharon DiOrio [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:39 PM To: CF-Talk Subject: Re: Returning only one record HELP PLEASE!!!! OK, so are the results in query2 dependent upon what's returned in query1 or is it just listing the query results everytime? Sharon ----- Original Message ----- From: "LANCASTER, STEVEN M. (JSC-OL) (BAR)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 1:24 PM Subject: RE: Returning only one record HELP PLEASE!!!! > query2 can output up to 7 records.. > > Steven Lancaster > Barrios Technology > NASA/JSC > 281-244-2444 (voice) > [EMAIL PROTECTED] > > > > -----Original Message----- > From: Sharon DiOrio [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 26, 2002 12:24 PM > To: CF-Talk > Subject: Re: Returning only one record HELP PLEASE!!!! > > > OK, is query2 only *supposed* to be outputting one record? > > I don't think you need to group the first query: > > <CFMAIL TO="[EMAIL PROTECTED]" FROM="[EMAIL PROTECTED]" SUBJECT="test" > QUERY="query1"> > #column1# &nbps; #query2.column2# > </CFMAIL> > > Sharon DiOrio > ----- Original Message ----- > From: "LANCASTER, STEVEN M. (JSC-OL) (BAR)" > <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, March 26, 2002 1:02 PM > Subject: RE: Returning only one record HELP PLEASE!!!! > > > > I am not allowed to post data. but what I put out is very close to what I > > have.. > > > > I have multiple records in both tables and query2 is only outputting one > > record. > > > > <cfquery Name="query1" Datasource="DSN"> > > Select column1, column2 > > From Table1 > > Where this = that > > </cfquery> > > > > <cfquery Name="query2" Datasource="DSN"> > > Select column12, column22 > > From Table1 > > </cfquery> > > > > <CFOUTPUT Query="query1" Group="column1"> > > > > <CFMAIL TO="[EMAIL PROTECTED]" FROM="[EMAIL PROTECTED]" SUBJECT="test"> > > #query1.column1# &nbps; #query2.column22# <!--- is onlt pulling one record > > ---> > > </CFMAIL> > > </CFOUTPUT> > > > > > > Steven Lancaster > > Barrios Technology > > NASA/JSC > > 281-244-2444 (voice) > > [EMAIL PROTECTED] > > > > > > > > -----Original Message----- > > From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, March 26, 2002 11:54 AM > > To: CF-Talk > > Subject: RE: Returning only one record HELP PLEASE!!!! > > > > > > What are you trying to accomplish? > > > > The GROUP attribute will only work with the QUERY specified in the > top-level > > CFOUTPUT tag. If you have grouped data, the you could join in the second > > table instead of querying it separately. > > > > Please post some sample data so that I can try to help you a little more. > > > > -- > > SCOTT VAN VLIET > > SENIOR ANALYST > > SBC SERVICES, INC > > Tel: 858.886.3878 > > Fax: 858.653.6763 > > Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > > > > > > > -----Original Message----- > > From: LANCASTER, STEVEN M. (JSC-OL) (BAR) > > [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, March 26, 2002 9:49 AM > > To: CF-Talk > > Subject: RE: Returning only one record HELP PLEASE!!!! > > > > > > with that also work with 2 queries? > > > > Steven Lancaster > > Barrios Technology > > NASA/JSC > > 281-244-2444 (voice) > > [EMAIL PROTECTED] > > > > > > > > -----Original Message----- > > From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, March 26, 2002 11:40 AM > > To: CF-Talk > > Subject: RE: Returning only one record HELP PLEASE!!!! > > > > > > I don't get what you are trying to do. The GROUP attribute is to group > data > > for nested output from one query. > > > > EXAMPLE: > > > > (Your Data) > > > > ID NAME COLOR > > ----------------------------------------- > > 1 Quiksilver T-Shirt Blue > > 1 Quiksilver T-Shirt Red > > 1 Quiksilver T-Shirt Green > > 1 Quiksilver T-Shirt Gray > > 2 Volcom T-Shirt Blue > > 2 Volcom T-Shirt Black > > 2 Volcom T-Shirt White > > > > > > (Your Code) > > > > <cfquery name="selProd" datasource="#Application.DSN#"> > > SELECT ID, NAME, COLOR > > FROM PRODUCT > > ORDER BY NAME > > </cfquery> > > > > <pre> > > <cfoutput query="selProd" group="NAME"> > > Product Name: > > #NAME# > > Available Colors: > > <cfoutput> > > #COLOR# > > </cfoutput> > > </cfoutput> > > </pre> > > > > > > (Your Result) > > > > Product Name: > > Quiksilver T-Shirt > > > > Available Colors: > > Blue > > Red > > Green > > Gray > > > > Product Name: > > Volcom T-Shirt > > > > Available Colors: > > Blue > > Black > > White > > > > I use this function often when I have a record which has many records in a > > joined table, so that I can just use one query to grab all of the > necessary > > data for the output. > > > > Hope this helps! > > > > > > -- > > SCOTT VAN VLIET > > SENIOR ANALYST > > SBC SERVICES, INC > > Tel: 858.886.3878 > > Fax: 858.653.6763 > > Email: [EMAIL PROTECTED] > > > > > > -----Original Message----- > > From: LANCASTER, STEVEN M. (JSC-OL) (BAR) > > [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, March 26, 2002 9:24 AM > > To: CF-Talk > > Subject: Returning only one record HELP PLEASE!!!! > > > > > > I have 2 queries and I need to know what to do to fix code that looks like > > this. > > As you will see I am only getting one record from my second query. In the > > cfouput tags I have to specify a query and a group because I have nested > > tags there is a reason for this. I just need to know how to make it work > > this way.. any suggestions? > > > > <cfquery Name="query1" Datasource="DSN"> > > Select column1, column2 > > From Table1 > > Where this = that > > </cfquery> > > > > <cfquery Name="query2" Datasource="DSN"> > > Select column12, column22 > > From Table1 > > </cfquery> > > > > <CFOUTPUT Query="query1" Group="column1"> > > > > <CFMAIL TO="[EMAIL PROTECTED]" FROM="[EMAIL PROTECTED]" SUBJECT="test"> > > #query1.column1# &nbps; #query2.column22# <!--- is onlt pulling one record > > ---> > > </CFMAIL> > > </CFOUTPUT> > > > > Steven Lancaster > > Barrios Technology > > NASA/JSC > > 281-244-2444 (voice) > > [EMAIL PROTECTED] > > > > > > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
