Exception occurred

[azrina]

Hi all.
I got this error when I run the page on localhost.

Error Type:
Error Type:
(0x80020009)
Exception occurred.
/biotec_dwnstairs/sokongan_senarai.asp, line 8


Below is the portion of my code.
The commented shows line 8 where the error is.

<%
    set gpermohonan = server.CreateObject("adodb.recordset")
    gpermohonan.open " SELECT * FROM permohonan WHERE sokong IS NULL and jpk = 1 ",conn
    set gstaf = server.CreateObject("adodb.recordset")
    gstaf.open "SELECT * FROM staf WHERE id='"&gpermohonan("id")&"'" ,conn 'line 8
%>

Why the error occur?
Can anyone help me correct the error?
Thanks in advance.

[Shuja Ali]

Did you try putting proper spaces in between

gstaf.open "SELECT * FROM staf WHERE id='" & gpermohonan("id") & "'" , conn

[l12ngo]

Do you get a value if you response.write gpermohonan("id") after the first sql query (you can just throw in a response.end after it to stop the second query throwing up an error while you debug)? If so I'd probably try running that query through the sql server to see what it returns there.