Open GoogleCodeExporter opened 9 years ago
Hi,
This does not seams a ZFDatagrid error, because the error message printed is
define in Zend_Db_Adapter_Oracle
[QUOTE]
/**
* Oracle does not implement the LIMIT clause as some RDBMS do.
* We have to simulate it with subqueries and ROWNUM.
* Unfortunately because we use the column wildcard "*",
* this puts an extra column into the query result set.
*/
$limit_sql = "SELECT z2.*
FROM (
SELECT z1.*, ROWNUM AS \"zend_db_rownum\"
FROM (
" . $sql . "
) z1
) z2
WHERE z2.\"zend_db_rownum\" BETWEEN " . ($offset+1) . " AND " . ($offset+$count);
[/QUOTE]
Have you tried to use the PDO adapter instead?
Best Regards,
Bento Vilas Boas
Original comment by bento.vi...@gmail.com
on 26 Jan 2011 at 2:01
Sorry it took so long to get back to you. I just tried out the PDO adapter, and
get basically the same error:
"Error updating record: SQLSTATE[HY000]: General error: 920 OCIStmtExecute:
ORA-00920: invalid relational operator (ext\pdo_oci\oci_statement.c:146)"
Original comment by m...@ericlightbody.com
on 11 Feb 2011 at 8:25
I changed the source of the grid from a Table to a Select, and it fixed the
problem. I wish I could tell you why.
Original comment by m...@ericlightbody.com
on 16 Feb 2011 at 9:11
Original issue reported on code.google.com by
m...@ericlightbody.com
on 18 Jan 2011 at 5:54