That's more or less what I have now ... (correct me if I'm wrong) Your first group is
the date. Your asking to display 10 records at a time by using startrow and maxrow in
the output tag. You may be displaying 10 dates, but you are actually displaying
something like 40 rows on the page.
What I want to do is limit the number of rows that are returned so that if I tell it
to display 10 at a time it stops aftwer 10 rows and not 10 categories with all
associated rows.
Thanks
---------- Original Message ----------------------------------
From: [EMAIL PROTECTED] (paul smith)
Date: Wed, 27 Sep 2000 18:51:15 -0700
>If I understand you correctly, you have a varying number of records per
>city. To display results from the first 10 cities you have to do a lot of
>arithmetic to track where one city stops and the next begins.
>
>I did this at http://www.bike70th.com/ where the grouping was by Day.
>
>Let me know if you want the template.
>
>best, paul
>
>At 12:50 PM 9/27/00 -0400, you wrote:
>>Does anyone have any suggestions as to how when I tell the query to output
>>1 - 10 it doesn't output the first 10 hits in the top group but counts
>>from a sub group?
>
>
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
