Re: [PHP-DB] Procedure Parameter OUT values
WebPat wrote: Chris wrote: WebPat wrote: I am surprised by the order of the data returned from my stored procedure, and that it appears associated with the incorrect variables. Apparently the data is returned entirely positionally, without consideration for the variable names. So, the names of the OUT parameters in the procedure appear to be invisible outside of the procedure. Although I pass in variables with the same names as the Parameters, they are filled positionally - in the "wrong" variables - because in this case I had two variables reversed positionally. When I retrieve them using fetch_assoc, the wrong data appears in the result. I'd probably find a more targeted mailing list (a specialized one for your database - whatever it is) and see if they can offer any suggestions. My database is Mysql. The data seems to display properly there. I'm accessing the database with procedures that are part of PHP and that is where I believe the problem is. That's why I asked it on this "Newsgroup". I got it to work by putting my parameters in the proper order. I know this is how function and procedure calls normally work, but the documentation of fetch_assoc() leads in another direction. It looks like the "Associations" are created within my php and not carried from the database for stored procedures. I wonder if PHP does this for all databases? I think this differs from "Select * From Table". Certainly could use another sentence in the documentation. You can submit documentation patches and/or submit a note for that situation on that page in the manual. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Procedure Parameter OUT values
Chris wrote: WebPat wrote: I am surprised by the order of the data returned from my stored procedure, and that it appears associated with the incorrect variables. Apparently the data is returned entirely positionally, without consideration for the variable names. So, the names of the OUT parameters in the procedure appear to be invisible outside of the procedure. Although I pass in variables with the same names as the Parameters, they are filled positionally - in the "wrong" variables - because in this case I had two variables reversed positionally. When I retrieve them using fetch_assoc, the wrong data appears in the result. I'd probably find a more targeted mailing list (a specialized one for your database - whatever it is) and see if they can offer any suggestions. My database is Mysql. The data seems to display properly there. I'm accessing the database with procedures that are part of PHP and that is where I believe the problem is. That's why I asked it on this "Newsgroup". I got it to work by putting my parameters in the proper order. I know this is how function and procedure calls normally work, but the documentation of fetch_assoc() leads in another direction. It looks like the "Associations" are created within my php and not carried from the database for stored procedures. I wonder if PHP does this for all databases? I think this differs from "Select * From Table". Certainly could use another sentence in the documentation. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Procedure Parameter OUT values
WebPat wrote: I am surprised by the order of the data returned from my stored procedure, and that it appears associated with the incorrect variables. Apparently the data is returned entirely positionally, without consideration for the variable names. So, the names of the OUT parameters in the procedure appear to be invisible outside of the procedure. Although I pass in variables with the same names as the Parameters, they are filled positionally - in the "wrong" variables - because in this case I had two variables reversed positionally. When I retrieve them using fetch_assoc, the wrong data appears in the result. I'd probably find a more targeted mailing list (a specialized one for your database - whatever it is) and see if they can offer any suggestions. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
