3 messages in com.mysql.lists.javaWhat is SQLSTATE for indicating empty...
FromSent OnAttachments
Paul DuBois25 Apr 2004 13:37 
Igor Dayen25 Apr 2004 13:57 
Igor Dayen25 Apr 2004 14:35 
Subject:What is SQLSTATE for indicating empty result set?
From:Igor Dayen (in@objcentric.com)
Date:04/25/2004 01:57:36 PM
List:com.mysql.lists.java

In the stored procedure fragment below there is a need to make some decision if
table is empty.

DECLARE CONTINUE HANDLER FOR SQLSTATE xxxxxx SET EMPTY_SET = 1;

SELECT * FROM SOME_TABLE;

IF EMPTY_SET=1 THEN ............

What is correct SQLSTATE for indicating this? Is there any SQLCODE reserved for
this?

Thanks very much.