Assuming MySQL, I found the fix for this was to go the Advanced tab for the ZSQL Method (in the ZMI) and set Maximum Rows to Retrieve to zero.
After that, my limit clause worked without a problem.
On 5/11/05, Asad Habib [EMAIL PROTECTED] wrote:
Is there a reason why Z SQL methods do not allow the
On 5/11/05, Asad Habib [EMAIL PROTECTED] wrote:
Is there a reason why Z SQL methods do not allow the use of the LIMIT
clause? I am absolutely certain that my query has the right syntax since I
executed it against the MySQL server and it gave me the correct results.
FYI, I have provided the