| Author |
 Topic  |
|
|
jollyrogerlove
Starting Member
3 Posts |
 Posted - 23 February 2009 : 22:50:27
|
Okay, I keep getting an error saying "Microsoft VBScript runtime error '800a000d' Type mismatch" for various pages on the forum I just installed. I trace back the errors to the line of code, and most of them point to lines referring to iPageTotal. How do I fix this? Because when someone clicks on a topic, they get this error "Microsoft VBScript runtime error '800a000d'
Type mismatch
/lilsparrow/forum/forum.asp, line 297", which isn't entirely a good thing. I haven't played with any of the code since I downloaded it from Snitz.
My site is http://lilsparrow.jollyrogerlove.info/lilsparrow/forum/default.asp
Help would be greatly appreciated!< |
|
|
Carefree
Advanced Member
Philippines
4222 Posts |
Posted - 24 February 2009 : 02:15:12
|
| Post a link to a copy of your "forum.asp" in text (.txt) format for us to look at.< |
 |
|
|
jollyrogerlove
Starting Member
3 Posts |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 26 February 2009 : 04:27:39
|
Try changing line 293 to add the code in green:iPageTotal = clng(rsCount(0).value) < |
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
jollyrogerlove
Starting Member
3 Posts |
Posted - 27 February 2009 : 10:28:21
|
| Thank you so much! It worked like a charm.< |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 27 February 2009 : 10:34:46
|
You're welcome.
You'll need to do that wherever you're getting that error which, incidentally, I've never seen in all my years here.
< |
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
bitstreammedia
Starting Member
USA
6 Posts |
Posted - 23 July 2009 : 12:25:49
|
Hi, just wanted to let you know I ran into the same problem and the solution you gave here also worked. I do remember having to do this with another site I wrote and it seemed to be with some variables that were pulled from the database. Still don't know the reason why, but it worked. That site and this forum are running on the same webserver using the same database. I'm using MySQL database version 5.0.XX running on a seperate machine than the webserver which is using Win 2003 server. Connection to the database is by TCP using the MySQL ODBC 3.5 connector setup to use a DSN connector. Maybe this setup has something to do with it? Not sure, but it's working!
Just my two cents of info. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
