SQL Alias Column Names not working??
Posted: 09 Dec 2008, 00:12
I have code similar to this....
please tell me there is a way to get this to work?!
Code: Select all
sql="select id as myid from users";
queryRes=db.executeQuery(sql);
row=(DataRow)queryRes.get(0);
row.getItem("myid"); //does not work
row.getItem("id"); //does work
please tell me there is a way to get this to work?!