Counting db results?

[matt shudy]

Hi,

Is there a way to make a custom query to count the records
returned by the db? I have a search results page that
filters out results by month and by year, I want a count
of the records that changes based on what the user chooses.

Thanks,

Matt

 

[Chris Kasten]

Hi,

Is there a way to make a custom query to count the records
returned by the db? I have a search results page that
filters out results by month and by year, I want a count
of the records that changes based on what the user chooses.

Thanks,

Matt

Perhaps a custom query like:

Select count(*) from myTable
where stuff = ::fieldonForm:: and otherStuff = :therFieldonForm::

might work?

 

[matt shudy]

Thanks!!

Matt