2008年9月15日星期一

[fw-db] Zend_Db_Adapter_Sqlite: fetchAll()

Hi folks,

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".

The query method is to use a Zend_Db_Select object and fetchAll() with
FETCH_ASSOC mode.

I understand this *may* be an issue with the current version of sqlite libs
I'm using so before I re-open http://framework.zend.com/issues/browse/ZF-884
would some of you be so kind as to confirm what sqlite libs you are using?

My distro is currently on php 5.2.6 with the following version of sqlite libs

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

This would seem to be the latest version available through PECL at least so
far as I can tell...

Cheers
Graham

没有评论: