Jsp code with mysql -
i facing problem in mysql query. query working fine in php admin.whenever implementing through jsp code showing string literal not closed error.
here code
string query="select * ( (select supplierticketid supplierticketid, tickettype tickettype, supplierticketstatus supplierticketstatus, createdby createdby, suppliertype suppliertype supplierticket) union (select factoryticketid, tickettype, factoryticketstatus, factoryticketcreatedby, suppliertype factoryticket) )t";
plz me..what problem in query..thanks in advance
use below query :-
string query ="select * ( (select supplierticketid supplierticketid, tickettype tickettype, supplierticketstatus supplierticketstatus, createdby createdby, suppliertype suppliertype supplierticket) union (select factoryticketid, tickettype, factoryticketstatus, factoryticketcreatedby, suppliertype factoryticket) )";
Comments
Post a Comment