Re: [ANNOUNCEMENT] DB_DataObject-1.0 (stable) Released.
| From: | Alan Knowles | 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