Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Poll problem		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

geminione
Starting Member

39 Posts
Posted - 28 May 2001 :  03:04:11  Show Profile  Visit geminione's Homepage
I got the poll installed pretty alright... but I now I have a funny lil problem...

error '80020009'
Exception occurred.

/forum/default.asp, line 100


this happens when I try to access /forum/default.asp as opposed to just /forum/

here is the problematic line...
strSql = strSql & " WHERE " & strTablePrefix & "CATEGORY.CAT_ID = " & rsPoll("CAT_ID")

thanks

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 28 May 2001 :  15:00:45  Show Profile
Hmmm, so when you go to /forum/ it doesn't give the error? But when you go to /forum/default.asp it gives the error?
quote:
here is the problematic line...
strSql = strSql & " WHERE " & strTablePrefix & "CATEGORY.CAT_ID = " & rsPoll("CAT_ID")
How do you know that's the problemtic line?
Go to Top of Page

geminione
Starting Member

39 Posts
Posted - 28 May 2001 :  18:00:24  Show Profile  Visit geminione's Homepage
Yep... for example... anything that is tagged to go the the default.asp AS default.asp.. like the banner, or "Return to Forum" or a like logging in and out i get the error. But just going to forum/ works fine... and IF i get the error... and delete the 'default.asp' from the url... i get to the main page no prob.

Well... i am assuming that line 100is atleast PART of the problem... because thats the error i get... and that line mentions the poll...

i dunno man...
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 28 May 2001 :  23:43:38  Show Profile
hmm, don't see why that should cause an error. Do this for me. Put this code Response.Write strSql right before the my_Conn.Execute (strSql) code. Then try and reproduce the error again. Hopefully you would see the SQL statement being printed out along with the error. Copy and paste it here.

Also, what database are you using?
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 29 May 2001 :  13:03:18  Show Profile
Nevermind my last post. Here is the fix for it: link.asp?TOPIC_ID=10357
Go to Top of Page

geminione
Starting Member

39 Posts
Posted - 29 May 2001 :  13:19:25  Show Profile  Visit geminione's Homepage
Well alrighty then.... thanks alot.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.31 seconds. Powered By: Snitz Forums 2000 Version 3.4.07