Re: cfoutput -- group and maxrows problem

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

cfoutput -- group and maxrows problem

Hi everyone, I'm new to the list, but was driven to subscribe by a problem that's been driving me mad for days. I have three tables: publications, authors, and pub_author. I designed it this way b/c pubs can have multiple authors, and I wanted a controlled list of authors. They're joined like

Re: cfoutput -- group and maxrows problem

...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: cfoutput query=research group=publication_title maxrows=10

Re: cfoutput -- group and maxrows problem

approach, eh? Doug - Original Message - From: Christy Wilkens [EMAIL PROTECTED] Date: Tue, 07 Sep 2004 14:52:45 -0400 Subject: cfoutput -- group and maxrows problem To: CF-Talk [EMAIL PROTECTED] Hi everyone, I'm new to the list, but was driven to subscribe by a problem that's been driving me

RE: cfoutput -- group and maxrows problem

cfoutput query=research group=publication_title maxrows=10 #publication_title# cfoutput #author_name# /cfoutput /cfoutput 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