Hello, I try to use a subqueries with dhtmlxGridConnector.
I saw on a post that i have to use vers. 1.0, so i installed it, but it not works better …
[code]<?php
require_once("…/dhtmlxConnector_NEW/codebase/grid_connector.php");
include("…/…/var.php");
$pid = $_GET[‘palier’];
$auj = date(‘Y-m-d’);
$req = “SELECT alliances.id as AId, concat(projets.nom,’ ‘,projets.commentaire,’ ‘,alliances.commentaire) as PROJET, concat(hostname,’ ',ip) as SERVEUR , plateformes.datedebut, plateformes.datefin, (select count(*) FROM plateformes p WHERE p.alliance = alliances.id AND ‘$auj’ between p.datedebut and p.datefin) as mut FROM plateformes, alliances, serveurs, projets WHERE plateformes.palier = $pid AND plateformes.alliance = alliances.id AND alliances.serveur = serveurs.id AND alliances.projet = projets.id ORDER BY PROJET ASC”;
$grid = new GridConnector($conn);
$grid->render_sql($req, ‘AId’,‘AId,mut,PROJET,SERVEUR,datedebut,datefin’, ‘’, ‘’);
?>[/code]
I’ve tried with a simple select, and i have the same error : Incorrect XML.
When I tried to display the connector page, instead of having the xml, i’ve got :
Object id #7
strange no ?
seams to have a problem with function OutputWritter in base_connector.php …
(sorry for this post, i’m french and not very fluent in english …)
thanks for help me
marion.