Author: Gina Glenewinkel <gglenewi AT CSC DOT COM>
Date: Tue, 17 Apr 2001 10:17:50 -0500
Some time ago I posted to this list a question about how to find out if my old management classes are still managing any client data. A couple of you responded suggesting this select statement: selec
Author: "Lambelet,Rene,VEVEY,FC-SIL/INF." <Rene.Lambelet AT NESTLE DOT COM>
Date: Tue, 17 Apr 2001 17:23:00 +0200
Could be that you wrote the class_name in lower case instead of higher case ? René Lambelet Nestec S.A. / Informatique du Centre 55, av. Nestlé CH-1800 Vevey (Switzerland) *+41'21'924'35'43 7+41'21'9
Author: Alan Davenport <alan.davenport AT SELECTIVE DOT COM>
Date: Tue, 17 Apr 2001 12:41:31 -0400
Make sure you use all upper case for any data passed to select statements. i.e., 'classname' should have been 'CLASSNAME'. Al Alan Davenport Selective Insurance alan.davenport AT selective DOT com
Author: Alex Paschal <AlexPaschal AT FREIGHTLINER DOT COM>
Date: Tue, 17 Apr 2001 10:45:07 -0700
The following select statement might be a way to find out what you wish to know. However, it'll probably take a while to run. select domain_name, class_name from mgmtclasses where class_name not in (