PDA

View Full Version : java 'Select from' does not recognize as error


BubikolRamios
04-28-2009, 10:05 AM
just lost an hour with this, missing * in sql, and it dies at line 4 (lat_deg does not exists !?), not before as I would expect
-->

in mysql query browser sql like this does not work, of course


strSql = " Select FROM ..."
con.setDataSet(strSql);
con.rs.first();
Integer lat = con.rs.getInt("lat_deg");

servlet
04-28-2009, 11:39 AM
Verify that the underlying table has lat_deg column.

BubikolRamios
04-28-2009, 11:41 AM
jeah it does have it , the point of post is missing * in sql, which gets ignored to the point of demand of actual data.