DB:OCI8:modifyLimitQuery Possible Bug
| From: | Julien Mourot | 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