Ben Steggink
|
| Posted: 07/30/2002, 1:06 PM |
|
I'm using ASP and I want to update the user record with today's date whenever he performs a login action.
I added the following code within the login program.
The record will never be updated. I even tried to select a fixed record number and another field to be updated.
What do I wrong? Is it the wrong place to add the custom code?
Can someone help me?
Function Page_BeforeUnload() 'Page_BeforeUnload @1-A9F5B785
'Custom Code @14-73254650
' -------------------------
Dim DBICTee
Set DBICTee = New clsDBICTee
CCExecSQL "UPDATE leden SET last_login_date=now() WHERE leden.LidID = CCGetUserID", DBICTee, true
' -------------------------
'End Custom Code
End Function 'Close Page_BeforeUnload @1-54C34B28
|
|
|
 |
Alex Alexapolsky
|
| Posted: 07/31/2002, 4:37 AM |
|
CCGetUserID is inside a string and is not treated as a function
"UPDATE leden SET last_login_date=now() WHERE leden.LidID = CCGetUserID"
should be
"UPDATE leden SET last_login_date=now() WHERE leden.LidID = " & CCGetUserID"
|
|
|
|
|
