Thanks Brian.  That was my problem.


Bryan Pendleton <bpendleton@amberpoint.com> wrote:
> java.sql.SQLException: Column '0' not found.

It sounds like you are calling rs.getString("0"). If you want to get
the first column in the result, you should know that columns
in the JDBC api are numbered starting at 1:
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/ResultSet.html#getString(int)

Perhaps you should call rs.getString(1) instead.

thanks,

bryan




Looking for last minute shopping deals? Find them fast with Yahoo! Search.