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

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -