| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Updating too many records. HELP |
|
From: |
Kevin ONeil |
|
Date: |
10/26/1999 10:12:16 PM |
|
IP: |
129.93.53.69 |
Im currently experiencing a problem with my ASP code. A section of it is copied below. When this code updates the database (Access
2000), it updates more than one line (more than one record) even though the WHERE statement should limit the recordset to
just one record because each line has a unique value of "subjnum". What could be causing this? If you need to know more,
or need the full code, email me and Ill send it to you.
Thanks
Code:
set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT date2,time2,att,dq,condorig FROM KevinData WHERE subjnum = "& request.form("subjnum") & ""
rs.Open strSQL, objConn, adOpenForwardOnly, adLockOptimistic, adCmdText
rs("date2") = request.form("date")
rs("time2") = request.form("time")
rs("att") = request.form("att")
rs("dq") = request.form("dq")
rs("condorig") = strcond
rs.Update
rs.Close
|
|
|
|
|
|
|
