[geneane]

How can I use asp/sql to restrict records in a database? Table is products. If more than say 20 records is entered, a message displays.

[Stealth]

select top 20 * from table

[geneane]

What I am tryinng to do is restrict the number of records that can be put INTO a database

...not restrict the number returned.

Thanks.

[Stealth]

you would need to show more info.

who is inserting the data?
why would more than 20 be put in?

e.g if users login and add records individually then its better to add a counter and an if statement. theres no way (that i know of) it can be done otherwise