jonnyboyo
Posts: 15
|
| Posted: 02/15/2006, 2:45 AM |
|
I'm trying to track logins and I keep getting the following error
Error Type:
Microsoft VBScript runtime (0x800A01F4)
Variable is undefined: 'clsDBWobenAdmin'
/wobenwebadmin/LOGIN_events.asp, line 31
The code I'm using is
Dim SQL
Dim Connection
Dim ErrorMessage
Set Connection = clsDBWobenAdmin
Connection.Open
SQL = "INSERT INTO login_log(UserID, login_date, login) VALUES (" & DBWobenAdmin.ToSQL(CCGetUserID(), ccsInteger) & "," & DBWobenAdmin.ToSQL(Now(), ccsDate) & "," & DBWobenAdmin.ToSQL(CCGetParam("Login",""), ccsText) &")"
Connection.Execute(SQL)
ErrorMessage = CCProcessError(Connection)
Connection.Close
Set Connection = Nothing
On Error Goto 0
I have followed the code as setout by Peterr in his post http://forums.codecharge.com/posts.php?post_id=42883&s_keyword=track+logins
The strange thing is I have this working on another website login with the following code :
Dim SQL
SQL = "INSERT INTO login_log(UserID, login_date, login) VALUES (" & DBa4gzine.ToSQL(CCGetUserID(), ccsInteger) & "," & DBa4gzine.ToSQL(Now(), ccsDate) & "," & DBa4gzine.ToSQL(CCGetParam("Login",""), ccsText) &")"
DBa4gzine.Execute (SQL)
This is in CSS, the new one is in CSS3
Thanks
|
 |
 |
Walter Kempees
|
| Posted: 02/15/2006, 3:24 AM |
|
Does this help?
Set Connection = New clsDWobenAdmin
(taken from Peterr's post too)
"jonnyboyo" <jonnyboyo@forum.codecharge> schreef in bericht
news:243f30664d3853@news.codecharge.com...
> I'm trying to track logins and I keep getting the following error
>
> Error Type:
> Microsoft VBScript runtime (0x800A01F4)
> Variable is undefined: 'clsDBWobenAdmin'
> /wobenwebadmin/LOGIN_events.asp, line 31
>
>
> The code I'm using is
>
>
> Dim SQL
> Dim Connection
> Dim ErrorMessage
>
> Set Connection = clsDBWobenAdmin
> Connection.Open
>
> SQL = "INSERT INTO login_log(UserID, login_date, login) VALUES (" &
> DBWobenAdmin.ToSQL(CCGetUserID(), ccsInteger) & "," &
> DBWobenAdmin.ToSQL(Now(),
> ccsDate) & "," & DBWobenAdmin.ToSQL(CCGetParam("Login",""), ccsText) &")"
>
> Connection.Execute(SQL)
> ErrorMessage = CCProcessError(Connection)
> Connection.Close
> Set Connection = Nothing
> On Error Goto 0
>
> I have followed the code as setout by Peterr in his post
> http://forums.codecharge.com/posts.php?post_id=42883&s_keyword=track+logins
>
> The strange thing is I have this working on another website login with the
> following code :
>
> Dim SQL
> SQL = "INSERT INTO login_log(UserID, login_date, login) VALUES (" &
> DBa4gzine.ToSQL(CCGetUserID(), ccsInteger) & "," & DBa4gzine.ToSQL(Now(),
> ccsDate) & "," & DBa4gzine.ToSQL(CCGetParam("Login",""), ccsText) &")"
>
> DBa4gzine.Execute (SQL)
>
> This is in CSS, the new one is in CSS3
>
> Thanks
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
jonnyboyo
Posts: 15
|
| Posted: 02/15/2006, 3:31 AM |
|
Sorry, Yes I've tried that as per Peterr's code but get the same error
|
|
|
|
jonnyboyo
Posts: 15
|
| Posted: 02/15/2006, 3:36 AM |
|
I also get the following errors when trying to test email forms from my development computer.
Microsoft VBScript runtime (0x800A01AD)
ActiveX component can't create object: 'JMail.SMTPMail'
Used to work ( pre CCS3 ) and works perfectly once it's uploaded to the server. Could this be a computer configuration?
Windoes XP professional Service Pack 2 etc...
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 02/15/2006, 3:41 AM |
|
I notice you are using the ASP version.
Correct?
Then I would suggest re-posting in the ASP forum as you are now posting in the PhP flavour.
Might be more help available there.
Not that I don't want to but it's more a question of not knowing how to.
Best,
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
|
