I want to display news records returned from a access database on a web page. How can I restrict the query where always " top 6 records are displayed".
the fields in my database are id,title,headlines,date_posted .
Please help.

Create a hidden EntryDate field in order to later sort your queries to the DB.

Then do a decrement "for" loop counting down from 6...placing the articles on your page until the loop quits.

Please provide table structure and I will be happy to help.



Sal

******* Connection *******
******* Execute Sql Query *******

Dim i
i = 1
Rs.MoveFirst
For i = 1 to 6
Rs.Fields ("News")
Rs.Fields ("Details")
Rs.Movenext
Next

If you could post details, I can help you with re-writing code ...
Best Regards
Burak Balibey

Provide the following if you are still interested,
-Database being used and version (Access 2000, 2002, SQL Server 2000, 7)
-Table Structure (table name, and field names)

There is a way to query the database and get exactly 6 records back.

If Access is your front end

Sample code

SELECT TOP 6 YourTable1.FieldToReturn
FROM YourTable1
ORDER BY YourTable1.FieldToReturn DESC;

If you want the bottom, sort ASC



Sal

Thanks sal,
Table name : news
Fields : id (Autonumber) , Headline(text), news_story(text), date_posted(date)
Database : Access 2002

I want to run a asp code that returns exaclty top 6 headlines from the database .
I will appreciate your help.

SELECT TOP 5 news.*
FROM news
ORDER BY news.id DESC;

I suppose you want the latest six.

there is no need for a loop inside your code.

Sal