I am using getMetaData to retrieve column names from a database to build a form in one of my servlets. I thought that
would return the caption instead of the name, but it is not, or I am doing something wrong. How can I get the column caption in an access database instead of the column name? Here is the code from the servlet:
mike sutton
Greenhorn
Joined: Dec 07, 2000
Posts: 14
posted
0
I am not sure what happened when I tried to post my code, but here it is again
mike sutton
Greenhorn
Joined: Dec 07, 2000
Posts: 14
posted
0
o.k. third try, this time without the code tag: try { stmt = l.dbCon.createStatement(); rs = stmt.executeQuery(qry.toString()); ResultSetMetaData rsmd= rs.getMetaData(); int numberofcolumns = rsmd.getColumnCount(); while(rs.next()){ for (int i =1; i<= numberofcolumns; i++ ){