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

  New Posts New Posts RSS Feed - About [hide][/hide] block
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

About [hide][/hide] block
 Post Reply Post Reply Page  <12
Author
  Topic Search Topic Search  Topic Options Topic Options
asplearning View Drop Down
Newbie
Newbie


Joined: 26 July 2006
Status: Offline
Points: 21 		Post Options Post Options   Thanks (0) Thanks(0)   Quote asplearning Quote  Post ReplyReply Direct Link To This Post Posted: 26 July 2006 at 2:58pm
Originally posted by gölge gölge wrote:

try this
 
strSQL = "SELECT " & strDbTable & "Thread.* "
 
i think there is a unneded space in code...



It did not work golge

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near '*'.

/forum/functions/functions_format_post.asp, line 132


Code:

strSQL = "SELECT" & strDbTable & "Thread.*"
strSQL = strSQL & "FROM " & strDbTable & "Thread "
strSQL = strSQL & "WHERE Author_ID = " & lngLoggedInUserID & " and Topic_ID = "&lngTopicID


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: 26 July 2006 at 9:41pm
You didnt copy the code correctly. Notice your missing a space.....
Back to Top
asplearning View Drop Down
Newbie
Newbie


Joined: 26 July 2006
Status: Offline
Points: 21 		Post Options Post Options   Thanks (0) Thanks(0)   Quote asplearning Quote  Post ReplyReply Direct Link To This Post Posted: 26 July 2006 at 10:37pm
Originally posted by MadDog MadDog wrote:

You didnt copy the code correctly. Notice your missing a space.....


Thanks MD,  jsaren, and golge .  I got it works now.


Edited by asplearning - 27 July 2006 at 1:50am
Back to Top
 Post Reply Post Reply Page  <12

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.