display recordset

Results 1 to 2 of 2

Thread: display recordset

  1. #1
    victoria Guest

    Default display recordset

    I have 2 asp pages insert.asp and result.asp and I have a db with News table I want to insert a record with the latest news that is not a problem but the problem is how can I display only the last record (the latest news) from the database that is inserted.<BR>Regards<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: display recordset

    I think what you want is something like this...<BR><BR>SELECT TOP 1 *<BR>FROM NEWS<BR>ORDER BY NEWSDATE DESC

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts