Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - MSSQL Last 10 Posts
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MSSQL Last 10 Posts
 Post Reply Post Reply Page  <123>
Author
  Topic Search Topic Search  Topic Options Topic Options
EvoIX_mr2006 View Drop Down
Newbie
Newbie
Avatar

Joined: 19 January 2007
Location: United States
Status: Offline
Points: 9 		Post Options Post Options   Thanks (0) Thanks(0)   Quote EvoIX_mr2006 Quote  Post ReplyReply Direct Link To This Post Posted: 22 January 2007 at 9:36pm
Ok, everything works except link creation.  I have a sub domain for my forums, forums.cicenet.net, so the link tries to go to www.cicenet.net/forums.cicenet.net/posthere.  Any suggestions?
Back to Top
MrMellie View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MrMellie Quote  Post ReplyReply Direct Link To This Post Posted: 22 January 2007 at 10:30pm
You just need to fully qualify the link:

Response.Write "<a class=""smLink"" href=""http://forums.cicenet.net/forum_posts.asp?TID=" & CLng(saryTop10(fld_Topic_ID,i)) & "&get=last#" & saryTop10(fld_Thread_ID,i) & """ title="""">" & saryTop10(fld_Subject,i) & "</a></td>"
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: 27 January 2007 at 4:23pm

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-4.1.21-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10 T.Subject, T.Topic_ID, T.No_of_views, Th.Message_date, Au.Username, Th.Thread' at line 1

/forums/forum/last_posts_ext.asp, line 38

Any ideas?
Back to Top
MrMellie View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MrMellie Quote  Post ReplyReply Direct Link To This Post Posted: 27 January 2007 at 4:43pm
Yes, I found the bug yesterday after installing MySQL. I've updated the original post to reflect the changes.

The two lines that read

if strDatabaseType <> "MYSQL"

should read

if strDatabaseType <> "mySQL"

This should then build the correct query string for MySQL.

Edited by MrMellie - 27 January 2007 at 4:44pm
Back to Top
MrMellie View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MrMellie Quote  Post ReplyReply Direct Link To This Post Posted: 27 January 2007 at 4:55pm
Originally posted by EvoIX_mr2006 EvoIX_mr2006 wrote:

Ok, everything works except link creation.  I have a sub domain for my forums, forums.cicenet.net, so the link tries to go to www.cicenet.net/forums.cicenet.net/posthere.  Any suggestions?
In your forum configuration page, what have you got for the item "Web address path to forum"? If that's correctly configured, I can't see why the original code doesn't work...
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: 27 January 2007 at 5:19pm
It works! You are the goods MrMellie. I can not thank you enough!
Back to Top
MrMellie View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MrMellie Quote  Post ReplyReply Direct Link To This Post Posted: 27 January 2007 at 5:56pm
Pleasure to be of service.
Back to Top
Kezzal View Drop Down
Newbie
Newbie


Joined: 06 January 2007
Status: Offline
Points: 1 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Kezzal Quote  Post ReplyReply Direct Link To This Post Posted: 28 January 2007 at 11:55am
Great Mod - worked first time and easy to adjust further - thanks for putting it together for us!
Back to Top
 Post Reply Post Reply Page  <123>

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.