Zend pdo_oci and pdo_mysql generating different query formats2019 Community Moderator ElectionHow to output MySQL query results in CSV format?Doctrine_Pager returns wrong results with multiple groupBy columnsOrder By different the others table id in MY SQLUsing of ORACLE rowId in Hibernate CriteriaHow to compare only the month and year between 2 tables in MySQLUpdate with subquery not working mysqlI want to show 0 if no record found for a particular dateUse multi-dimensional PHP array in to create friendly URLS for each menu item in MySQL databaseget all customer payment based on order idJasperReports Sum based on a Condition
Was this cameo in Captain Marvel computer generated?
Is it appropriate to ask a former professor to order a library book for me through ILL?
I am the person who abides by rules but breaks the rules . Who am I
Short story about cities being connected by a conveyor belt
Why does this boat have a landing pad? (SpaceX's GO Searcher) Any plans for propulsive capsule landings?
Paper published similar to PhD thesis
Why aren't there more Gauls like Obelix?
Tabular environment - text vertically positions itself by bottom of tikz picture in adjacent cell
How can I have x-axis ticks that show ticks scaled in powers of ten?
Should we avoid writing fiction about historical events without extensive research?
Short story about an infectious indestructible metal bar?
ESPP--any reason not to go all in?
Can I negotiate a patent idea for a raise, under French law?
If nine coins are tossed, what is the probability that the number of heads is even?
Did Amazon pay $0 in taxes last year?
Why do phishing e-mails use faked e-mail addresses instead of the real one?
Why is there an extra space when I type "ls" on the Desktop?
Giving a talk in my old university, how prominently should I tell students my salary?
Rationale to prefer local variables over instance variables?
How do you make a gun that shoots melee weapons and/or swords?
Ultrafilters as a double dual
Is there a logarithm base for which the logarithm becomes an identity function?
Too soon for a plot twist?
Unidentified signals on FT8 frequencies
Zend pdo_oci and pdo_mysql generating different query formats
2019 Community Moderator ElectionHow to output MySQL query results in CSV format?Doctrine_Pager returns wrong results with multiple groupBy columnsOrder By different the others table id in MY SQLUsing of ORACLE rowId in Hibernate CriteriaHow to compare only the month and year between 2 tables in MySQLUpdate with subquery not working mysqlI want to show 0 if no record found for a particular dateUse multi-dimensional PHP array in to create friendly URLS for each menu item in MySQL databaseget all customer payment based on order idJasperReports Sum based on a Condition
Oracle DB Adapter: "pdo_oci"
MySQL DB Adapter: "pdo_mysql"
Code used to build a JOIN query:
$db = Zend_Db_Table::getDefaultAdapter();
$db->setFetchMode(Zend_Db::FETCH_OBJ);
$select = $db->select()->from(array(
't1' => $this->_Table1
));
$select = $select->join(array(
't2' => $this->_Table2
), 't1.MENU_ID = t2.SUBMENU_ID',
array(
'MENU_ID',
'SET_REDIRECT_URL',
'SUBMENU_TYPE'
));
$select = $select->order(array(
'MENU_ID',
't2.DISPLAY_ORDER'
));
$select = $select->where('t1.IS_ACTIVE = ?', 'Y');
$result = $db->fetchAll($select);
Query Generated by Oracle Adapter (pdo_oci):
SELECT "t1".*, "t2"."MENU_ID" AS "parent_id", "t2"."SET_REDIRECT_URL", "t2"."SUBMENU_TYPE" FROM "DRP_ADMIN_MENU_MASTER" "t1" INNER JOIN "DRP_ADMIN_MENU_MAPPER" "t2" ON t1.MENU_ID = t2.SUBMENU_ID WHERE (t1.IS_ACTIVE = 'Y') ORDER BY "parent_id" ASC, "t2"."DISPLAY_ORDER" ASC
Query Generated by Mysql Adapter (pdo_mysql):
SELECT `t1`.*, `t2`.`MENU_ID` AS `parent_id`, `t2`.`SET_REDIRECT_URL`, `t2`.`SUBMENU_TYPE` FROM `DRP_ADMIN_MENU_MASTER` AS `t1` INNER JOIN `DRP_ADMIN_MENU_MAPPER` AS `t2` ON t1.MENU_ID = t2.SUBMENU_ID WHERE (t1.IS_ACTIVE = 'Y') ORDER BY `parent_id` ASC, `t2`.`DISPLAY_ORDER` ASC
Issue: Oracle DB is unable to identify t1 and t2 in [t1.MENU_ID = t2.SUBMENU_ID] unless they are in double quotes. And if I put double quotes manually, then mysql gives error.
Error in Oracle:
General error: 904 OCIStmtExecute: ORA-00904: "T2"."SUBMENU_ID":
invalid identifier
php mysql oracle zend-framework
asked 2 days ago
AvneeshAvneesh
63
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Oracle DB Adapter: "pdo_oci"
MySQL DB Adapter: "pdo_mysql"
Code used to build a JOIN query:
$db = Zend_Db_Table::getDefaultAdapter();
$db->setFetchMode(Zend_Db::FETCH_OBJ);
$select = $db->select()->from(array(
't1' => $this->_Table1
));
$select = $select->join(array(
't2' => $this->_Table2
), 't1.MENU_ID = t2.SUBMENU_ID',
array(
'MENU_ID',
'SET_REDIRECT_URL',
'SUBMENU_TYPE'
));
$select = $select->order(array(
'MENU_ID',
't2.DISPLAY_ORDER'
));
$select = $select->where('t1.IS_ACTIVE = ?', 'Y');
$result = $db->fetchAll($select);
Query Generated by Oracle Adapter (pdo_oci):
SELECT "t1".*, "t2"."MENU_ID" AS "parent_id", "t2"."SET_REDIRECT_URL", "t2"."SUBMENU_TYPE" FROM "DRP_ADMIN_MENU_MASTER" "t1" INNER JOIN "DRP_ADMIN_MENU_MAPPER" "t2" ON t1.MENU_ID = t2.SUBMENU_ID WHERE (t1.IS_ACTIVE = 'Y') ORDER BY "parent_id" ASC, "t2"."DISPLAY_ORDER" ASC
Query Generated by Mysql Adapter (pdo_mysql):
SELECT `t1`.*, `t2`.`MENU_ID` AS `parent_id`, `t2`.`SET_REDIRECT_URL`, `t2`.`SUBMENU_TYPE` FROM `DRP_ADMIN_MENU_MASTER` AS `t1` INNER JOIN `DRP_ADMIN_MENU_MAPPER` AS `t2` ON t1.MENU_ID = t2.SUBMENU_ID WHERE (t1.IS_ACTIVE = 'Y') ORDER BY `parent_id` ASC, `t2`.`DISPLAY_ORDER` ASC
Issue: Oracle DB is unable to identify t1 and t2 in [t1.MENU_ID = t2.SUBMENU_ID] unless they are in double quotes. And if I put double quotes manually, then mysql gives error.
Error in Oracle:
General error: 904 OCIStmtExecute: ORA-00904: "T2"."SUBMENU_ID":
invalid identifier
php mysql oracle zend-framework
asked 2 days ago
AvneeshAvneesh
63
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
It's been a while since I used ZFW, but have you tried using 'T2' instead of 't2' in the code? Or did the tables get created with case-sensitive, lowercase names?
– Christopher Jones
2 days ago
add a comment |
Oracle DB Adapter: "pdo_oci"
MySQL DB Adapter: "pdo_mysql"
Code used to build a JOIN query:
$db = Zend_Db_Table::getDefaultAdapter();
$db->setFetchMode(Zend_Db::FETCH_OBJ);
$select = $db->select()->from(array(
't1' => $this->_Table1
));
$select = $select->join(array(
't2' => $this->_Table2
), 't1.MENU_ID = t2.SUBMENU_ID',
array(
'MENU_ID',
'SET_REDIRECT_URL',
'SUBMENU_TYPE'
));
$select = $select->order(array(
'MENU_ID',
't2.DISPLAY_ORDER'
));
$select = $select->where('t1.IS_ACTIVE = ?', 'Y');
$result = $db->fetchAll($select);
Query Generated by Oracle Adapter (pdo_oci):
SELECT "t1".*, "t2"."MENU_ID" AS "parent_id", "t2"."SET_REDIRECT_URL", "t2"."SUBMENU_TYPE" FROM "DRP_ADMIN_MENU_MASTER" "t1" INNER JOIN "DRP_ADMIN_MENU_MAPPER" "t2" ON t1.MENU_ID = t2.SUBMENU_ID WHERE (t1.IS_ACTIVE = 'Y') ORDER BY "parent_id" ASC, "t2"."DISPLAY_ORDER" ASC
Query Generated by Mysql Adapter (pdo_mysql):
SELECT `t1`.*, `t2`.`MENU_ID` AS `parent_id`, `t2`.`SET_REDIRECT_URL`, `t2`.`SUBMENU_TYPE` FROM `DRP_ADMIN_MENU_MASTER` AS `t1` INNER JOIN `DRP_ADMIN_MENU_MAPPER` AS `t2` ON t1.MENU_ID = t2.SUBMENU_ID WHERE (t1.IS_ACTIVE = 'Y') ORDER BY `parent_id` ASC, `t2`.`DISPLAY_ORDER` ASC
Issue: Oracle DB is unable to identify t1 and t2 in [t1.MENU_ID = t2.SUBMENU_ID] unless they are in double quotes. And if I put double quotes manually, then mysql gives error.
Error in Oracle:
General error: 904 OCIStmtExecute: ORA-00904: "T2"."SUBMENU_ID":
invalid identifier
php mysql oracle zend-framework
asked 2 days ago
AvneeshAvneesh
63
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Oracle DB Adapter: "pdo_oci"
MySQL DB Adapter: "pdo_mysql"
Code used to build a JOIN query:
$db = Zend_Db_Table::getDefaultAdapter();
$db->setFetchMode(Zend_Db::FETCH_OBJ);
$select = $db->select()->from(array(
't1' => $this->_Table1
));
$select = $select->join(array(
't2' => $this->_Table2
), 't1.MENU_ID = t2.SUBMENU_ID',
array(
'MENU_ID',
'SET_REDIRECT_URL',
'SUBMENU_TYPE'
));
$select = $select->order(array(
'MENU_ID',
't2.DISPLAY_ORDER'
));
$select = $select->where('t1.IS_ACTIVE = ?', 'Y');
$result = $db->fetchAll($select);
Query Generated by Oracle Adapter (pdo_oci):
SELECT "t1".*, "t2"."MENU_ID" AS "parent_id", "t2"."SET_REDIRECT_URL", "t2"."SUBMENU_TYPE" FROM "DRP_ADMIN_MENU_MASTER" "t1" INNER JOIN "DRP_ADMIN_MENU_MAPPER" "t2" ON t1.MENU_ID = t2.SUBMENU_ID WHERE (t1.IS_ACTIVE = 'Y') ORDER BY "parent_id" ASC, "t2"."DISPLAY_ORDER" ASC
Query Generated by Mysql Adapter (pdo_mysql):
SELECT `t1`.*, `t2`.`MENU_ID` AS `parent_id`, `t2`.`SET_REDIRECT_URL`, `t2`.`SUBMENU_TYPE` FROM `DRP_ADMIN_MENU_MASTER` AS `t1` INNER JOIN `DRP_ADMIN_MENU_MAPPER` AS `t2` ON t1.MENU_ID = t2.SUBMENU_ID WHERE (t1.IS_ACTIVE = 'Y') ORDER BY `parent_id` ASC, `t2`.`DISPLAY_ORDER` ASC
Issue: Oracle DB is unable to identify t1 and t2 in [t1.MENU_ID = t2.SUBMENU_ID] unless they are in double quotes. And if I put double quotes manually, then mysql gives error.
Error in Oracle:
General error: 904 OCIStmtExecute: ORA-00904: "T2"."SUBMENU_ID":
invalid identifier
php mysql oracle zend-framework
php mysql oracle zend-framework
asked 2 days ago
AvneeshAvneesh
63
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 days ago
AvneeshAvneesh
63
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 days ago
Avneesh
asked 2 days ago
AvneeshAvneesh
63
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 days ago
AvneeshAvneesh
63
asked 2 days ago
AvneeshAvneesh
63
63
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
It's been a while since I used ZFW, but have you tried using 'T2' instead of 't2' in the code? Or did the tables get created with case-sensitive, lowercase names?
– Christopher Jones
2 days ago
add a comment |
It's been a while since I used ZFW, but have you tried using 'T2' instead of 't2' in the code? Or did the tables get created with case-sensitive, lowercase names?
– Christopher Jones
2 days ago
It's been a while since I used ZFW, but have you tried using 'T2' instead of 't2' in the code? Or did the tables get created with case-sensitive, lowercase names?
– Christopher Jones
2 days ago
It's been a while since I used ZFW, but have you tried using 'T2' instead of 't2' in the code? Or did the tables get created with case-sensitive, lowercase names?
– Christopher Jones
2 days ago
add a comment |
1 Answer
1
active
oldest
votes
Solved it. Used $db->quoteIdentifier(). and it worked
$db = Zend_Db_Table::getDefaultAdapter();
$db->setFetchMode(Zend_Db::FETCH_OBJ);
$select = $db->select()->from(array(
't1' => $this->_Table1
));
$select = $select->join(array(
't2' => $this->_Table2
), $db->quoteIdentifier('t1.MENU_ID') . ' = ' . $db->quoteIdentifier('t2.SUBMENU_ID'),
array(
'MENU_ID',
'SET_REDIRECT_URL',
'SUBMENU_TYPE'
));
$select = $select->order(array(
'MENU_ID',
't2.DISPLAY_ORDER'
));
$select = $select->where($db->quoteIdentifier('t1.IS_ACTIVE') . ' = ?', 'Y');
$result = $db->fetchAll($select);
answered yesterday
AvneeshAvneesh
63
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Avneesh is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55022756%2fzend-pdo-oci-and-pdo-mysql-generating-different-query-formats%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Solved it. Used $db->quoteIdentifier(). and it worked
$db = Zend_Db_Table::getDefaultAdapter();
$db->setFetchMode(Zend_Db::FETCH_OBJ);
$select = $db->select()->from(array(
't1' => $this->_Table1
));
$select = $select->join(array(
't2' => $this->_Table2
), $db->quoteIdentifier('t1.MENU_ID') . ' = ' . $db->quoteIdentifier('t2.SUBMENU_ID'),
array(
'MENU_ID',
'SET_REDIRECT_URL',
'SUBMENU_TYPE'
));
$select = $select->order(array(
'MENU_ID',
't2.DISPLAY_ORDER'
));
$select = $select->where($db->quoteIdentifier('t1.IS_ACTIVE') . ' = ?', 'Y');
$result = $db->fetchAll($select);
answered yesterday
AvneeshAvneesh
63
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Solved it. Used $db->quoteIdentifier(). and it worked
$db = Zend_Db_Table::getDefaultAdapter();
$db->setFetchMode(Zend_Db::FETCH_OBJ);
$select = $db->select()->from(array(
't1' => $this->_Table1
));
$select = $select->join(array(
't2' => $this->_Table2
), $db->quoteIdentifier('t1.MENU_ID') . ' = ' . $db->quoteIdentifier('t2.SUBMENU_ID'),
array(
'MENU_ID',
'SET_REDIRECT_URL',
'SUBMENU_TYPE'
));
$select = $select->order(array(
'MENU_ID',
't2.DISPLAY_ORDER'
));
$select = $select->where($db->quoteIdentifier('t1.IS_ACTIVE') . ' = ?', 'Y');
$result = $db->fetchAll($select);
answered yesterday
AvneeshAvneesh
63
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Solved it. Used $db->quoteIdentifier(). and it worked
$db = Zend_Db_Table::getDefaultAdapter();
$db->setFetchMode(Zend_Db::FETCH_OBJ);
$select = $db->select()->from(array(
't1' => $this->_Table1
));
$select = $select->join(array(
't2' => $this->_Table2
), $db->quoteIdentifier('t1.MENU_ID') . ' = ' . $db->quoteIdentifier('t2.SUBMENU_ID'),
array(
'MENU_ID',
'SET_REDIRECT_URL',
'SUBMENU_TYPE'
));
$select = $select->order(array(
'MENU_ID',
't2.DISPLAY_ORDER'
));
$select = $select->where($db->quoteIdentifier('t1.IS_ACTIVE') . ' = ?', 'Y');
$result = $db->fetchAll($select);
answered yesterday
AvneeshAvneesh
63
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Solved it. Used $db->quoteIdentifier(). and it worked
$db = Zend_Db_Table::getDefaultAdapter();
$db->setFetchMode(Zend_Db::FETCH_OBJ);
$select = $db->select()->from(array(
't1' => $this->_Table1
));
$select = $select->join(array(
't2' => $this->_Table2
), $db->quoteIdentifier('t1.MENU_ID') . ' = ' . $db->quoteIdentifier('t2.SUBMENU_ID'),
array(
'MENU_ID',
'SET_REDIRECT_URL',
'SUBMENU_TYPE'
));
$select = $select->order(array(
'MENU_ID',
't2.DISPLAY_ORDER'
));
$select = $select->where($db->quoteIdentifier('t1.IS_ACTIVE') . ' = ?', 'Y');
$result = $db->fetchAll($select);
answered yesterday
AvneeshAvneesh
63
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered yesterday
AvneeshAvneesh
63
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered yesterday
AvneeshAvneesh
63
answered yesterday
AvneeshAvneesh
63
63
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Avneesh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
Avneesh is a new contributor. Be nice, and check out our Code of Conduct.
Avneesh is a new contributor. Be nice, and check out our Code of Conduct.
Avneesh is a new contributor. Be nice, and check out our Code of Conduct.
Avneesh is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55022756%2fzend-pdo-oci-and-pdo-mysql-generating-different-query-formats%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
It's been a while since I used ZFW, but have you tried using 'T2' instead of 't2' in the code? Or did the tables get created with case-sensitive, lowercase names?
– Christopher Jones
2 days ago