Manuel Lemos wrote:
>
> > >
> > > But it does not work with computed columns like those that apply
> > > functions (COUNT, SUM, SUBSTRING, etc...). The code assumes that you are
> > > actually selecting only real table fields. I think it also does not work
> > > with columns with table name prefixes.
> >
> > That's partially true. But it's a common practise to use column aliases
> > in conyunction with functions (and a must for assoc fetchs) and this is
> > supported by the code I wrote, for ex:
> >
> > select count(field) as count from foo;
>
> That would work, but you require people to change their queries. I guess
> that does not work as general practice because.
>
> > Also if Oracle name a sum(foo) column as "sum" will be trivial to add
> > it.
I ran a query without the column alias and seems that Oracle names that
column with the entire name for ex: "sum(foo)". If that is true the
support could be completed.
I'll try it when get some free time or if some kind guy could send the
output of this:
$db = DB::connect("oci8://...");
print_r($db->getRow("select count(somefield) from table",
DB_FETCHMODE_ASSOC));
here, would be so great :-)
Tomas V.V.Cox
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
