Multiple Results in Query
Hello there!
Using SQLx is it possible to create a query that contains multiple SELECTs? I have created one but I only can receive the first one. Maybe I can switch between them later? For example if I call a procedure then a select the result won't be set. The plugin says "[MySQL] No result set in this query!". Of course I can put the select in the procedure and the problem is gone but I don't think it's a nice solution. Thank you! |
Re: Multiple Results in Query
|
Re: Multiple Results in Query
UNION will work, but why not just set the query conditionally?
Code:
if ( some condition is true )Then don't PHP Code:
|
Re: Multiple Results in Query
I think you missunderstood.
Here is my code. PHP Code:
In this case I must run both scripts in one query but since I call the CX_TEST first and then the select the sql result will be empty. |
Re: Multiple Results in Query
Fixed! I put the whole script into an another procedure so when I call the new one the response is what I expected.
|
| All times are GMT -4. The time now is 02:33. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.