Why is my chained setLimit not working?

[Rene Kreijveld]

I have a database query with a LIMIT and I found out dat chaining the limit clause does not work.

This works:

$query = $db->getQuery(true)
    ->select($db->quoteName('legingsdag'))
    ->from($db->quoteName('#__containerwissel_wisseldag'))
    ->where($db->quoteName('route') . ' = ' . $route)
    ->where($db->quoteName('legingsdag') . ' > "' . $vandaag . '"')
    ->order($db->quoteName('legingsdag') . ' ASC');
$query->setLimit(1);

But this does not:

$query = $db->getQuery(true)
    ->select($db->quoteName('legingsdag'))
    ->from($db->quoteName('#__containerwissel_wisseldag'))
    ->where($db->quoteName('route') . ' = ' . $route)
    ->where($db->quoteName('legingsdag') . ' > "' . $vandaag . '"')
    ->order($db->quoteName('legingsdag') . ' ASC')
    ->setLimit(1);

Can someone explain why the second one doesn't work? (returns empty result) ...

[Todor Iliev]

Could you post the result of the query builder, please?

Let we see what are the results of both queries.

You can build the queries, displaying the $query object as a string.

echo (string)$query;

[Rene Kreijveld]

The first one with $query->setLimit(1); gives me:

SELECT `legingsdag` FROM `#__containerwissel_wisseldag` WHERE `route` = 6 AND `legingsdag` > "2017-07-26" ORDER BY `legingsdag` ASC

The second one with ->setLimit(1); gives me an empty string.

Strangely the result of the first one does not include the limt ...

[Rene Kreijveld]

Arch ... forget I posted this ... This was on Joomla 2.5 website, that doesn't even have setLimit.