You might want to tweak your SQL slightly though in order to be database-independent:
SELECT MAX(blah) AS MAXBLAH FROM ...
This gives the results a predictable name instead of whatever the DBMS decides to generate.
Of course, in
JDBC, you can avoid the issue by using "
bigBlah = rs.getDate(0);" for the case in question. It should be slightly more efficient, since the field name doesn't have to be resolved.
[ January 24, 2002: Message edited by: Tim Holloway ]
[ January 24, 2002: Message edited by: Tim Holloway ]
[ January 24, 2002: Message edited by: Tim Holloway ]
The secret of how to be miserable is to constantly expect things are going to happen the way that they are "supposed" to happen.
You can have faith, which carries the understanding that you may be disappointed. Then there's being a willfully-blind idiot, which virtually guarantees it.