Re: cfoutput -- group and maxrows problem

2004-09-09 Thread C . S . A . Wilkens
Thanks for all the tips! I had thought about using my own counter, but thought it wouldn't work with pagination tools like cf_recordcount. Of course, they can be work together! It's up and running like a charm now. For what it's worth, here's how I integrated my homemade counter with the cf_record

RE: cfoutput -- group and maxrows problem

2004-09-07 Thread Cornillon, Matthieu (Consultant)
#publication_title#      #author_name#     But the maxrows attribute goes by the query record count, rather than the count of unique publication_titles. So instead of seeing 10 records per page, I may get 6 or 9 or 7--the system is counting each author row and thinks it's reached 10 before i

Re: cfoutput -- group and maxrows problem

2004-09-07 Thread Douglas Knudsen
I'm sure there are many ways to approach this.  One way, remove the maxrows attribute and create your own counter. #publication_title#      #author_name#         Another way is to make sure you return only rows for your top 10 articles via SQL. Got a 'Jedi' Oracle DBA?  Have them crea

Re: cfoutput -- group and maxrows problem

2004-09-07 Thread S . Isaac Dealey
> ...which gives me multiple rows for publications with more > than one author.  So Pub 1-Auth1, Pub1-Auth2, Pub2-Auth3, > Pub3-Auth4 = 4 rows for 3 records. My output uses grouped > nested cfoutputs for display, essentially like this: > > maxrows="10"> >  #publication_title# >    >  #author