I am using Dreamweaver CS3, PHP 5.2.5, MySQL 5.0.51 on Windows XP Pro and IE7.
When I create a procedure in MySQL, the database connection in Dreamweaver does not show the procedure. There is a a tree branch for Procedures, but under it shows 'none'. Dreamweaver help isn't very helpful. There was no help info on PHP and stored procedures, so I tried JSP. I got the same thing. After I made my db connection, it would show my tables and under procedures it would say none.
I tried granting all rights explicitly on the procedure object but that didn't do anything. On this site (expert-exchange) there was a similar question that was 2 years old and the answer provided a link to a training site:
http://www.accelebrate.com/dreamweaver_mx_training/php_dreamweaver.htmThe course outline has a session on PHP and stored procedures in Dreamweaver.
Maybe dreamweaver doesn't support MySQL stored procedures, but I haven't been able to access Adobe's site for the past week, anyone else having that problem?
Can I use MySQL stored procedures in Dreamweaver CS3?
Start Free Trial