Hello,
("select * from ams_menuitems where role is (select logintype from ams_login where loginname= '"+user1.trim()+"');");
Shouldn't the query have "IN" instead of "is" ?
Also subquery will not need the ";" as per my interpreation of the query posted above.
Regards,
Amit