Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Databases
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old May 22nd, 2006, 07:29 AM
Friend of Wrox
Points: 8,019, Level: 38
Points: 8,019, Level: 38 Points: 8,019, Level: 38 Points: 8,019, Level: 38
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
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
Reply With Quote
  #2 (permalink)  
Old May 22nd, 2006, 08:09 AM
Friend of Wrox
Points: 8,019, Level: 38
Points: 8,019, Level: 38 Points: 8,019, Level: 38 Points: 8,019, Level: 38
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
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
Reply With Quote
  #3 (permalink)  
Old May 22nd, 2006, 10:12 AM
Friend of Wrox
 
Join Date: May 2006
Location: San Diego, CA, USA.
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
Reply With Quote
  #4 (permalink)  
Old May 22nd, 2006, 10:36 AM
Friend of Wrox
Points: 8,019, Level: 38
Points: 8,019, Level: 38 Points: 8,019, Level: 38 Points: 8,019, Level: 38
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
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
Reply With Quote
  #5 (permalink)  
Old May 22nd, 2006, 01:18 PM
Friend of Wrox
 
Join Date: May 2006
Location: San Diego, CA, USA.
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 05:12 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.