Hi!<br><br>Multistatement is okay, that's just to make sure the API knows what to do. But beware that retrieving TEXT/BLOB fields as parameters sometimes may be far from easy, due to the fact that you have no idea of the actual lenght. PHP basically cannot do it, so I wonder if openDBX can. Let me know.<br>
<br>Berto<br><br><div class="gmail_quote">2009/4/21 Mariano Martinez Peck <span dir="ltr"><<a href="mailto:marianopeck@gmail.com">marianopeck@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><br><div class="gmail_quote"><div class="im">On Mon, Apr 20, 2009 at 7:25 PM, Bèrto ëd Sèra <span dir="ltr"><<a href="mailto:berto.d.sera@gmail.com" target="_blank">berto.d.sera@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi!<br><br>Compliments! FMI, is there any support for stored procedures, stored functions and IN OUT parameter passing with MySQL 5.1?<br></blockquote></div><div><br>Thanks! More or less. At least, it is not tested. However, as you can see in: <a href="http://wiki.squeak.org/squeak/6106" target="_blank">http://wiki.squeak.org/squeak/6106</a> we plan to do it in a future. <br>
<br>When I asked Norbert (openDBX author) about openDBX store procedure support, he told me "You have to enable the multi-statement option and retrieve all result sets using odbx_result.
". This, in SqueakDBX means: DBXConnection #enableMultiStatements and then do #execute: aSQLString. <br><br>I guess in this case aSQLString can be the call string to SP, but I really don't know.<br><br>So, perhaps we do support SP but we don't know it. Is just a matter of testing. If you want I can google and see how to create a simple SP and see If I can call it and retrieve the results.<br>
<br>Cheers,<br><br>Mariano<br><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>Thanks<br>Berto <br>
<br><br>
<br></blockquote></div><br>
<br><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>==============================<br>Constitution du 24 juin 1793 - Article 35. - Quand le gouvernement viole les droits du peuple, l'insurrection est, pour le peuple et pour chaque portion du peuple, le plus sacré des droits et le plus indispensable des devoirs.<br>