| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Updating too many records |
|
From: |
Kevin ONeil |
|
Date: |
10/26/1999 10:13:37 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. Please email me with comments/answers.
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
|
Follow Up - Re: Updating too many records - aaaa 10/29/1999 6:51:08 AM
|
|
|
|
|
|
