Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 22nd, 2006, 07:29 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default looking for a forum plugin for ASP/MySQL website

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
__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk
 
Old May 22nd, 2006, 08:09 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default

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
 
Old May 22nd, 2006, 10:12 AM
Friend of Wrox
 
Join Date: May 2006
Posts: 643
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old May 22nd, 2006, 10:36 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default

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
 
Old May 22nd, 2006, 01:18 PM
Friend of Wrox
 
Join Date: May 2006
Posts: 643
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
A small forum website jiger Beginning PHP 1 September 13th, 2008 01:43 AM
need help to creating forum website in asp.net yumuura_kirika ASP.NET 1.x and 2.0 Application Design 1 February 18th, 2007 12:22 AM
PHP MySQL Website Programming pugwash All Other Wrox Books 1 December 13th, 2003 10:53 AM
PHP MySQL Website Programming - Where is it? matius All Other Wrox Books 1 August 14th, 2003 11:13 AM
PHP MySQL Website Programming P-D-S robmorrish All Other Wrox Books 1 August 5th, 2003 01:29 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.