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

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Problem with forum [solved]		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

PuppyF500
New Member

Netherlands
68 Posts
Posted - 27 March 2005 :  08:00:18  Show Profile
because i was bored i started to code a forum just for fun and the learning but now i'm kinda stuck in on one page -_-
http://www.theprofoundone.com/forum.asp.txt this is the page with the problem... i keep getting this error:
Error Type:
ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/TPOForumz/forum.asp

i know that's probably because there aren't any topics for that specific forum yet, but thats why i included a if rs.EOF to print no topics found.. but it won't work -_- it works in almost the same way on the default.asp page and one other page... but something else is stopping the process... anyone ideas?
Edited by - PuppyF500 on 27 March 2005 17:12:54

rodham
New Member

65 Posts
Posted - 27 March 2005 :  09:15:15  Show Profile  Visit rodham's Homepage
I quickly scanned your forum.asp.txt file and didn't see where you defined adoCon

rsTopic.Open SQLTopic, adoCon
Edited by - rodham on 27 March 2005 09:15:29
Go to Top of Page

PuppyF500
New Member

Netherlands
68 Posts
Posted - 27 March 2005 :  10:51:31  Show Profile
adoCon is in config.asp which is included:

Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\TPOForumz\TPOForumz.mdb"

but it isn't adoCon where the error lies because all the other pages that use it are working correctly and if a forum has topics it also works. It's all about displaying the text "No Topics Found" if a forum doesn't have any topics (yet).
Go to Top of Page

rodham
New Member

65 Posts
Posted - 27 March 2005 :  11:02:24  Show Profile  Visit rodham's Homepage
Sorry, I should have read your post a little,

On line 18 and others before the test for EOF you are referencing the table: rsTopic("...")
Edited by - rodham on 27 March 2005 11:02:39
Go to Top of Page

PuppyF500
New Member

Netherlands
68 Posts
Posted - 27 March 2005 :  16:40:01  Show Profile
so i should place the if rsTopic.Bof then response.write "no topics found" before the rest of the page in an if, else construction right?

i fixed it by letting the other information being collected by an other rs thanks for pointing out the error to me i can't understand why i missed it
Edited by - PuppyF500 on 27 March 2005 17:12:42
Go to Top of Page

rodham
New Member

65 Posts
Posted - 27 March 2005 :  18:12:58  Show Profile  Visit rodham's Homepage
I'm glad you got it
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.94 seconds. Powered By: Snitz Forums 2000 Version 3.4.07