RE: cfoutput group with totals

You could just alter your query slightly and let SQL do the counting for you. -Original Message- From: Toby King [mailto:[EMAIL PROTECTED] Sent: Thursday, November 08, 2007 2:22 PM To: CF-Talk Subject: cfoutput group with totals #authorName# #bookTitle# Hi there I understand

Re: cfoutput group with totals

yes - put the code in the proper place - the outer cfoutput - like in Janet's example -- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com ~| Get involved in the latest ColdFusion discussions, product development sharing, a

Re: cfoutput group with totals

#authorName# #bookTitle# You put the output you want between the two closing tags. Output there will appear once per group after the group details. Just as the tag is being output once per group. This is the same as the content put between the two opening tags that appears once pe

Re: cfoutput group with totals

Hi Toby - Have you tried: #authorName# #bookTitle# #getAuthorsAndBooks.RecordCount# ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/p

Re: cfoutput group with totals

> IS there anyway of controlling this to > limit it to display just once. Yes. Move the totals _outside_ the inner tags. See my previous example. Otherwise, #total# will output multiple times. #authorName# #Books# #total# ~

Re: cfoutput group with totals

Well I have basically got the same. The problem I'm having can be shown below: Harry Potter 1292BB85 $65 Cash 135CC94A $65 Cash Totals $130.00$130.00 Ben Forta 1292BB85 $65 Cash 135CC94A $65 Cash 135CC96B $65 Cash Totals $195.00$195.00$1

Re: cfoutput group with totals

Well I had done this But the problem I have is that I am getting output like this IDTime Amount Erin 1292BB85-06-11-07 12:29 PM 65 135CC94A-06-11-07 04:14 PM 65 Totals$130.00 $130.00 Erin

Re: cfoutput group with totals

> Hoe do you include a count after the books and before the next author > name. Do you mean something like this? #authorName# #bookTitle# total books for this author (#bookCount#) ~~~

cfoutput group with totals

#authorName# #bookTitle# Hi there I understand the piece of code well – so that’s cool – just want to try and enhance the code a fraction. I want to try and place after the list of books for each author a count of the number of books. I tried this but instead of getting the count