Does it work without quoteInto? If it does, you could do escape/filter the values yourself and then use Zend_Db_Expr to create expression? OR Just generate string for use in where() method yourself.
On 24 May 2010 14:06, Саша Стаменковић <[email protected]> wrote: > Yeah, quoteInto connects to db for every quoted value, and that breaks my > limit of 15 queries at once, even I only run one select and one update > query, it quotes array of values. What should I do? > > Regards, > Saša Stamenković > > > > On Thu, May 20, 2010 at 3:14 PM, Саша Стаменковић <[email protected]>wrote: > >> Only in development environment :) >> >> Thanks. >> >> Regards, >> Saša Stamenković >> >> >> >> On Thu, May 20, 2010 at 3:13 PM, Daniel Latter <[email protected]>wrote: >> >>> >>> Ive heard about a problem with the zf debug bar where it creates extra >>> connections? are you using this? >>> >>> >>> On 20 May 2010 14:07, Саша Стаменковић <[email protected]> wrote: >>> >>>> I'm on shared hosting, so I can't do that. >>>> >>>> I'm quoting like this: >>>> >>>> return $this->fetchAll( >>>> $this->select() >>>> ->from($this->_name) >>>> ->where($this->getAdapter()->quoteInto($this->_name . '.id IN (?)', >>>> $ids, Zend_Db::INT_TYPE)) >>>> ->order('date DESC') >>>> ); >>>> >>>> where $ids is array of table primary keys. >>>> >>>> Regards, >>>> Saša Stamenković >>>> >>>> >>>> >>>> On Thu, May 20, 2010 at 3:02 PM, Thomas D. <[email protected]>wrote: >>>> >>>>> Hi, >>>>> >>>>> Саша Стаменковић wrote: >>>>> > I don't know how to monitor mysqld, maybe get connection >>>>> > from adapter with getConnection() and then retreive it from there and >>>>> log? >>>>> >>>>> No. Monitoring your mysqld has nothing to do with PHP. >>>>> >>>>> If you are on Unix or FreeBSD, you would use a tool like "mtop". >>>>> If you are on Windows you can use the MySQL Administrator from >>>>> mysql.org. >>>>> >>>>> >>>>> P.s.: When you are quoting, how do you do that? >>>>> $table = new MyZendTable(); >>>>> $adapter = $table->getAdapter(); >>>>> >>>>> $quoted_string = $adapter->quote(...); >>>>> >>>>> If you are using "getConnection()" you will create an additional >>>>> connection/object and won't use the existing one. >>>>> Maybe this is your problem... >>>>> >>>>> >>>>> -- >>>>> Regards, >>>>> Thomas >>>>> >>>>> >>>>> >>>> >>> >> >
