Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - (0x80004005) Unspecified error - Help!
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

(0x80004005) Unspecified error - Help!

 Post Reply Post Reply
Author
Dekieon View Drop Down
Newbie
Newbie


Joined: 17 February 2005
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dekieon Quote  Post ReplyReply Direct Link To This Post Topic: (0x80004005) Unspecified error - Help!
    Posted: 17 February 2005 at 11:53pm
I am having the strangest error and i can't figure out what is wrong.
 
When my SELECT statement is...
 
SQLTemp="select * from Blocks_Setup where position='Left'"
 
I get this error when i test the webpage.

(0x80004005)
Unspecified error 
/Blocks.asp, line 6

But it works fine, if my select statement is....

SQLTemp="select * from Blocks_Setup"
 
And the line i get the error on is...

set rstemp=conntemp.execute(SQLTemp)

 

I'm not sure what is going on here. I have tried setting the position field in the databased to be indexed, but it didn't help.

Does anyone know what is going on, and how i can fix it?




Edited by Dekieon - 17 February 2005 at 11:54pm
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 18 February 2005 at 12:29am
I believe position is a reserved word. So is Left, but not in this context.

Lead me not into temptation... I know the short cut, follow me.
Back to Top
Dekieon View Drop Down
Newbie
Newbie


Joined: 17 February 2005
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dekieon Quote  Post ReplyReply Direct Link To This Post Posted: 18 February 2005 at 12:38am

yep that fixed it. just renamed position to blockposition.

thanks a bunch
 


Edited by Dekieon - 18 February 2005 at 12:39am
Back to Top
 Post Reply Post Reply

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.