I have a simple stored procedure in a SQL Server 6.5 database, with one
input param and one output param.  The output param should get the same
value as the return value.  However, when I try to run the SP in a query
inside SQL Server, get a blank output for the output param, but the
correct answer for the return value.
(I have a separate problem with getting to it with VB6 and ADO, and
converting to SQL Server 7, which I will post another problem later)

Any ideas will be much appreciated.

Code follows.  (SP, then query, then results)
-----------------------------
Stored Procedure:
-----------------------------

as

--------------------------
Query:
-------------------------

-------------------
Query Results: (1 row matched)
----------------

Reg Table for TestMe -- Data Found 1 times
Reg Table for TestMe -- Data Found  times

-------------------------
-----------------------

Thanks.
--
============================================================
David Lakein -- ColdFusion, Visual Basic, Math+Statistics programmer
TeraTech Inc. - Tools for Programmers(tm)
100 Park Ave, Suite 360, Rockville MD 20850 USA
Voice: +1-301-424-3903
Web: http://www.*-*-*.com/

============================================================

When  you execute the stored procedure and you want the output parameter to
be "called by reference", you need to specify the OUTPUT keyword when you
invoke it:

Hope this helps!

John Peterson