|
|
This post has NOT been accepted by the mailing list yet.
I'm facing some problems when trying to use TableGateway together with expressions and predicates
<nabble_embed>SELECT * FROM MYTABLE
WHERE ID <> 5
AND MYDATE >= TO_DATE(20120709001000,'YYYYMMDDHH24MISS') </nabble_embed>
1) Can't find a predicate for '<>' (not equal to).
2) How to use expressions (TO_DATE()) together with predicate greaterThanOrEqualTo?
3) Generally speaking, which technique would be advised for big complicated queries with many joins and conditions? Use adapter's query ($adapter->query($sql)) or still use TableGateway?
Thanks for your help
|
Locked
