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
