looking for a forum plugin for ASP/MySQL website

crmpicco · May 22nd, 2006, 07:29 AM

Hi all,

I am looking for information as to how I can bring in a forum that has already been built, such as phpBB (i have been told), that will work with my ASP pages that are connected to a MySQL database.

Going by the name phpBB I would presume that, that particular forum is for php only? Does one exist that would help me? and is it an easy thing to do???

Any help appreciated.

Picco

www.crmpicco.co.uk
www.ie7.com

crmpicco · May 22nd, 2006, 08:09 AM

hi there, ok so that might have seen like a stoopid question. but i have downloaded and installed Snitz forum now. However, i seem to get type mismatch errors on pages. :

Code:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch
/amatuer/forum/forum.asp, line 587

this is line 587 on forum.asp

Code:

if inttotaltopics = 0 then

When i wrap a CInt around it, then its fine. Why would this occur?

I am running WinXP Pro with IIS. MySQL DB.

www.crmpicco.co.uk
www.ie7.com

woodyz · May 22nd, 2006, 10:12 AM

It would be useful for you to know what value is in inttotaltopics when the error occurs... you could response.write out the value.

I took a quick look at the snitz code and it looks to me like the inttotaltopics is immediately initialized to zero after it is declared, and there are several places where it is assigned a value, but none of them look like a problem.

There should be no need to cast it to an int using cint... but still, you found that fixes the problem.

In your case a type mismatch would occur in your "if" statement if inttotaltopics was something other than a number and if it cannot be coerced into being a number, such as a string that does not contain a number.

So... the interesting thing is, why would casting it to an int be fixing your problem, since that conversion would typically occur automatically in vbscript.

What version of snitz are you using?

The version you have and the version I have might be different. It might be helpful to take a look at the forums and faq's at the snitz site.

Woody Z http://www.learntoprogramnow.com

crmpicco · May 22nd, 2006, 10:36 AM

thanks for your reply Woody, i am using SnitzTM Forums 2000 Version 3.4.05. It seems to be the latest, going by the details on the Snitz website.

I wondered if it had anything to with the environment i am using.

But, the CInt idea seemed to solve the problem OK. Being a type mismatch would say that it is a mismatch after all, so comparing a variable thats not a integer to an integer is incorrect.

It was just incase it was a error in the coding that wasnt noticed before.

Picco

www.crmpicco.co.uk
www.ie7.com

woodyz · May 22nd, 2006, 01:18 PM

That is the same version I am looking at... odd thing is, the line number in your error correlates to a different line of code in my forum.asp file. Of course, that isn't important.

It is still odd that the CInt cast solves the problem, since vscript will automatically coerce strings to numbers when needed and if it is possible and will only raise the type mismatch error if that conversion isn't possible. At least that is the way I understand it.

I have the forum running on both win 2000 and win 2003, but not on xp. So that might make a difference. Still, it isn't clear to me how.

I am sure you have noticed that this site is using snitz, and it seems to be working.

Have fun,
Woody

Woody Z http://www.learntoprogramnow.com