PEAR Forum :: PHP Extension and Application Repository

PEAR Forum Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Stored Procedures Support?

 
Post new topic   Reply to topic    PEAR Forum Forum Index -> Structures
View previous topic :: View next topic  
Author Message
ddn



Joined: 17 Jan 2007
Posts: 8

PostPosted: Wed Jan 17, 2007 11:33 am    Post subject: Stored Procedures Support? Reply with quote

Hi,

I managed to make use successfully of mysql stored procedures through mysql & mysqli in both pear & non pear php environment.

In the pear environment I made use of MDB2.

The DataGrid Structures can base itself upon a MDB2 DSN object.

A stored procedure produces however following error statement while the select statement passes perfectly.

Error msg:
Quote:
Unable to determine the data source type. You may want to explicitly specify it.Cannot build the datagrid: no datasource driver loaded


Cause:
function "_detectSourceType" in DataGrid.php does not allow for "CALL"-syntax, only for "SELECT"-syntax through preg_match.

Is integration for Stored Procedures here foreseen?
If not. What would be the impact if the regex here was modified?

Many thanks.

With kind regards.
ddn
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    PEAR Forum Forum Index -> Structures All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



PEAR Forum topic RSS feed 
Powered by phpBB © 2001, 2005 phpBB Group

Provided by Ministry of Web developement

'Actiemonitor' online projectmanagement software