Peter, It looks like Witango is interpreting @@ROWCOUNT as an empty variable (as in <@var rowcount>). I've never tryed this in a sproc, but try using <@literal '@@rowcount'> instead so Witango doesn't process it and SQL Server will.
Jon -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 10:16 AM To: [email protected] Subject: Witango-Talk: strange query issue Hey, I am executing a query against a MSSQL2000 database. I am requesting the @@ROWCOUNT value in one of the columns. When i call the stored procedure from within sql query analyzer it gives me the correct value. When i call the stored procedure from Witango this value is coming back with a 0. Anyone seen anything like this? p. ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
