Classic ASP Discussion - can some one help me please

Print Page | Close Window

can some one help me please

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=4173
Printed Date: 30 March 2026 at 10:06am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: can some one help me please

Posted By: makit4u
Subject: can some one help me please
Date Posted: 10 July 2003 at 3:59am

I have a members area that uses the script found on this site for mebers login.

To add a user to the database one has to do this by hand. I want to do a page that lets users add ther own name and details to the database from a submit button.

The database is called users

the table is tblusers

the fields are userid and password

Any help on this Please. Cut and paste would be good.

Replies:

Posted By: zMaestro
Date Posted: 10 July 2003 at 5:13pm

here is a code... but use at your own risk

dim dsn
dim Conn
dsn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("./users.mdb")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open dsn

dim RS
dim SQL
Set RS = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT * from tblusers"
RS.Open SQL, Conn, 1, 3

RS.AddNew
RS.Fields("userid") = Request.Form("userid")
RS.Fields("password") = Request.Form("password")
RS.Update
RS.close

Conn.close
Set Conn = Nothing

Posted By: zMaestro
Date Posted: 10 July 2003 at 5:15pm

i think u will need another form to change (update) data from it, and a forget password form too.. and also code to check if the user name exists or not... i don't know if you want all this or just this code.