Can't Figure Out If anything is returned

[jlindahl]

I have a stored procedure that I can't tell if it is working.

<code>
alter procedure dbo.confirmcomplete
(
@requestID varchar(50)
)
as
set nocount on;

if not exists (select mId from table where mID = @requestID)
return(0)

else
if not exists (select mID from table where mId = @requestID and mCriteria2 = @criteria2)
return(2)

</code>

this stored procedure seems to no be sending the return values 0 or 2.

Please help. I have code that depends on the return values of these sp's.

Thanks.

 

[jlindahl]

After thinking, I shouldn't have to create an output parameter right? Can't you use the return command to return an interger value and use either executescalar or executenonquery?

 

[tgreer]

Yes. You can also use .HasRows and other properties.

Thomas D. Greer

http://www.tgreer.com

Providing PostScript & PDF
Training, Development & Consulting

If this post was helpful, click some ads! My personal site is also advertiser-supported. Hint, hint!

 

[jlindahl]

but to use those properties, i must return a recordset, right?
That is not what i want to do. I only want a single value returned that i check against a case statement.

 

[DaZZleD]

and your stored procedure doesn't return anything? or it is but you cannot read what that value is?

--------------------------
"two wrongs don't make a right, but three lefts do" - the unknown sage

 

[jlindahl]

It seems that i have figured it out late last night. My stored procedure does return an integer value. What i ended up doing was setting up a returnvalue parameter in my asp page. This allowed me to get the 'Return()' value from the stored procedure.

 

[DaZZleD]

you can also use it as an sqlcommand and use ExecuteScalar to get the only value

--------------------------
"two wrongs don't make a right, but three lefts do" - the unknown sage

 

[jlindahl]

That is what i thought too, but i could not read the returned value.

 

[DaZZleD]

it is an object.

Object o = myCommand.ExecuteScalar();
if (o != null)
int value = (int)o;

--------------------------
"two wrongs don't make a right, but three lefts do" - the unknown sage

 

[jlindahl]

So all i have to do is set my variable to an object datatype? I will give that a try this evening.

 

[DaZZleD]

yes

--------------------------
"two wrongs don't make a right, but three lefts do" - the unknown sage