PHP / MySQL / Stored Procedures

[Talk_Rowing]

I'm trying to call a stored procedure on my site which uses php / mySQL 5.x. I've got the procedure working in the database so that when I call it from within a MySQL client it executes and returns the results I need, but Dreamweaver doesn't even "see" the stored procedure.

By this I mean If I use the recordset wizard, go to advanced, select the relevant database and then expand the Stored Procedures tab none are listed.

Searching through Adobe help, it lists nothing about Stored Procedures with PHP/MySQL apart from that MySQL doesn't support them. The later versions of MySQL do support Stored Procedures, but has anyone got them working with Dreamweaver? If so how!??!!

Any help much appreciated.

[Newsgroup_User]

Talk Rowing wrote:
> Searching through Adobe help, it lists nothing about Stored Procedures with
> PHP/MySQL apart from that MySQL doesn't support them. The later versions of
> MySQL do support Stored Procedures, but has anyone got them working with
> Dreamweaver?

Dreamweaver doesn't support MySQL stored procedures, but I agree with
you that it should. Please submit an enhancement request to the
development team. The more people who request this feature, the more
likely it is to be implemented in a future version of Dreamweaver.

http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[Talk_Rowing]

Well thanks for setting me straight - even if you are the bearer of bad news. I've filed a feature request as you suggested. Can't believe Adobe don't offer this.

On another note I don't suppose you could point me in the direction of some tutorials on how to create a recordset from a stored procedure manually? I've tried google and not come across a lot...

[Newsgroup_User]

Talk Rowing wrote:
> Well thanks for setting me straight - even if you are the bearer of bad news.
> I've filed a feature request as you suggested. Can't believe Adobe don't offer
> this.

Stored procedures have been available in MySQL only since version 5.0,
which was released in October 2005, one month after Dreamweaver 8. It
would have been nice to include support for stored procedures in CS3,
but no new functionality was added to any of the server-side features of
Dreamweaver. I have my fingers crossed for next time.

> On another note I don't suppose you could point me in the direction of some
> tutorials on how to create a recordset from a stored procedure manually? I've
> tried google and not come across a lot...

My server doesn't support MySQL 5.0, so apart from the information in
the MySQL documentation, I don't know a great deal about using stored
procedures:

http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html

One of the problems is that many hosting companies are still using older
versions of MySQL (a lot still offer only 3.23). I'm currently in the
process of moving to a new server with support for both PHP 5 and MySQL
5.0. Once I've had time to experiment, I hope to know a lot more.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[johnDough407]

stored procedures are great. so are triggers.

maybe a View would help get part of the job done. but a view is basically a stored SELECT statement.

Dreamweaver doesn't support MySQL stored procedures.

is that true for MS SQL server stored procs too?

john dough

[Newsgroup_User]

johnDough407 wrote:
> is that true for MS SQL server stored procs too?

I was referring to the PHP server model in Dreamweaver, which uses
MySQL-specific functions and does not support MySQL stored procedures.
AFAIK, the ASP and ColdFusion server models do support stored
procedures. I have no idea whether they are restricted to particular
database systems.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[Newsgroup_User]

>
> is that true for MS SQL server stored procs too?
>

They are supported very well. I use them with asp and wish the hell
that they are natively supported MYSQL stored procedures for they do
make life a lot easier.


--

[Newsgroup_User]

Philo wrote:
> I use them with asp and wish the hell
> that they are natively supported MYSQL stored procedures for they do
> make life a lot easier.

If you haven't already done so, let the Dreamweaver development team
know by submitting a feature request:

http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/