Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - MOD: Latest Forum Posts for your website
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MOD: Latest Forum Posts for your website

 Post Reply Post Reply Page  <1 2345>
Author
bims View Drop Down
Groupie
Groupie
Avatar

Joined: 03 May 2004
Location: United Kingdom
Status: Offline
Points: 115
Post Options Post Options   Thanks (0) Thanks(0)   Quote bims Quote  Post ReplyReply Direct Link To This Post Posted: 20 October 2006 at 1:17am
Can i display last posts in a specific forum? For eg if i have a soccer forum and a tennis forum, can i just display the last posts in the soccer forum?

Do i make sense?
Back to Top
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008
Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post Posted: 20 October 2006 at 1:43am
Originally posted by MadDog MadDog wrote:

This file is intended to help people put a "Latest Forum Posts" box on their website, or a simple file to start from somewhere.

This mod will not add Latest Forum Posts to the forum pages, unless you add the code to do it.

Download/View Mod Here

Back to Top
balearicjobs View Drop Down
Groupie
Groupie
Avatar

Joined: 13 July 2002
Location: United Kingdom
Status: Offline
Points: 86
Post Options Post Options   Thanks (0) Thanks(0)   Quote balearicjobs Quote  Post ReplyReply Direct Link To This Post Posted: 31 October 2006 at 8:35pm
If anybody has sucessfully used this script with a MySQL database, I would appreciate you posting the version of the script you are using.

I've been told that I need to "Just replace the strCon variable with the MySQL connection string then edit strDatabaseType to MySQL.", unfortunetly as I am not confident with ASP I am unsure how to do this.

Thank you for any help.
Thanks for your help!!!
Kind Regards
Rob,
Balearic Jobs
Helping young people find seasonal work in the Balearic Islands, including vacancie
Back to Top
balearicjobs View Drop Down
Groupie
Groupie
Avatar

Joined: 13 July 2002
Location: United Kingdom
Status: Offline
Points: 86
Post Options Post Options   Thanks (0) Thanks(0)   Quote balearicjobs Quote  Post ReplyReply Direct Link To This Post Posted: 09 November 2006 at 8:23am
Originally posted by balearicjobs balearicjobs wrote:

If anybody has sucessfully used this script with a MySQL database, I would appreciate you posting the version of the script you are using.

I've been told that I need to "Just replace the strCon variable with the MySQL connection string then edit strDatabaseType to MySQL.", unfortunetly as I am not confident with ASP I am unsure how to do this.

Thank you for any help.
 
I'm still non the wiser on this one. If any body can help I would appreciate it! Smile


Edited by balearicjobs - 09 November 2006 at 8:23am
Thanks for your help!!!
Kind Regards
Rob,
Balearic Jobs
Helping young people find seasonal work in the Balearic Islands, including vacancie
Back to Top
cfilut View Drop Down
Newbie
Newbie


Joined: 24 February 2005
Location: United States
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote cfilut Quote  Post ReplyReply Direct Link To This Post Posted: 05 December 2006 at 3:38am
I get this message when creating and checking this page (original code on first page of this post)

Latest 10 Forum Posts

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'UBound'

/forum/last_ten_posts.asp, line 56

any suggestions?



Edited by cfilut - 05 December 2006 at 3:41am
Back to Top
coolguy View Drop Down
Newbie
Newbie
Avatar

Joined: 14 November 2006
Location: United States
Status: Offline
Points: 37
Post Options Post Options   Thanks (0) Thanks(0)   Quote coolguy Quote  Post ReplyReply Direct Link To This Post Posted: 05 December 2006 at 5:10am
Originally posted by bims bims wrote:

Can i display last posts in a specific forum? For eg if i have a soccer forum and a tennis forum, can i just display the last posts in the soccer forum?

Do i make sense?
 
 
Yes, replace this:
 
WHERE tblForum.Forum_ID = tblTopic.Forum_ID
 
with this:
 
WHERE tblForum.Forum_ID = 31 
 
 
31 would be your forum number
 
 
Back to Top
tonygu View Drop Down
Newbie
Newbie


Joined: 13 December 2006
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote tonygu Quote  Post ReplyReply Direct Link To This Post Posted: 13 December 2006 at 2:37pm
 I get thsi message when creating and checking,

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1b64 Thread 0x1bbc DBC 0x2db8c094 Jet'.

 
The code on the second page of this post
 
Amy suggestions?


Edited by tonygu - 13 December 2006 at 2:43pm
Back to Top
Pfeff View Drop Down
Newbie
Newbie


Joined: 17 October 2006
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote Pfeff Quote  Post ReplyReply Direct Link To This Post Posted: 13 January 2007 at 6:28pm
Anyone ever get a MySQL version of this running?

This is exactly what I am looking for and I can finish off building my site with this. Any help would be greatly appreciated.
Back to Top
 Post Reply Post Reply Page  <1 2345>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.