Hello all,
I am not able to nest queries in a CFMail, how do you
have more than one query in a CFmail, i cant group it either,
some like
<cfquery name="Get_emails_Shipto" datasource="test">
select Shipto_id,email_addr from ShipToTable
</cfquery>
<cfquery Name="Get_Orders" datasource="test">
Select OrderPart, OrderQty from OrdersTable where
OrderId="#Get_emails_Shipto.ShipTo_id#"
<cfloop query="Get_emails_ShipTo">
<Cfmail from="[EMAIL PROTECTED]" to="#Get_emails_ShipTo.email_addr#"
type="HTML" subject="test" query=>
<Cfoutput>
#Shipto_id#,#email_addr#
</cfoutput>
<!---******* this is not working ***********--->
<cfoutput query="Get_Orders>
#OrderPart#, #OrderQty#
</cfoutput>
</cfmail>
</cfloop>
What am i doing wrong here???
Appretiate any help
Thanks
Joe
-----
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
