This topic is locked

Limited count of records with filter

4/22/2005 7:06:30 AM
ASPRunnerPro General questions
Pfeiffer author

Hello,

I'm lucky about the new version. !!! Your are doing a very good job !

Can I prevent the user from filtering (and displaying) thousands of

records. For example I only want to allow a maximum of 20000 records as the result of a filter.
If the filter has more records the user will get the information that he has to

reenter a better filter...

Otherwise my database will work..and work...and work...
Thanks

Uwe Pfeiffer

Sergey Kornilov admin 4/25/2005

Uwe,
you need to use LIMIT clause in SQL query directly before execution to limit records displaying.