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.
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.