qcheckboxcolumn example is broken

[olegabr]

http://examples.qcu.be/assets/_core/php/examples/dynamic/qcheckboxcolumn.php

Exception in PHP Script /assets/_core/php/examples/dynamic/qcheckboxcolumn.php
MySqli Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"related_project_assn"
    where 
"child_project_id" = `t0`.`id` 
' at line 15

Query:   Show/Hide

SELECT

    `t0`.`id` AS `a0`,
    `t0`.`project_status_type_id` AS `a1`,
    `t0`.`manager_person_id` AS `a2`,
    `t0`.`name` AS `a3`,
    `t0`.`description` AS `a4`,
    `t0`.`start_date` AS `a5`,
    `t0`.`end_date` AS `a6`,
    `t0`.`budget` AS `a7`,
    `t0`.`spent` AS `a8`,
    ((select 
                            "project_id"
                        from 
                            "related_project_assn"
                        where 
                            "child_project_id" = `t0`.`id` 
                             and "project_id" = 1)) AS `__assn_item`
FROM
    `project` AS `t0`

LIMIT 15

[vaibhav-kaushal]

Shouldn't this be in the example site's repo?

[olegabr]

Looks like it does not likes double quotes in a subquery

[olegabr]

"Shouldn't this be in the example site's repo?" I don't think so. first of all, because no one watches events from any repository different from qcubed/framework.

[kukrik]

Great work from @ olegabr. This revised code example http://localhost:8888/qcubed_2.2.0/assets/_core/php/examples/dynamic/ccheckboxcolumn.php works perfectly. Thanks!