Query in ASP

[murugesanks]

I have a query, which will get data from DATABASE and store in to a RECORD SET. Is there any technique to display specified records like " Disply only 51'st records of 100 records , etc.."

Please Help me.
Murugesan

 

[yaakov]

Murugesan hi

you can limit the number of records by SQL Query
for example

SELECT TOP 50 COL1,COL2
FROM TABLE1

It will return only first 50 records that answer the query

I hope it helps
Yaakov

 

[asptim]

Check out

http://www.aspfaq.com/faq/faqShow.asp?fid=16

. There is an excellent article listed / link and I've used it personally and it works great for just such a project..

Tim