--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:

> With large browses of names. I placve an alphabet across the top of the
> page. Each letter is href'd to a where clause of the that letter. For dates,
> I'd place months in say a drop down and confine the first view of records to
> merely that month. Or a start finish value.

I'm kinda leaning down a path of something like this. I'm using the Flexigrid Ajax grid for this (its a PHP app with FB backend) and it looks stunning, and works great. But sometimes I think its offering the user too much flexibility.

I'm in the process of trying to scale back when to use this based on size of the dataset. I have to continually ask myself if its worth giving the user that level of view, if 99% of the time they are just trying to find one record. But there are many cases where a list is required (ie. looking at an audit log, etc.) and this is such a beautiful piece of technology for that.

Do you know of anyway that, within a stored procedure, you can get a total number of rows returned from a query, without having to either loop through the rows and count them, or use a count(*) within the query itself?

Myles