[SQL] Calling stored procedures which return a result set
Executing queries like the one below will always fail:
call MyStoredProc('Some input','Some more input') The query above works only if the stored procedure does not return anything. If it returns something, it will always fail. I tried using both DBI and SQLX - both have the same problem. SQLX returns an error: PROCEDURE MyStoredProc can't return a result set in the given context I know that other APIs (like for example PHP and its mysql_query()) also had this problem. However in PHP it was possible to set client options, so that it would accept result sets from a stored procedure. Is there a way to get around this problem in AMX MOD X? |
Re: [SQL] Calling stored procedures which return a result set
I'm having the same problem
Quote:
ahh: http://bugs.alliedmods.net/index.php...ls&task_id=281 |
| All times are GMT -4. The time now is 06:33. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.