sql query is not executing properly in zend framework

Question

Table : sc_message 
  ______________________________________________________________________
 |message_id | message_sender_id | message_receiver_id | message_content|
 ------------------------------------------------------------------------  

Table : sc_user 
  _____________________
 | user_id | user_name |
 ----------------------- 
$Query_1 = $this ->select()
                 ->from(array('msg' => 'sc_message'), array('msg.message_sender_id, msg.message_receiver_id, msg.message_content, msg.message_sent_on'))
                 ->join(array('usr' => 'sc_user'), 'msg.message_sender_id = usr.user_id', array('usr.user_name as sender_name'))
                 ->where('msg.message_id = ?',$message_id)
                 ->order('msg.message_sent_on');

die($Query_1->__toString());

I am writing above query but some how it is not giving me error

  Warning: Select query cannot join with another table in E:\wamp\www\social_site\library\Zend\Db\Select.php on line 1222

can anyone tell me what can be the probable reason?

Sudhir Bastakoti · Accepted Answer · 2012-04-16 07:48:02Z

1

Try setting:


$this->setIntegrityCheck(false); //after select() line

Hope that helps

answered Apr 16, 2012 at 7:48

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sql query is not executing properly in zend framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related