LinkBack URL
About LinkBacks
Reply With Quotehi, i was told you need to set setIntegrityCheck to false
i also found an article about improvements in zend_db_table:
Zend Framework in Action Zend_Db_Table_Abstract in version 1.5
Junior Member
Problems with join()
Hello.
I have the following problem:
I want to use Zend_Db_Table_Select to join two tables, but I always get this error message:
This is the code I'm using:Code:Warning: Select query cannot join with another table in /home/.../Zend/Db/Table/Select.php on line 191 Fatal error: Uncaught exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty' in /home/.../Zend/Db/Statement/Pdo.php:238 Stack trace: #0 /home/.../Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/.../Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array) #2 /home/.../Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Table_Select), Array) #3 /home/.../Zend/Db/Table/Abstract.php(1184): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select)) #4 /home/.../Zend/Db/Table/Abstract.php(1039): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select)) #5 /var/www/.../test/test.php(26): Zend_Db_Table_Abstract->fetchAll(Object(Zend_Db_Table_Select)) #6 {main} thrown in /home/.../Zend/Db/Statement/Pdo.php on line 238
[PHP]$table = new Members();
$select = $table->select();
$select->join('groups', 'members.group_id=groups.id', 'groups.name');
$rows = $table->fetchAll($select);
[/PHP]
My database has the following tables:
members: id,group_id,[...]
groups: id,name
Members.php:
[PHP]class Members extends Zend_Db_Table_Abstract {
protected $_name = 'members';
}[/PHP]
and Groups.php
[PHP]class Groups extends Zend_Db_Table_Abstract {
protected $_name = 'groups';
}[/PHP]
I hope I gave all relevant information; if not, please tell me!
I hope someone can help me.
Cheers,
Florian
Junior Member
setintegritycheck
hi, i was told you need to set setIntegrityCheck to false
i also found an article about improvements in zend_db_table:
Zend Framework in Action Zend_Db_Table_Abstract in version 1.5
Junior Member
Junior Member
Does this property select() only exist in specific versions of ZF (i'm guessing 1.5?)? When I try to use it in my version 1.0.4 it says this is not a property.
Junior Member
Junior Member
Hi, I've been trying a similar thing, with setIntegrityCheck(false).
I have two tables, Prizes and Products (Prizes being a type of product, and they share the same primary key), which need to be joined together. I've been trying something like this:
$select->setIntegrityCheck(false)->joinNatural('Products')......
where $select is a zend_db_table_select from the zend_db_table for prizes
and I get a result that looks like this: SELECT `Products`.* FROM `Products`
when I echo out the select. Why is this happening?
Senior Member
Are you defining your relationships between the tables?
Zend Framework: Documentation
Junior Member
I defined my relationships, I'll double check that I did it correctly (in this case Products is a dependent table for Prizes?). If this is done correctly, would that enable me to join, without disabling the reference check?
Junior Member
I think I'm having the same problem as the OP. I have 2 tables with correctly defined relationships, message and user. I want to get all messages (as a RowSet) for all users who meet certain criteria. Sort of like:
SELECT m.* FROM messages m
JOIN users u on u.id = m.user_id
WHERE u.name LIKE 'fred%'
At the moment, I'm doing (inside the Message class, ignoring quoting):
[PHP]
$select = $this->select();
$select->join('user', 'user.id = message.user_id')
->where('u.name LIKE ?', $name);
[/PHP]
My question: Is this possible, and how??? If it's not possible, it seems to me a major failing of the framework.
Junior Member
And, I've just found a solution
Adapted from a Nabble forum thread (second-to-last post):
[PHP]$select = $this->select();
$select->join('user', 'user.id = message.user_id', array())
->where('u.name LIKE ?', $name); [/PHP]
The fix was adding an empty columns array to the join. Hope this helps someone...
Posting Permissions
