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 / Classic ASP versions(v3.4.XX)
 Jump to Last Post problems
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

imotep
Starting Member

23 Posts

Posted - 23 April 2003 :  14:29:42  Show Profile
Can someone tell me where the code that processes the jump to last post feature is? I think I may have messed it up installing some mods. The feature works correctly unless the topic is more that one page. If the topic contains more than one page, the link just takes you to the first page. The arrow link looks to be correct, at least when compared to this forum.

In poking around, I've noticed that the request("whichpage") seems to be stripped out of the querystring. I put a test <%=request("whichpage")%> at the bottom of my topic page it is being returned as empty.

Thanks,
Mike

Edited by - imotep on 23 April 2003 16:00:59

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 23 April 2003 :  17:16:39  Show Profile  Send ruirib a Yahoo! Message
Probably the problem does not lie with the code, but with the conn string or the server MDAC. What connection string are you using?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

imotep
Starting Member

23 Posts

Posted - 23 April 2003 :  18:51:48  Show Profile
You are the man ruirib! I was using the strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=, instead of the Jet connection. Everything works fine now, thank you very much.
Mike
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 23 April 2003 :  22:37:33  Show Profile  Send ruirib a Yahoo! Message
You're welcome .


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

thevork
Starting Member

13 Posts

Posted - 01 July 2003 :  03:24:11  Show Profile
I have thesame problem.

Running win2k3, sql server 2000 sp3a, and the latest Mdac components.

When clicking the nice button for jump to last post I am taken to the end of the first page, not to the post @ page 2 or 3.

It's a standard installation, only the summary MOD is installed.
Also, I changed nothing to the connection string but the necesary stuff like servername and Db.

thanx in advance for any help offered.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 01 July 2003 :  04:58:50  Show Profile  Send ruirib a Yahoo! Message
Make sure you use an OLEDB connection string.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

thevork
Starting Member

13 Posts

Posted - 03 July 2003 :  02:49:49  Show Profile
quote:
Originally posted by ruirib

Make sure you use an OLEDB connection string.



I use the default conn. string for sql server from the config.asp.

is that not okay?
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 03 July 2003 :  04:46:39  Show Profile  Send ruirib a Yahoo! Message
I don't know what you mean by default conn string. There is no default conn string. Use one like this:


strConnString = "Provider=SQLOLEDB;Data Source=serverID;database=DATABASE_NAME;uid=USER_ID;pwd=PASSWORD;"


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

thevork
Starting Member

13 Posts

Posted - 03 July 2003 :  05:28:16  Show Profile
quote:
Originally posted by ruirib

I don't know what you mean by default conn string. There is no default conn string. Use one like this:


strConnString = "Provider=SQLOLEDB;Data Source=serverID;database=DATABASE_NAME;uid=USER_ID;pwd=PASSWORD;"




There is a string that I uncommented when setting up Sql server.
It's this one: (i just removed the actual username and pass )

strConnString = "driver={SQL Server};server=SERVER1;uid=forumuser;pwd=actualpw;database=Forum;Trusted_Connection=yes;" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)

It says I can use this one in my config.
I should change that?

Edited by - thevork on 03 July 2003 05:30:27
Go to Top of Page

thevork
Starting Member

13 Posts

Posted - 03 July 2003 :  05:33:29  Show Profile
Ok I got it now. Thanks a lot
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 03 July 2003 :  05:40:07  Show Profile  Send ruirib a Yahoo! Message
You're welcome.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

tenable
Starting Member

25 Posts

Posted - 05 July 2003 :  14:36:10  Show Profile
Could someone tell me how to get rid of the jump to:select forum box altogether. I have chosen not to have it but that has no effect it is still there. Any one know of this problem. I have searched probably with eyes closed
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 05 July 2003 :  14:39:48  Show Profile
quote:
Originally posted by tenable

Could someone tell me how to get rid of the jump to:select forum box altogether.
I have chosen not to have it but that has no effect it is still there. Any one know of this problem.
I have searched probably with eyes closed

This is different than "Jump To Last Post".

Please do not double post. Continue here:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=44044

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

Locnar
New Member

89 Posts

Posted - 05 July 2003 :  15:11:28  Show Profile  Visit Locnar's Homepage
Slightly unrelated, but does anyone know of a mod that shows a portion of the last post when you hover over the Jump to last post icon? I was sure I saw one here somewhere, but I cannot find it for the life of me.

I do have the topic hover mod and love that one, but cannot get that to work on my active.asp page, but that is a post for another thread.

Thanks for any info!

Locnar
Just your basic forums ---> www.duncanet.com/forums
Star Wars Galaxies ---> www.duncanet.com/forum/sitenews.asp
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.6 seconds. Powered By: Snitz Forums 2000 Version 3.4.07