DB:OCI8:modifyLimitQuery Possible Bug

From: Date: Thu, 03 Jul 2003 12:37:30 +0000
Subject: DB:OCI8:modifyLimitQuery Possible Bug
Groups: php.pear.dev 
Request: Send a blank email to pear-dev+get-17955@lists.php.net to get a copy of this message
Hi pear it seems there is a bug when using modifyLimitQuery on a query which has alias like Select fielda as "Field Number one" from dual since the functions runs the query taking the alias of the field the query becomes select field number one from dual Adding " " could avoir DB error , Something like that avoid the error $fields = implode('","', $cols); $fields ='"'.$fields. '"'; but the second problem is that we loose the original field name since the query is altered , the best thing would maybe be to hold column and alias at the top level query.. hope this helps and thanks for this nice package

« previous php.pear.dev (#17955) next »