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] > > > > > > > > > > > > > > ______________________________________________________________________ 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
