Please send
comments/questions to
michael@
teratech.com

Nested Query Loop Example

<CFQUERY NAME="GetEmail"   DATASOURCE="Library">

   SELECT Email , SecurityLevel  FROM Customer

</CFQUERY>

<CFLOOP QUERY="GetEmail">

   <CFQUERY NAME="GetText" DATASOURCE="Library">

      SELECT EmailText, EmailSubject FROM Messages

      WHERE  SecurityLevel = #GetEmail.SecurityLevel#

   </CFQUERY>

    <CFMAIL QUERY="GetText"

      TO="#GetEmail.Email#"

      FROM="[email protected]"

      SUBJECT="#GetText.EmailSubject#"

      SERVER="smtp.mycompany.com">#GetText.EmailText#

   </CFMAIL>

</CFLOOP>

Previous slide

Next slide

Back to first slide

View graphic version