-- Ian Warner <[EMAIL PROTECTED]> wrote
(on Wednesday, 22 August 2007, 11:48 AM +0900):
> Thank you for the guidance.
>
> The manual is misleading then:
>
> "The second argument can be an array of SQL expressions. The expressions
> are combined as Boolean terms using an AND operator.
>
> Since the table delete() method proxies to the database adapter delete()
> method, the second argument can be an array of SQL expressions. The
> expressions are combined as Boolean terms using an AND operator."
>
> It kinda reads that I create the array and the AND is substitued
> autmoaticall on iteratating the array I pass in.
That *does* work. What *didn't* work in your original attempt was
placeholder substitution:
'user_id = ?' => $user
(BTW, there is *no* place in Zend_Db where the above would work.)
The following *would* work:
$adapter = $table->getAdapter();
$where = array(
$adapter->quoteInto('user_id = ?', $user),
$adapter->quoteInto('video_id = ?', $this->_getParam('code')),
);
> Matthew Weier O'Phinney wrote:
> >-- Ian Warner <[EMAIL PROTECTED]> wrote
> >(on Tuesday, 21 August 2007, 05:31 PM +0900):
> >>I have
> >>
> >>$where = array(
> >> 'user_id = ?' => $user,
> >> 'video_id = ?' => $this->_getParam('code')
> >>);
> >>
> >>$table->delete($where);
> >
> >You need a well-formed WHERE clause, not an assoc array of column/value
> >pairs. Try this:
> >
> > $adapter = $table->getAdapter();
> > $where = $adapter->quoteInto('user_id = ?', $user)
> > . ' AND ' . $adapter->quoteInto('video_id = ?',
> > $this->_getParam('code'));
> > $table->delete($where);
> >
> >
> >>and I am getting the Exception:
> >>
> >>Failed: Mysqli prepare error: Unknown column 'M1F94C3359F8FFC35B' in
> >>'where clause'
> >>
> >>$this->_getParam('code') = M1F94C3359F8FFC35B
> >>
> >>I just dont understand why it is using the value of code as a column
> >>name when it should be using video_id ?
> >>
> >>Cheers
> >>
> >>Ian
> >>
> >
>
--
Matthew Weier O'Phinney
PHP Developer | [EMAIL PROTECTED]
Zend - The PHP Company | http://www.zend.com/
