HI All,

I have a table named 'securitytable' with 3 fields(Name, Userid, password).

I have an ASP form where user can change their password. Here is the issue, when they hit submit, everything in the table of that particular record got update even though my SQL statement looks like this(specified ONLY to update the password):

SQLstmt = "UPDATE SecurityTable SET "
SQLstmt = SQLstmt & "password='" & password & "'"
SQLstmt = SQLstmt & " WHERE userid='" & userid & "'"
objConn.Execute(SQLStmt)

In other words, when I go back to view this record, the 'password' field got updated, but the 'Name' and 'userid' fields are blanks, due to the fact that the system thought we meant to update those two fields with blanks.

Is there anyway to prevent from updating everything? Please advise.

Thank you.

Leon

Thats wierd, it can't be. Hope to see your asp code, if not too long.

_________________________
- Vijay G
Strive for Perfection

Hi Vijay,
Thank you. Below are the codes; there are not much to it b/c my page is not really doing much. All it does is it grabs the new password from the user's input and do an update to the database. Here it is:

[red]<%
'After the user click submit, we have step2
ElseIf Request.form("FormAction") = "Step2" Then
Set objConn = Server.CreateObject("ADODB.Connection")
' Delevopment
objconn.Open "Provider=SQLOLEDB.1; Data Source=(local); Initial Catalog=internship_form; User Id=adminu; Password=adminp"


password=trim(request.form("pswd1"))
userid=trim(request.form("userid"))

SQLstmt = "UPDATE SecurityTable SET "
SQLstmt = SQLstmt & "password='" & password & "'"

SQLstmt = SQLstmt & " WHERE userid='" & userid & "'"
objConn.Execute(SQLStmt)

objConn.Close
set objconn=nothing
End If

%>

Hi Vijay,
I am not sure if this helps, but I just notice something. You know how i said all the columns are replaced by blanks? Actually, the first 5 columns(of the particular record) did not get replaced, but the columns following the first 5 are replaced with blanks. Does this make any sense? This is too weird. Below is my database structure(the listed columns are in their exact order in the database. And columns with "*" did not get replaced with blanks when I do an update;notice they r the first 5 colunms).

Createdate*
UserID*
Password*
Firstname*
Lastname*
agency
securitylevel
title
phone
email

Vijay,

I finally figured out what happened. It was the "Form Action" that I made a mistake on. Thank you VERY much for taking your time to help me. And sorry to have wasted your time.

Leon

Sorry, I haven't got enough time to check my mails for last couple of days. Glad that you solved it.

Cheers!

_________________________
- Vijay G
Strive for Perfection