ASP/ADO/SQL Error message - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

ASP/ADO/SQL Error message

Author

Topic

SamC
White Water Yakist

3467 Posts

Posted - 2002-09-19 : 10:05:52

I have a procedure that returns the error

Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation.
Err Num = -2147217900

to ASP using

err.description, err.num

I've tried to use

SET NOCOUNT ON

to no avail. The results of the procedure are correct, and I'd like ASP to think it worked too.

Any help appreciated.

SamC

Edited by - SamC on 09/19/2002 10:08:53

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-09-19 : 10:12:07

You can add SET ANSI_WARNINGS OFF to your procedure, that will clear the message.

FWIW it's not actually an error, just a message.

SamC
White Water Yakist

3467 Posts

Posted - 2002-09-19 : 10:23:50

Thanks Rob.

SamC

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources