Normally it is done by the <@ROWS> (In the results HTML of the DirectDBMS) <@ROWS> <@ASSIGN user$SPReturn VALUE="<@COL 1>"> </@ROWS> -or- you can also look in the @@resultSet
Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -----Original Message----- From: Wolf, Gene [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 5:28 AM To: '[EMAIL PROTECTED]' Subject: Witango-Talk: Stored Procedures I am trying to execute a stored procedure in SQL Server 2000. We are using Witango 5. I use a Direct DBMS to call the stored procedure. The procedure runs (I did a test insert at the end to check). My problem is that I can't seem to get it to return a value. Can someone please tell me how to: return a value in the stored procedure and read it back in the calling program? Thanks Gene Wolf Business Systems Analyst DRS Optronics, Inc. 2330 Commerce Park Drive Palm Bay, Florida 32905 Phone: 321-984-9030 ext: 685 E-mail: [EMAIL PROTECTED] ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
