PDA

View Full Version : View Created in MySql Not shown in Dreamweaver


a1adiver
03-02-2017, 02:09 PM
MySQL 5.6, MAMP, Dreamweaver CS6 on Mac OS Sierra.

I have created a View in a MySQL database. The view correctly returns the data in MySQL workbench.

When I open up Dreamweaver (php) page and attempted to create a record set. In the advanced menu you can choose either tables, views, or stored procedures. I open the view. It has an arrow next to it, but there is no view listed. Any ideas.

Kent

edbr
03-03-2017, 12:52 AM
none im afraid as i dont use dw for connections.
i did a quick yahoogle and there are a few issues posted. It would seem some issues with mysqli and only working if using PDO. in any case i dont think the dw wizards are up to the task.
In the ppast they always relied apomnt thier own very verbose connection procedure so unless you can create views in house and use prepared statements i would not use dreamweaver for this