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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
