This topic is locked

response.redirect to edit page

5/14/2009 5:44:05 PM
ASPRunnerPro General questions
W
wfcentral author

I have set up a system where a user can only edit their record. Now I want it to go directly to the edit page after login...
I tried
str = "select * from dbo.tbl_registration where email='" & username & "' and cwid='" & password & "'"

Set rstmp = server.CreateObject("ADODB.Recordset")

rstmp.open str,dbConnection
if not rstmp.eof then

Session("studentID") = rstmp("id")
end if
rstmp.close

set rstmp=nothing
'** Redirect to another page ****

Response.Redirect "https://secure.mwsu.edu/spiritdays2009/registration/tbl_registration_edit.asp?editid1="&; Session("studentID")
but it is not working...
maybe I'm going too complex...
it should take them to
https://secure.mwsu.edu/spiritdays2009/regi...sp?editid1=1825
(where 1825 = their id)

Sergey Kornilov admin 5/14/2009

I don't see why it shouldn't work.
What version of ASPRunnerPro do you use? Any error messages?

W
wfcentral author 5/15/2009

I don't see why it shouldn't work.

What version of ASPRunnerPro do you use? Any error messages?


I am using 6.1 build 1971
When I click the login button it goes straight to the list page - in the center of the screen a red box 1" x 1" pops up with a message in it, but it only appears for a fraction of a second and you cannot read it that fast.
I tried replacing the redirect with "www.google.com"; just to make sure the event was THERE and redirecting SOMEWHERE and it did go to google. Put the code back the way it was and it takes me to the list page again...

J
Jane 5/19/2009

It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.