Grabbing last entry

Results 1 to 3 of 3

Thread: Grabbing last entry

  1. #1
    Join Date
    Dec 1969

    Default Grabbing last entry

    I have some code where I insert an entry, then immediately attempt to grab that exact entry out(cuz I need the ID). I try XXX.MoveLast, but I get a rowset cannot fetch backwards error. I&#039m extremely new to ASP, the book I have doesn&#039t help that much, so what is the syntax to order my results by the field ID in descending order?

  2. #2
    scopeout Guest

    Default RE: Grabbing last entry

    When you submit you entry to your.asp, is it possible to have your.asp to requery your entry?<BR><BR>SELECT * From your table <BR>and then Response.Write

  3. #3
    -Rob- Guest

    Default RE: Grabbing last entry

    Is your backend database Access or SQL Server?<BR>SQL Server has means to acquire the identity value via store procedure when the record is added.

Posting Permissions

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