Set rsBooks = Server.CreateObject("ADODB.RecordSet") rsBooks.ActiveConnection = strConn rsBooks = Connection.Execute("Call sp_getBooks(""King James"");") rsBooks.Open "Call sp_getBooks(""King James"")" response.write (" TEST ") rsBooks.Close ---- i get a "can not return result in current context" error. PLEASE HELP
i'm no asp expert as i haven't coded in that in over 5 to 6 years.. now i'm more a opensource language coder... PHP/Python and hopefully Ruby soon... anyhow those quotes seems a bit odd to me... rsBooks = Connection.Execute("Call sp_getBooks(""King James"");") Why not try something like: rsBooks = Connection.Execute("Call sp_getBooks('King James');") OR rsBooks = Connection.Execute("Call sp_getBooks(\"King James\");") but as I mentioned I no longer remeber anything about asp and its syntaxes