Author |
Topic  |
|
mikster
Starting Member
India
2 Posts |
Posted - 09 July 2001 : 07:18:13
|
Hi, doesnt Snitz forum having a sorting capability? So that I can show new postings on top, rather than at the bottom?? |
|
RDoGG™
Junior Member
 
USA
329 Posts |
Posted - 09 July 2001 : 07:24:44
|
quote:
Hi, doesnt Snitz forum having a sorting capability? So that I can show new postings on top, rather than at the bottom??
yeah. new postings show at top.
Edited by - RDoGG™ on 09 July 2001 18:04:58 |
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
|
mikster
Starting Member
India
2 Posts |
Posted - 10 July 2001 : 01:26:51
|
RDoGG: New topics show at the bottom. I'm talking about replies IN a topic. Like this one I'm writing right now, it shows at the bottom. Can I get it to the top?
Davio: Is that a tweaked file? Which one of the original files do I replace with that?
Thanks a load!
Edited by - mikster on 10 July 2001 01:28:54 |
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 10 July 2001 : 01:32:33
|
The topic.asp file of course. Which other file would it be in? 
I would suggest you do a comparison with your existing topic.asp to the text file and copy and paste the added code to your topic.asp file. The code has been commented in the file so you can easily find the code to include it in your file.
- David |
 |
|
Intrepidone
Average Member
  
Canada
515 Posts |
Posted - 13 July 2001 : 02:22:11
|
Davio,
I keep getting this error
Microsoft JET Database Engine error '80040e14' Syntax error (missing operator) in query expression 'ORDER BY R_DATE ASC'.
/alpha6/topic.asp, line 392
I tried it on my heavily modified Snitz 3.2alpha6, thought maybe that was why and so I d-loaded 3.1sr4 and tried it on that and still came up with....
Microsoft JET Database Engine error '80040e14' Syntax error (missing operator) in query expression 'ORDER BY R_DATE ASC'.
/snitz4/topic.asp, line 320
Any ideas??
Thanks Intrepidone |
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 13 July 2001 : 12:30:17
|
Oh sorry, there was something wrong with the modified SQL statement. It was total foolishness. 
I have fixed it. Just look at the sql statement in the file and fix it accordingly in your file.
- David |
 |
|
samyot
Junior Member
 
Canada
242 Posts |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 13 July 2001 : 15:09:30
|
That's 7host for ya... they will probably be back up later.
- David |
 |
|
RDoGG™
Junior Member
 
USA
329 Posts |
Posted - 13 July 2001 : 15:23:12
|
oh ok...i understand now. i thought you meant that topics with recent replies should be on top (of forum.asp)
RDoGG™ |
 |
|
Intrepidone
Average Member
  
Canada
515 Posts |
Posted - 13 July 2001 : 15:53:44
|
Davio,
Ok, that fixed the error I had....but,
When it is clicked on "Show Oldest Post First", everything is fine. Correction
When it is clicked on "Show Oldest Post First", it shows 2 original post first.
When you click on "Show Newest Posts First", is shows the original post first, then the newest, then the original post last.
And when you click on "Show Original Post First Then Newest Replies", it shows TWO (2) Original Posts first then the Newest Replies.
I'll check my stuff once again
I just did it with a new Snitz 3.1sr4 with the same results. I looked at it to see if I can figure it out and just went DUHHHHH !! How the heck do you guys understand this stuff 
Intrepidone
Edited by - Intrepidone on 13 July 2001 16:43:42 |
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 14 July 2001 : 12:04:47
|
ok, sounds like you didn't do some things right. if you post a link to a txt version of your topic.asp file, I'll take a look at it. I have it working ok on my forum.
- David |
 |
|
Intrepidone
Average Member
  
Canada
515 Posts |
Posted - 14 July 2001 : 14:05:21
|
I have a heavily Modified topic.asp and it may have to do with something then around line #328 of my topic.asp (Snitz 3.2alpha6)
if mypage = 1 then Call GetFirst() end if
Actually, as I am typing this I just deleted the above code and it works fine now.
I am not sure if deleting that code where it is will affect the forum or not some how. It is just below a code from this MOD which is almost identical.
Here is a copy of my topic.asp
I cannot see it affecting the forum by deleting it because the 2 are basically identical the only difference between the 2 is
(sortorder <> "1") and
Your the expert, i'll let you examine the file and see what you think 
Intrepidone Techcare2000 or Techcare2000 Test Site
Edited by - Intrepidone on 14 July 2001 14:06:50 |
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 14 July 2001 : 18:12:02
|
Yes, you need to delete this code.if mypage = 1 then Call GetFirst() end if The code from the post sort mod replaces that one.
- David |
 |
|
Intrepidone
Average Member
  
Canada
515 Posts |
Posted - 14 July 2001 : 22:32:43
|
Thanks Davio,
Ya know I have looked at topic.asp atleast 20 times and did not even see
if mypage = 1 then Call GetFirst() end if until I was reading your post and you said it sounds like I didn't do something right. Soon as I opened it up it was right in front of my eyes.
Thanks again
Intrepidone |
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 14 July 2001 : 23:14:22
|
You're Welcome. Glad to have helped. 
After looking at forum files over and over again for over a year, you kinda get used to the code and know exactly what to look for. So I don't blame you if didn't catch that bit of code. 
- David |
 |
|
|
Topic  |
|