Information générale
Catégorie:
Active Server Page
>hi all
>i have the following code. it works on page1.asp perfectly, only updating one record, however on page two it updates most records in the table. this is the exact same code char-4-char on the 2 pages, i am really stumped, any ideas?
>
>Dim step3_RS, step3_SQL
>Set step3_RS=Server.CreateObject("ADODB.Recordset")
>step3_SQL = "SELECT per_stage FROM web_permit WHERE per_num= '" & SESSION("USER_PERMIT") & "'"
>step3_RS.Open step3_SQL, objConn, , adLockOptimistic
>
>step3_RS ("per_stage") = "Claimed"
>step3_RS.Update
>
>Slán
>~M
Mark;
You know your needs and application design so I am just voicing my opinion from what I see and know. I can only see this code so I am basing my suggestion upon it. I try to avoid Session.
I would not use the Session() in the select statement. Would removing Session be a serious problem?
Tom
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement