cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Exit
search
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
0
Upvote

PHP / MySQL / Stored Procedures

Talk_Rowing
New Here ,
Jul 10, 2007 Jul 10, 2007

Copy link to clipboard

Copied

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.
TOPICS
Server side applications

Views

680
Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
replies 7 Replies 7
latest latest Jump to latest reply
Newsgroup_User
LEGEND ,
Jul 10, 2007 Jul 10, 2007

Copy link to clipboard

Copied

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/

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Talk_Rowing
New Here ,
Jul 10, 2007 Jul 10, 2007

Copy link to clipboard

Copied

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

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Newsgroup_User
LEGEND ,
Jul 10, 2007 Jul 10, 2007

Copy link to clipboard

Copied

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/

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
johnDough407
New Here ,
Jul 11, 2007 Jul 11, 2007

Copy link to clipboard

Copied

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

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Newsgroup_User
LEGEND ,
Jul 12, 2007 Jul 12, 2007

Copy link to clipboard

Copied

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/

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Newsgroup_User
LEGEND ,
Jul 12, 2007 Jul 12, 2007

Copy link to clipboard

Copied


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


--

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Newsgroup_User
LEGEND ,
Jul 12, 2007 Jul 12, 2007

Copy link to clipboard

Copied

LATEST
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/

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Copyright © 2025 Adobe. All rights reserved.
Using the Community Experience League Terms of Use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices