I keep getting the above error when i run a sql from my web page. The query runs fine in enterprise manager. What is worng . Please help.
sql="SELECT top 1 * FROM V_ISSUE WHERE ISSUE_ID=" & issueid & " order by issue_id"
if Session("rs").State = 1 then Session("rs").Close
Session("rs").Open sql,Session("MyConn")Please Try this Code
sql="SELECT top 1 * FROM V_ISSUE WHERE ISSUE_ID=" & issueid & " order by issue_id"
Session("rs").Open sql,Session("MyConn")
Session("rs").close
Set Session("rs")=Nothing
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment