Re: [ANNOUNCEMENT] DB_DataObject-1.0 (stable) Released.

From: Date: Fri, 18 Jul 2003 00:33:05 +0000
Subject: Re: [ANNOUNCEMENT] DB_DataObject-1.0 (stable) Released.
References: 1 2  Groups: php.pear.general 
Request: Send a blank email to pear-general+get-6656@lists.php.net to get a copy of this message
is this happening when you double query the same object - eg. $obj->find(); $obj->fetch(); $obj->find(); One of the changes was to reset the vars where/limit/select elements of the query at the fetch stage, - to try and reduce the output when doing large joins. normally the recommending way of doing the above is. $obj2 = $obj->clone(); $obj->find(); $obj->fetch(); $obj2->find(); As doing a second find on an object has unpredictable results. Regards Alan xavier wrote:
Hi all, i got a problem with this latest release of DB_DataObject. Since upgrade, some find calls return errors, something strange: the generated sql query doesn't have a * in... , generated select queries start with : SELECT FROM table , whereas it should start with : SELECT * FROM i'm working on postgresql backend . Is there anybody with the same problem ? here is on line of the error backtrace -------------------- [8] => Array ( [file] => /usr/local/lib/php/DB/DataObject.php [line] => 326 [function] => debug_backtrace [class] => do_t_produits [type] => -> [args] => Array ( [0] => SELECT FROM t_produits WHERE t_produits.prd_id = 12 AND t_produits.typ_id = 9 AND t_produits.fam_id = 1 AND t_produits.gam_id = 7 AND t_produits.prd_cible = 'e' AND t_produits.prd_nom_def = 'Package Champion' AND t_produits.prd_date_maj = '2003-05-28 13:52:38' AND t_produits.ass_id = 2 AND t_produits.prd_url_image = 'no_img.gif' AND t_produits.prd_reducpossible = 'o' AND t_produits.prd_affich_desc = 'o' AND t_produits.prd_age_max = 0 ) ) -------------- regards -- Xavier
-- Can you help out? Need Consulting Services or Know of a Job? http://www.akbkhome.com

« previous php.pear.general (#6656) next »