mercredi 17 juin 2015

How to prepared statement in WebSql with GROUP_CONCAT

How do I change this MySql prepared statement into WebSql query statement

"SELECT a.id,a.title, CONCAT('[', GROUP_CONCAT( CONCAT('{"id":',b.id,', "name":"',b. `name`,'", "number":"',b.number,'"}') ORDER BY b.name), ']')AS people FROM contact_group AS a LEFT JOIN contact_list AS b ON a.id = b.gID GROUP BY a.id, a.title"

I have done everything I could but it is still giving me error. I will be glad if anyone can help me or point me in the right direction. Thank you

Aucun commentaire:

Enregistrer un commentaire