2. ASPRunnerPro General questions
  3. anyone over me some help please
This topic is locked

anyone over me some help please

 		7/14/2003 8:19:14 AM
ASPRunnerPro General questions
letscreate4u author

I have a database login page for a members area.

what i want to do is using a submit button let users put there user name and password in to the database.
the database is called users

the table is call tblusers

the fields are userid and password.
so what i want to do is after the user pays with paypal to get in to the members area is to let them add there user name and password to the database.

the web page has the stuff from ibill plus to text boxes with which the user puts in the details.
User name:

Password:
and a submit button so that when i click on the submit it adds those details to the database.
I have worked at this now till i am blue in the face with no results.

Please anyone help me .

oh yes the site is all in ASP.

Richard
Sergey Kornilov admin 7/14/2003

Richard,
you need something like this:

if Request.Form("userid")<>"" and Request.Form("password") <>"" then
strSQL = "insert into tblUsers (user, password) values ('" & _

Replace(Request.Form("userid"),"'","''") & "','" & _

Replace(Request.Form("password"),"'","''") & "')"
dbConnection.Execute strSQL
end if


I hope this helps.
Sergey Kornilov
letscreate4u author 7/14/2003

worked a treat thanks.

But if anyone else has some good code then post it.

Richard