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
#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
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
> ...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
4 matches
Mail list logo