That was weird... My reply got trashed somewhere along the path to Australia... It should read:
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. -----Original Message----- From: Jon Pevzner [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 1:09 PM To: [email protected] Subject: RE: Witango-Talk: strange query issue 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>'@@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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
