If last record then redirect

edgarv · June 30th, 2010, 11:04 AM

Hello,

I am new to asp and programming. I am trying to complete a form I have successfully don the input and edit. I have been asked that on the edit page if the user edits the last question then the user gets re-directed to another page.
Could I do something like

Code:

If objRS.AbsolutePosition = last then response.redirect(mypage.asp)

I would really appreciate any kind of advice or help

Thank you!!

Old Pedant · June 30th, 2010, 04:40 PM

?? Do you mean *AFTER* he edits the last record? That is, after you have saved the edit results back to the DB?

Or do you mean that you ignore his edits to that record and just run off to the other page?

It's a little hard to give you a general answer without knowing more about how you are doing things. Do you present the user with MANY records to edit, all on the same web page?

Or does the user have to edit all the records one at a time, from start to finish, one per web page?

edgarv · June 30th, 2010, 05:04 PM

Old Pedant,
It would be after the user edits the last record, it does not matter if he/she has filled out all the other questions. if the last record gets updated then redirect to signature page

Old Pedant · June 30th, 2010, 06:08 PM

Okay, but what is the definition of "last record". Databases do *NOT* have any inherent concept of record ordering. The only way you define a "first record" or "nth record" or "last record" is to use an ORDER BY in your SQL query.

So I'm going to make some assumptions, as you didn't fill me in with more details:

-- I assume that your query that gets the records is doing "ORDER BY xyzID"
-- I assume that in your <form> you have stored that xyzID into some field
. . (presumably via <input type="hidden" name="id" value="<%=RS("xysID"%>" /> or equivalent)

So it's pretty easy:

On the page that the <form> submits to you will get all the form fields:

Code:

<%
id = Request("id")
name = Request("name")
framitz = Request("framitz")
 
' update the record with the given id
SQL = "UPDATE table SET name = '" & name & "', framitz='" & framitz & "' WHERE xysID = " & id
conn.Execute SQL
 
Set RS = conn.Execute( "SELECT MAX(xysID) FROM table" )
maxid = RS(0)
RS.Close
 
If maxid = id Then Response.Redirect "youAreDone.asp"
...
%>

You see? I am using MAX(xysID) because that matches the "ORDER BY xysID" that was used to populate the <form>.

If you showed me more details of your situation, there might be a slightly different answer, but it would be close to the same.