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