asawyer13
|
| Posted: 01/16/2009, 7:29 PM |
|
I am trying to get Stored Procedures in mysql to be used for in some search
results.
I have created a simple Stored Procedure that doesn't have any input
parameters, but just outputs one column of data.
When I do a "live" preview on my page I get this error:
Database Error: PROCEDURE asbo.sp_get1 can't return a result set in the given
context
I googled it, and have tried changing the @mysql_connect in common.php to have
false, 65536 at the end, but that doesn't seem to help. I also tried changing a
setting in the odbc setup that talks about allowing multiple statements, but
that didn't help either.
I'm really need to get SP's to work with mysql.
Does anyone have any ideas?
Alan
---------------------------------------
Sent from YesSoftware forum
http://forums.yessoftware.com/
|
|
|
 |
sosamv
Posts: 50
|
| Posted: 02/02/2009, 4:32 PM |
|
Hi!! i have the same problem! help please =(
|
 |
|
sosamv
Posts: 50
|
| Posted: 02/03/2009, 7:10 AM |
|
Hi! i've contacted support and this is the answer to our problems hehe
Quote : Hello Jerry, Yes, to work with MySQL5 features you need to use MySQLi PHP library. Please open database Connection->Server dialog and set PHP Library to Improved MySQL. Make sure that php_mysqli.dll exists in PHP extensions folder and the corresponding line is uncommented in php.ini. Best regards, Kate.
hope That helps
|
|
|
|
|
