return user defined number of results in a search???

[bjgrem]

I am working on a records database and i need to know how to make a search where the user selects a number of results to display from a drop-down list.

 

[NickBulka]

Please supply a little more info. Do you need help with a SQL query? Syntax for getting values from a select list? How to create a paged view with a certain number of records? <p>nick bulka<br><a href=mailto: > </a><br><a href=

http://www.bulka.com>

</a><br>Get your technical books at Bulka's Books<br>

http://www.vstorebooks.com/bulkasbooks

 

[bjgrem]

The database is SQL, and i need to create a view with a certain number of records displayed per page (say, first 20 on this page, next 20 on next page... etc.) <br><br>thanks.

 

[PatHastings]

how about<br><br>intResults = request.form(&quot;NumOfResults&quot<br>strSQL = &quot;select top &quot; & intResults & &quot; * from table&quot;<br><br>where NumOfResults is the drop down box in the previous form<br><br>If you are trying to view the results of a search X records at a time then there is a thread in the ASP forum that will benifit you &quot; Onlys showing X records at a time&quot;<br><br>Pat