>
> I've been converting a schema from MySQL to SQLite and come across the
> issue (
> ZF-884) of queries returning column names in the format
> "tablename.columnname".
>
> PECL Module version 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.3 2007/12/31
> 07:20:10 sebastian Exp $
> SQLite Library 3.5.7
>
It appears to be working for me, but I recall that different versions of PHP
do exhibit the problem you're describing.
In my current PHP environment, the PRAGMA statements are taking effect, so
SQLite result set keys are returned as the name of the column, not the name
of "tablename.columnname".
I'm using PHP 5.2.5 on Mac OS X.
PECL Module version => 1.0.1 $Id: pdo_sqlite.c,v
1.10.2.6.2.2 2007/03/23 14:30:00 wez Exp $
SQLite Library => 3.5.8
I have no idea if this is dependent on the version of the SQLite library or
the way the SQLite library was built, or the version of pdo_sqlite.c, or PHP
itself, or some other environmental issue. Your guess is as good as mine.
Regards,
Bill Karwin
--
View this message in context: http://www.nabble.com/Zend_Db_Adapter_Sqlite%3A-fetchAll%28%29-tp19490165p19544299.html
Sent from the Zend DB mailing list archive at Nabble.com.
没有评论:
发表评论