Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
attackmonkey
Starting Member
19 Posts |
 Posted - 2001-06-15 : 10:46:28
|
| Hi folks,More problems from me again!I have a stored procedure that works fine on our dev server, but which doesn't return anything to the ASP page on the live server. The SP is definately returning the values, as if you run it in the Query Analyzer on the live server, it works. On the live sertver however, it doesn't even open the recordset!Here's the code:CREATE PROCEDURE [AddNewRegistration] @Email varchar(75),@Password varchar(25)ASinsert into Users (US_Email, US_Password) values (@Email, @Password)SELECT US_ID,US_FRIENDLY FROM USERS WHERE US_FRIENDLY= @@IDENTITYTo call the procedure I am using the following code on the page:Set rsUser = Conn.Execute("AddNewRegistration 'someone@somewhere.com','password'")Anyone got any ideas? I'm stumped! |
|
|
|
|
|
Stored Procedure Not Returning values