Yes, that is the option, reinventing the wheel, but I'll try. Regards, Saša Stamenković
On Mon, May 24, 2010 at 3:30 PM, Daniel Latter <[email protected]> wrote: > 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 >>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> >
