Flourish PHP Unframework
This is an archived copy of the forum for reference purposes

bug in fDatabase translatedQuery()?

posted by thang 7 years ago

Hello,

I have a query like

SELECT a.* FROM tbl_tableA a
WHERE a.id IN (SELECT b.id FROM tbl_tableB b)

That works perfectly when I call $dbConnection->query();

However, I want to have limit in my statement, so I adjusted it to:

SELECT a.* FROM tbl_tableA a
WHERE a.id IN (SELECT b.id FROM tbl_tableB b)
LIMIT 20 OFFSET 0

In order for this to work, I need to use translatedQuery() instead of query(). But translatedQuery() does not seem to accept the statement "WHERE a.id IN (SELECT b.id FROM tbl_tableB b)"