Print Page | Close Window

(0x80004005) Unspecified error - Help!

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=13872
Printed Date: 29 March 2026 at 12:32pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: (0x80004005) Unspecified error - Help!
Posted By: Dekieon
Subject: (0x80004005) Unspecified error - Help!
Date 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?





Replies:
Posted By: dpyers
Date 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.


Posted By: Dekieon
Date Posted: 18 February 2005 at 12:38am

yep that fixed it. just renamed position to blockposition.

thanks a bunch
 



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net