Re: [fw-general] Using Zend_Db_Select without a db connection

2009-08-24 Thread Hector Virgen
Hi Ralph, I am using Zend_Db_Select to help me build the query for an "advanced search" page that contains about 20 different form elements. Through Javascript, the user can decide which fields they want to search, so my backend needs to be able to dynamically build the SQL query based on which fie

Re: [fw-general] Using Zend_Db_Select without a db connection

2009-08-24 Thread Ralph Schindler
Hector, what is your use case? I've thought about this a couple of times, and I wonder if having a null adapter as part of the Zend_Db_Adapter would make sense for some use cases. The thing you have to consider is that several adapters do differnet things when it comes to how they quote ident

Re: [fw-general] Using Zend_Db_Select without a db connection

2009-08-19 Thread Hector Virgen
Thanks, Benjamin! Do you know if it will create MySQL-compatible select queries? -- Hector On Wed, Aug 19, 2009 at 9:53 AM, Benjamin Eberlei wrote: > hello hector, > > you can use Zend_Test_DbAdapter, which is a testing adapter that does not > connect to the database. > > greetings, > Benjamin

Re: [fw-general] Using Zend_Db_Select without a db connection

2009-08-19 Thread Benjamin Eberlei
hello hector, you can use Zend_Test_DbAdapter, which is a testing adapter that does not connect to the database. greetings, Benjamin On Wednesday 19 August 2009 06:50:52 pm Hector Virgen wrote: > Hello, > I am currently working on an older project that is not in ZF, but I'd like > to use Zend_D

[fw-general] Using Zend_Db_Select without a db connection

2009-08-19 Thread Hector Virgen
Hello, I am currently working on an older project that is not in ZF, but I'd like to use Zend_Db_Select to help me build some complex select queries. I don't want to open a new connection to the database since this application already has one open using good ol' mysql_connect(). My question is, si