Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.11.5
Request #3425 Delete + Inner Join
Submitted: 2005-02-10 16:19 UTC
From: sylfradev at yahoo dot fr Assigned:
Status: Suspended Package: DB_DataObject
PHP Version: 4.3.3 OS: Windows 200
Roadmaps: (Not assigned)    
Subscription  


 [2005-02-10 16:19 UTC] sylfradev at yahoo dot fr
Description: ------------ When you add joins with joinAdd, they are not used in DELETE queries, whereas they work with SELECT queries Expected result: ---------------- This should produce a query like that : DELETE FROM X USING X INNER JOIN Y ON X.a=Y.a whereas it gives : DELETE FROM X So I have to use : $factory->query("DELETE FROM ". $factory->tableName() . " USING " . $factory->tableName() . " " . $factory->_join . " " . $factory->_query['condition']);

Comments

 [2005-02-24 09:45 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!
 [2009-10-13 05:47 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!