--------------653661AB437C0A7FB3365840
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Jon
I don't think I can say "duh" loud enough ... thanks for the simple solution! ;-)
* john *
Jon Boehnker wrote:
> Try using <cfloop query="myquery">
>
> HTH
>
> Jon
>
> John Mentzer wrote:
> >
> > Hi
> >
> > I'm attempting to embed a table inside a CFMAIL tag. I'd like the table
> > to be dynamic. Problem is, whenever I put a <CFOUTPUT QUERY=""> inside
> > the <CFMAIL> I get the following error:
> >
> > Invalid tag nesting configuration
> >
> > A query driven CFOUTPUT tag is nested inside a CFMAIL tag that also has
> > a QUERY= attribute. This is not allowed. Nesting
> > these tags implies that you want to use grouped processing. However,
> > only the top-level tag can specify the query that
> > drives the processing.
> >
> > Notice there is no Query attribute CFMAIL tag. Why am I getting this
> > error? I tried using the Query attribute of the CFMAIL tag, but the mail
> > tag was getting looped, sending one email for each of the rows returned.
> > That's not quite what I had in mind.
> >
> > *Any* help would be *greatly* appreciated!
> >
> > * John *
> >
> > Here's the CFMAIL tag that's generating the error:
> >
> > <CFMAIL FROM="[EMAIL PROTECTED]" TO="#go_print_customer.email#"
> > SUBJECT="Thank you for your order" TYPE="HTML">
> >
> > <TABLE ALIGN="center" BORDER="0" CELLPADDING="0" CELLSPACING="0"
> > WIDTH="430">
> > <TR>
> > <TD>Here is a summary of your order.</TD>
> > </TR>
> >
> > <TR>
> > <TH WIDTH="25">No.</TH>
> > <TH WIDTH="25">Qty</TH>
> > <TH WIDTH="50">Size</TH>
> > <TH WIDTH="50">Price</TH>
> > <TH WIDTH="125">Total</TH>
> > <TH WIDTH="60"> </TH>
> > </TR>
> >
> > <CFOUTPUT QUERY="gm_print_lineitems2">
> >
> > <CF_go_exp
> > exp = #gm_print_lineitems2.exp#>
> >
> > <CFLOOP FROM="1" TO="18" INDEX="loopA">
> > <CFIF current_print_choices[loopA][1] IS
> > "#gm_print_lineitems2.print_code#">
> > <CFSET current_size = #current_print_choices[loopA][2]#>
> > <CFSET current_price = #current_print_choices[loopA][3]#>
> > </CFIF>
> > <CFSET loopA = 0>
> > </CFLOOP>
> >
> > <TR>
> > <TD ALIGN="right">#gm_print_lineitems2.exp#</TD>
> > <TD ALIGN="right">#gm_print_lineitems2.qty#</TD>
> > <TD ALIGN="right">#current_size#</TD>
> > <TD ALIGN="right">#current_price#</TD>
> > <TD ALIGN="right"> </TD>
> > </TR>
> >
> > <TR>
> > <TD ALIGN="center" COLSPAN="6">
> > <HR COLOR="##4582D2" SIZE="1" WIDTH="80%">
> > </TD>
> > </TR>
> >
> > <CFSET subtotal_prints = subtotal_prints + #current_price#>
> > </CFOUTPUT>
> >
> > <TR>
> > <TD>Subtotal, prints</TD>
> > <TD COLSPAN="3"> </TD>
> > <TD ALIGN="right">#DollarFormat(subtotal_prints)#</TD>
> > </TR>
> >
> > <TR>
> > <TD>Shipping</TD>
> > <TD COLSPAN="3"> </TD>
> > <TD ALIGN="right"> 4.00</TD>
> > </TR>
> >
> > <CFSET total_prints = subtotal_prints + 4>
> > <TR>
> > <TD>Total Order</TD>
> > <TD COLSPAN="3"> </TD>
> > <TD ALIGN="right">#DollarFormat(total_prints)#</TD>
> > </TR>
> >
> > <TR>
> > <TD ALIGN="center" COLSPAN="6">
> > <HR COLOR="##4582D2" SIZE="1" WIDTH="80%">
> > </TD>
> > </TR>
> >
> > </TABLE>
> >
> > </CFMAIL>
> >
> > ------------------------------------------------------------------------------
> > Archives: http://www.eGroups.com/list/cf-talk
> > 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.
>
> --
> Jon Boehnker
> [EMAIL PROTECTED]
>
> -><-
> ------------------------------------------------------------------------------
> Archives: http://www.eGroups.com/list/cf-talk
> 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.
--------------653661AB437C0A7FB3365840
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Jon
<p>I don't think I can say "duh" loud enough ... thanks for the simple
solution! ;-)
<p>* john *
<p>Jon Boehnker wrote:
<blockquote TYPE=CITE>Try using <cfloop query="myquery">
<p>HTH
<p>Jon
<p>John Mentzer wrote:
<br>>
<br>> Hi
<br>>
<br>> I'm attempting to embed a table inside a CFMAIL tag. I'd like the
table
<br>> to be dynamic. Problem is, whenever I put a <CFOUTPUT QUERY="">
inside
<br>> the <CFMAIL> I get the following error:
<br>>
<br>> Invalid tag nesting configuration
<br>>
<br>> A query driven CFOUTPUT tag is nested inside a CFMAIL tag that
also has
<br>> a QUERY= attribute. This is not allowed. Nesting
<br>> these tags implies that you want to use grouped processing.
However,
<br>> only the top-level tag can specify the query that
<br>> drives the processing.
<br>>
<br>> Notice there is no Query attribute CFMAIL tag. Why am I getting this
<br>> error? I tried using the Query attribute of the CFMAIL tag, but the
mail
<br>> tag was getting looped, sending one email for each of the rows returned.
<br>> That's not quite what I had in mind.
<br>>
<br>> *Any* help would be *greatly* appreciated!
<br>>
<br>> * John *
<br>>
<br>> Here's the CFMAIL tag that's generating the error:
<br>>
<br>> <CFMAIL FROM="[EMAIL PROTECTED]" TO="#go_print_customer.email#"
<br>> SUBJECT="Thank you for your order" TYPE="HTML">
<br>>
<br>> <TABLE ALIGN="center" BORDER="0" CELLPADDING="0" CELLSPACING="0"
<br>> WIDTH="430">
<br>> <TR>
<br>> <TD>Here is a summary of your order.</TD>
<br>> </TR>
<br>>
<br>> <TR>
<br>> <TH WIDTH="25">No.</TH>
<br>> <TH WIDTH="25">Qty</TH>
<br>> <TH WIDTH="50">Size</TH>
<br>> <TH WIDTH="50">Price</TH>
<br>> <TH WIDTH="125">Total</TH>
<br>> <TH WIDTH="60">&nbsp;</TH>
<br>> </TR>
<br>>
<br>> <CFOUTPUT QUERY="gm_print_lineitems2">
<br>>
<br>> <CF_go_exp
<br>> exp = #gm_print_lineitems2.exp#>
<br>>
<br>> <CFLOOP FROM="1" TO="18" INDEX="loopA">
<br>> <CFIF current_print_choices[loopA][1] IS
<br>> "#gm_print_lineitems2.print_code#">
<br>> <CFSET current_size =
#current_print_choices[loopA][2]#>
<br>> <CFSET current_price =
#current_print_choices[loopA][3]#>
<br>> </CFIF>
<br>> <CFSET loopA = 0>
<br>> </CFLOOP>
<br>>
<br>> <TR>
<br>> <TD ALIGN="right">#gm_print_lineitems2.exp#</TD>
<br>> <TD ALIGN="right">#gm_print_lineitems2.qty#</TD>
<br>> <TD ALIGN="right">#current_size#</TD>
<br>> <TD ALIGN="right">#current_price#</TD>
<br>> <TD ALIGN="right">&nbsp;</TD>
<br>> </TR>
<br>>
<br>> <TR>
<br>> <TD ALIGN="center" COLSPAN="6">
<br>> <HR COLOR="##4582D2" SIZE="1" WIDTH="80%">
<br>> </TD>
<br>> </TR>
<br>>
<br>> <CFSET subtotal_prints = subtotal_prints + #current_price#>
<br>> </CFOUTPUT>
<br>>
<br>> <TR>
<br>> <TD>Subtotal, prints</TD>
<br>> <TD COLSPAN="3">&nbsp;</TD>
<br>> <TD ALIGN="right">#DollarFormat(subtotal_prints)#</TD>
<br>> </TR>
<br>>
<br>> <TR>
<br>> <TD>Shipping</TD>
<br>> <TD COLSPAN="3">&nbsp;</TD>
<br>> <TD ALIGN="right"> 4.00</TD>
<br>> </TR>
<br>>
<br>> <CFSET total_prints = subtotal_prints + 4>
<br>> <TR>
<br>> <TD>Total Order</TD>
<br>> <TD COLSPAN="3">&nbsp;</TD>
<br>> <TD ALIGN="right">#DollarFormat(total_prints)#</TD>
<br>> </TR>
<br>>
<br>> <TR>
<br>> <TD ALIGN="center" COLSPAN="6">
<br>> <HR COLOR="##4582D2" SIZE="1" WIDTH="80%">
<br>> </TD>
<br>> </TR>
<br>>
<br>> </TABLE>
<br>>
<br>> </CFMAIL>
<br>>
<br>> ------------------------------------------------------------------------------
<br>> Archives: <a
href="http://www.eGroups.com/list/cf-talk">http://www.eGroups.com/list/cf-talk</a>
<br>> To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.
<p>--
<br>Jon Boehnker
<br>[EMAIL PROTECTED]
<p>-><-
<br>------------------------------------------------------------------------------
<br>Archives: <a
href="http://www.eGroups.com/list/cf-talk">http://www.eGroups.com/list/cf-talk</a>
<br>To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.</blockquote>
</html>
--------------653661AB437C0A7FB3365840--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
