re: Custom SQL statements
I use PremiumSoft's Navicat as my MySQL database manager which includes a very nice query builder to create custom SQL queries. Any chance that you could add another tab to your Datasource Query Builder that would display an open screen where one could paste the SQL statement generated by a third-party query builder and use that code block to generate custom data displays on a PHP webapge? This would be an AWSOME addition to your product for those of us who need to quickly build such functionality into our sites.

Hello Randy,
Thank you for sharing your idea with us.
We are currently discussing the best way to integrate such an option inside the extension. You will be notified as soon as there are news about this.

Hello, is there any progress on this yet? This will complete an awesome package of new extensions

I love to know if there is any solution yet as well. I have to used nested joins to pull two different values from a joined table2. I can create these in Navicat, but have no way to use these more complex (or custom) statements with in the Database Connector. To be able to use complex SQL states requires me to use a previous version of Dreamweaver and the older connection method. Unless, of course, I'm missing something with the current DMXzone Connector. If any users of suggestions, I'd love to hear them.

That would be fantastic!! if you tell me that will soon I buy

Any word on this? I'm used to being able to edit the SQL statements in my PHP page code.

I am alsop potentially migrating sites to the DMX zone extensions, so being able to paste in the SQL statements would be extremely useful.

In fact, not being able to do so might be a deal breaker if I can't use expressions such as COUNT, GROUP BY or HAVING, or include nested queries.

Or, if it is possible to use those expressions using the builder somehow, is there a tutorial?

It's now possible to write your own SQL queries using DMXzone Custom Database Query: www.dmxzone.com/go/33435/dmxzone-database-custom-query