| Author |
 Topic  |
|
Davio
Development Team Member
Jamaica
12217 Posts |
 Posted - 06 August 2002 : 16:22:08
|
What? That's not possible.
Ok, I went to your forum and I do see the text. It's in the black space above the topic. It says "No replies".
Ok, remove that code I asked you to add. We are going back up to line 275. The fllowing code is around line 275.If not (rsReplies.EOF or rsReplies.BOF) then '## No replies found in DB
rsReplies.movefirst
Response.Write "EOF:" & rsReplies.EOF & "|BOF:" & rsReplies.BOF
rsReplies.pagesize = strPageSize
rsReplies.absolutepage = mypage '**
maxpages = cint(rsReplies.pagecount)
end if Add the code in red. I think it is the movefirst that might be causing it. Not sure why though.
«-----------------------------------»
Join the Snitz Forums WebRing ! |
 |
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 06 August 2002 : 16:28:34
|
Ok. Some text again.
EOF:False|BOF:False
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 06 August 2002 : 16:34:38
|
Ok, that suspicion didn't work. Move the code in red down 1 line, like so:If not (rsReplies.EOF or rsReplies.BOF) then '## No replies found in DB
rsReplies.movefirst
rsReplies.pagesize = strPageSize
Response.Write "EOF:" & rsReplies.EOF & "|BOF:" & rsReplies.BOF
rsReplies.absolutepage = mypage '**
maxpages = cint(rsReplies.pagecount)
end if Keep bringing it down by 1 line (refresh your topic.asp page on your forum and check again) until you reach the end if. If you see true for one of them, let me know.
That didn't confuse you right? I am trying to see where the rsReplies reaches the EOF (End Of File) or BOF(Beginning Of File).
«-----------------------------------»
Join the Snitz Forums WebRing ! |
|
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 06 August 2002 : 16:58:27
|
Ok. when the line is one step down (under pagesize)the response is
EOF:False|BOF:False
2 steps down(under absolutepage)
EOF:True|BOF:True
3 steps down (under maxpages)
EOF:True|BOF:True
Did that confuse you?..
/Roger
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 06 August 2002 : 17:07:11
|
Nice work Traz.
Ok, so it is the absolutepage property that sets the record set to EOF and BOF.
Give me a few minutes let me test something.
«-----------------------------------»
Join the Snitz Forums WebRing ! |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 06 August 2002 : 17:14:43
|
Ok, I am going to suggest to you to comment out that line, but before you do that I want to find out why that line is giving that problem.
What connection string are you using? The Access 2000 or Access 97?
And last debug test I want you to try. Same area around line 275, add the code in red:If not (rsReplies.EOF or rsReplies.BOF) then '## No replies found in DB
rsReplies.movefirst
rsReplies.pagesize = strPageSize
Response.Write "mypage:" & mypage
rsReplies.absolutepage = mypage '**
maxpages = cint(rsReplies.pagecount)
end if Of course you can remove any previous code I asked you to add.
«-----------------------------------»
Join the Snitz Forums WebRing ! |
|
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 06 August 2002 : 17:22:04
|
I use strConnString = "DSN=Myuserid-snitz_forums_2000;Password=xxx" '## DSN
I am sitting on a Apache server with ChiliASP
with a DSN connection to a widows 2000 server
|
|
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 06 August 2002 : 17:26:20
|
the respond to my page is: mypage:1
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 06 August 2002 : 17:30:50
|
Ok. Remove the code I asked you to add and then comment out the absolutepage code.'rsReplies.absolutepage = mypage '** See if your replies show up after that.
«-----------------------------------»
Join the Snitz Forums WebRing ! |
|
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 06 August 2002 : 17:35:47
|
Sorry but they don´t show up after that.
/Roger
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 06 August 2002 : 17:40:49
|
What?? lol You sure you commented out that line? Noticed I placed a ' in front of the line.
If it still doesn't work, I am going to ask you if you can send me your ftp details so I can do some more testing on this. Who knows how long this might take to find this problem. I believe this is also because it is rare to find a users using the forum on a Unix host with chiliasp and an Access database.
«-----------------------------------»
Join the Snitz Forums WebRing ! |
|
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 06 August 2002 : 17:57:49
|
Yes I placed a ' in front of the line
I am a Access database builder and is working
a lot with VBA (have to learn ASP).
How will you have the ftp details? in a mail,
you need ID and password to go on my FTP right?
It´s funny but ChiliSoft are using the snitz forum
http://www.chilisoft.com/forum/
/Roger
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 06 August 2002 : 18:01:39
|
Yes, you can send it to my email. Just use the email option here to email me.
I know they use Snitz as thier forum. They use it to show that their product is capable of supporting asp files.
«-----------------------------------»
Join the Snitz Forums WebRing ! |
|
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 06 August 2002 : 18:35:46
|
Did you get the mail?
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 07 August 2002 : 01:55:44
|
Yes I did get your email. But I am still unable to get it to work.
Can i ask why you are using an access database? Doesn't your host provide you with a mysql database on the apache server?
I have never seen anyone do it this way. And I suspect that it won't work. You are going to have to move over to a windows host or get a mysql database.
«-----------------------------------»
Join the Snitz Forums WebRing ! |
|
|
|
Topic |
|
Topic Locked
