|
|
|
|
|
| | |
| |
Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Updating DB from information gathered from a form |
|
From: |
Jeremy |
|
Date: |
4/26/2001 4:49:08 PM |
|
IP: |
170.253.240.1 |
I currently have an asp page that pulls information from an access database and builds an html table with that information. I also have a form with three text boxes and a submit button. When the buttonis submitted I have an IF statement within the same page of code that performs an update to the database based on the users id. Here is the code:
If (Request.Form("Submit") = true) then
name = request.form("companyname")
number = request.form("phonenumber")
email = request.form("email")
strIDNum="000208126"
set objConn = server.createobject("ADODB.Connection")
objConn.Open strProvider
set cm = Server.CreateObject("ADODB.Command")
cm.ActiveConnection = objConn
cm.CommandText = "UPDATE contactinfo SET clientName=companyname, contactNumber=phonenumber, altEmail=email WHERE empID = " & strIDNum
cm.Execute
END IF
I don't receieve any errors yet it doesn't update the record in the database. If someone could help that would be great.
Thanks,
Jeremy |
Follow Up - Re: Updating DB from information gathered from a form - Tom 5/1/2001 4:51:55 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
