Ian,
How about using two loops? You'd still make just one query. In the
first loop, print only item name, quantity, line total. In the second
loop, print only tax, shipping, grand total.
-David
On 8 Apr 00 21:16:35 MST Ian <[EMAIL PROTECTED]> writes:
> Hello,
>
> I am trying to send out an order confirmation e-mail with the
> following
> information:
>
> item name, quantity, line total, tax, shipping, grand total.
>
> The problem is that since the query is in the CFMAIL properties, it
> loops over
> all of the fields giving me this nasty result:
>
> item name1 quantity1 line total1
>
> shipping
> tax
> total
> item name2 quantity2 line total2
>
> shipping
> tax
> total
>
>
> How can I get the shipping, tax and total to only print once?
>
> Thanks,
> Ian
>
>
> ____________________________________________________________________
> Get your own FREE, personal Netscape WebMail account today at
> http://webmail.netscape.com.
>
-------------------------------------------------------------------------
-----
> 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.
________________________________________________________________
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
------------------------------------------------------------------------------
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.
