Gene - Are you sure your stored procedure is outputting a result? Have you tested it outside of the Witango app?
jamileh > -----Original Message----- > From: Ben Johansen [mailto:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 11:17 AM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: Stored Procedures > > > 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 > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
