Hi Everyone,

I got the following error trying to run an ASP page:

Technical Information (for support personnel)

Error Type:
(0x80004005)
Unspecified error
/chamber/board.asp, line 56

If I use the following code I get no errors:

strSql = "SELECT PORTAL_MBOARD.ID, PORTAL_MBOARD.FIRST, PORTAL_MBOARD.LAST"
strSql = strSql & " FROM " & strMemberTablePrefix & "MBOARD "
        set rs = Server.CreateObject("ADODB.Recordset")
        rs.open strSql, my_Conn, 3

but, if the first line is replaced by:
strSql = "SELECT PORTAL_MBOARD.ID, PORTAL_MBOARD.FIRST, PORTAL_MBOARD.LAST, PORTAL_MBOARD.POSITION"

it is already not working. The field "POSITION" has the same settings as the other ones (type: TEXT, required: NO. allow zero length: YES)

Any ideas where the problems is coming from?
Thanks.


Wilfred

Hi Wilfred,

It looks like Position is a reserved keyword. I changed the column name to Position2 and then it works correctly.

Funny thing is that when you don't prefix the column name with the table name (Position instead of PORTAL_MBOARD.POSITION) no error occurs.

Try changing the name of the column and the error will go away.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hi Imar,

Thanks for your suggestions.

You were correct, as soon as I renamed "POSITION" to "MPOSITION", the code started to run properly.

Thanks again,

Wilfred

Hi there
I got the same error, but in a deff place
'//////
Set conn2 = Server.CreateObject("ADODB.Connection")
conn2.Open xDb_Conn_Str
set rs2 = Server.CreateObject("ADODB.Recordset")
rs2.Open sSql_, conn2, 1, 2 (**)
    if Not rs2.Eof then
            Cost_Score_=rs2(CImp)
    end if

'//////
(**)the error refers this line
so can any one helps me
thanx alot


Mahmoud_Ramzy