Getting an SP to return a simple int

[ryan]

I can't seen to get ASP to simply return something like so. Could you please help, I've been working at this from several angles but I can't seem to get it.

***************************
create proc getnextid as
declare @myid int
begin tran
select @myid = (select idvalue from ids where idfield='nextid')
update ids set idvalue = @myid + 1 where idfield = 'nextid'
commit tran
select @myid as 'myid'
go
***************************

 

[link9]

create proc getnextid as
declare @myid int OUTPUT
begin tran
select @myid = (select idvalue from ids where idfield='nextid')
update ids set idvalue = @myid + 1 where idfield = 'nextid'
commit tran
select @myid as 'myid'
go

Have to declare it as an output parameter. Then, your ASP page will have read access to it through the command object.


paul