When I ouput a query I have the ability of adding next/previous buttons and displaying
x number at a time. I call an act_ file above the query and output the query like
this:
cfoutput query="statesearch" group="city" Startrow=#attributes.ItemStart#
MaxRows=#attributes.Display#
where ItemStart and Display are calculated in the act_ file.
I have a query that uses grouping and it is ordered by city, lastname, firstname ...
the query comes back with several hundred hits but maybe only 10 cities.
If I have a startrow of 1 and max rows of 10 it returns all 10 cities and lists all
firstname, lastname rows underneath instead of returning the first 10
firstname/lastname rows.
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?
Thanks!
------------------------------------------------------------------------------
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.
