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: General / Current Version (Old)
 Sorting
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

mikster
Starting Member

India
2 Posts

Posted - 09 July 2001 :  07:18:13  Show Profile  Visit mikster's Homepage
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  Show Profile  Visit RDoGG™'s Homepage  Send RDoGG™ an AOL message  Send RDoGG™ a Yahoo! Message
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
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 09 July 2001 :  17:51:18  Show Profile
How about this?
http://user.7host.com/davio/mods/post_sorting_mod.txt

- David
Go to Top of Page

mikster
Starting Member

India
2 Posts

Posted - 10 July 2001 :  01:26:51  Show Profile  Visit mikster's Homepage
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
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 10 July 2001 :  01:32:33  Show Profile
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
Go to Top of Page

Intrepidone
Average Member

Canada
515 Posts

Posted - 13 July 2001 :  02:22:11  Show Profile
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
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 13 July 2001 :  12:30:17  Show Profile
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
Go to Top of Page

samyot
Junior Member

Canada
242 Posts

Posted - 13 July 2001 :  13:27:07  Show Profile  Visit samyot's Homepage  Send samyot a Yahoo! Message
quote:

How about this?
http://user.7host.com/davio/mods/post_sorting_mod.txt

- David



Your site appears to be down, can you please email me this file or make it available ?

Thank you in advance,

Sylvain Amyot
sylvainamyot@home.com
FORUM:http://syltek.dingojunction.com/forum
HOME:http://members.home.net/sylvainamyot/

Edited by - samyot on 13 July 2001 13:47:34
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 13 July 2001 :  15:09:30  Show Profile
That's 7host for ya...
they will probably be back up later.

- David
Go to Top of Page

RDoGG™
Junior Member

USA
329 Posts

Posted - 13 July 2001 :  15:23:12  Show Profile  Visit RDoGG™'s Homepage  Send RDoGG™ an AOL message  Send RDoGG™ a Yahoo! Message
oh ok...i understand now. i thought you meant that topics with recent replies should be on top (of forum.asp)

RDoGG™
Go to Top of Page

Intrepidone
Average Member

Canada
515 Posts

Posted - 13 July 2001 :  15:53:44  Show Profile
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
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 14 July 2001 :  12:04:47  Show Profile
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
Go to Top of Page

Intrepidone
Average Member

Canada
515 Posts

Posted - 14 July 2001 :  14:05:21  Show Profile
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
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 14 July 2001 :  18:12:02  Show Profile
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
Go to Top of Page

Intrepidone
Average Member

Canada
515 Posts

Posted - 14 July 2001 :  22:32:43  Show Profile
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
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 14 July 2001 :  23:14:22  Show Profile
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
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.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07