Please take our Survey
logo       

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

maxdb_php and dbproc question: msg#00214

db.maxdb

Subject: maxdb_php and dbproc question

Hi,

I would like to use dbproc's as functions witch returns
a boolean result if the dbproc executed without problems
(or an id, serial type for example after an insert)

Yet, to return more variables, i return a cursor like
DECLARE :$cursor CURSOR FOR SELECT :iTete, :iNbElem,
:iProfondeur, :iLargeur FROM DBA.DUAL;
and i read this result "normaly". Is there a lighter
solution for the database instead of returning always
a cursor ?

should i use maxdb_stmt_init, maxdb_stmt_prepare and
maxdb_stmt_bind_param to do so ?

but in my case, i would have an "out" parameter.

I see that the function maxdb_stmt_bind_result binds on
result set only, not on parameters

Spefifing a bound parameter to a php variable to an out
parameter of an maxdb proc would do so ?

More generaly, like sql server, would you plan to allow
all dbproc to return an integer value witch could be
interpreted as a good execution flag (or an error code
if an error occured) ? like all C function ?



--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx




<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation

Home | advertise | OSDir is an inevitable website. super tiny logo