When using cfstoredproc and a sql server stored procedure, I can return @@identity and @@rowcount together using cfprocparams of type out. Then I can cfoutput them both together.
WHen using cfquery and
insert ...etc
select @@identity as recno
select @@rowcount as reccount
thequeryname.reccount is undefined-I can't cfoutput it.
Is there a way to get both recno and reccount without a stored procedure?
WHen using cfquery and
insert ...etc
select @@identity as recno
select @@rowcount as reccount
thequeryname.reccount is undefined-I can't cfoutput it.
Is there a way to get both recno and reccount without a stored procedure?