yes Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED]
-----Original Message----- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:23 PM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE!!!! At 12:02 PM 3/26/02 -0600, LANCASTER, STEVEN M. (JSC-OL) (BAR) wrote: ><cfquery Name="query2" Datasource="DSN"> >Select column12, column22 > >From Table1 ></cfquery> If you just do this: <CFOUTPUT Query="Query2"> <BR> #Column12, #column22# </CFOUTPUT> Do you get multiple records? ><CFOUTPUT Query="query1" Group="column1"> > ><CFMAIL TO="[EMAIL PROTECTED]" FROM="[EMAIL PROTECTED]" SUBJECT="test"> >#query1.column1# &nbps; #query2.column22# <!--- is onlt pulling one record >---> You could do something like this: Create a new file called Query2loop.cfm looking like this: <CFOUTPUT Query="Query2"> #Column22$ Then do <CFOUTPUT Query="query1" group="column1"> <CFMAIL....> #column1# <CFINCLUDE template="Query2Loop.cfm"> </CFOUTPUT> That way it'll loop through the first query and then do a nested loop through the second. T ______________________________________________________________________ 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
