LIMIT not working in latest build? Also can't use NOW() MySQL function?

<?php
$Tomorrow = new WA_MySQLi_RS("Tomorrow",$conn,2);
$Tomorrow->setQuery("SELECT calendar_events.event_date FROM calendar_events WHERE calendar_events.event_date > 'NOW()' ORDER BY calendar_events.event_date ASC");
$Tomorrow->execute();
?>

Note how the NOW() function gets wrapped in single quotes after viewing in the Query Editor.

Is there plans on allowing the Query Editor to be dynamically resized? It's too small on most occasions and frustrating to have to constantly scroll.

What is confusing is the debug will not render the LIMIT = x value

<?php echo $Tomorrow->debugSQL(); ?>

And if you put in the literal value it causes all sorts of other errors...

I'll fix the querybuilder to allow you to use functions in comparisons like Now()... I'll also update debugSQL to include the LIMIT statement.

I can't really make the command resizable... dreamweaver doesn't allow that. What I can do is add config settings so that you could set the the size with Small, Regular, Large, and X-Large settings.

Awesome Ray, thank you for being considerate of your Customers needs.