<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7036.0">
<TITLE>A little problem - FR with Mysql Stored Procedure</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#000000" SIZE=2 FACE="Courier New">Dear Sir,<BR>
<BR>
I was wondering on mailing list for last 3 days and</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#000000" SIZE=2 FACE="Courier New">I</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT COLOR="#000000" SIZE=2 FACE="Courier New"> didn</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT COLOR="#000000" SIZE=2 FACE="Courier New">’</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT COLOR="#000000" SIZE=2 FACE="Courier New">t get proper response,</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#000000" SIZE=2 FACE="Courier New">I</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT COLOR="#000000" SIZE=2 FACE="Courier New"> am really in problem</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT COLOR="#000000" SIZE=2 FACE="Courier New">.</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><BR>
<BR>
<FONT COLOR="#000000" SIZE=2 FACE="Courier New">I am getting problem to use Mysql Stored procedures</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#000000" SIZE=2 FACE="Courier New">with Freeradius. After exploring web</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#000000" SIZE=2 FACE="Courier New">I</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT COLOR="#000000" SIZE=2 FACE="Courier New">t came to know that</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT COLOR="#000000" SIZE=2 FACE="Courier New">,</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#000000" SIZE=2 FACE="Courier New">(</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT COLOR="#000000" SIZE=2 FACE="Courier New">this text</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#000000" SIZE=2 FACE="Courier New">I</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT COLOR="#000000" SIZE=2 FACE="Courier New"> got from mysql.com forum:</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT COLOR="#000000" SIZE=2 FACE="Courier New">)</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><BR>
<BR>
</SPAN><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I><FONT COLOR="#993300" SIZE=2 FACE="Courier New">the result's of SP execution are sent as result sets over the protocol. Once you call a SP you get at least 1 return code and could get many result sets</FONT></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I><FONT COLOR="#993300" SIZE=2 FACE="Courier New">.</FONT></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I> <FONT COLOR="#993300" SIZE=2 FACE="Courier New">The execution of a stored procedure is very similar to execution of a multi-query.</FONT></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I><BR>
</I></SPAN><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN></P>
<P ALIGN=LEFT><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New">MySQL 5.0 supports the execution of multiple statements specified in a single query string. To use this capability with a given connection, you must specify the</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"> <FONT COLOR="#993300" SIZE=2 FACE="Courier New">CLIENT_MULTI_STATEMENTS</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New"> option in the</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"> <FONT COLOR="#993300" SIZE=2 FACE="Courier New">flags</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New"> parameter to</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"> <FONT COLOR="#993300" SIZE=2 FACE="Courier New">mysql_real_connect()</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New"> when opening the connection. You can also set this for an existing connection by calling</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"> <FONT COLOR="#993300" SIZE=2 FACE="Courier New">mysql_set_server_option(MYSQL_OPTION_MULTI_STATEMENTS_ON)</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New">. </FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New">By default,</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"> <FONT COLOR="#993300" SIZE=2 FACE="Courier New">mysql_query()</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New"> and</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"> <FONT COLOR="#993300" SIZE=2 FACE="Courier New">mysql_real_query()</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New"> return only the first query status and the subsequent queries status can be processed using</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"> <FONT COLOR="#993300" SIZE=2 FACE="Courier New">mysql_more_results()</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New"> and</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"> <FONT COLOR="#993300" SIZE=2 FACE="Courier New">mysql_next_result()</FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New">. </FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New">/* Connect to server with option CLIENT_MULTI_STATEMENTS */</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New">mysql_real_connect(..., CLIENT_MULTI_STATEMENTS);</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New">/* Now execute multiple queries */</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New">mysql_query(mysql,"DROP TABLE IF EXISTS test_table;\</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New"> CREATE TABLE test_table(id INT);\</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New"> INSERT INTO test_table VALUES(10);\</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New"> UPDATE test_table SET id=20 WHERE id=10;\</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New"> SELECT * FROM test_table;\</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en"><FONT COLOR="#993300" SIZE=2 FACE="Courier New"> DROP TABLE test_table");</FONT></SPAN></I></P>
<BR>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Means</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> <FONT SIZE=2 FACE="Courier New">I</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New"> need to use</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"> <FONT SIZE=2 FACE="Courier New">CLIENT_MULTI_STATEMENTS</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"><FONT SIZE=2 FACE="Courier New"> in mysql_real_connect(), so</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"><FONT SIZE=2 FACE="Courier New">,</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"> <FONT SIZE=2 FACE="Courier New">for now</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"><FONT SIZE=2 FACE="Courier New">,</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"><FONT SIZE=2 FACE="Courier New"></FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"> <FONT SIZE=2 FACE="Courier New">I</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"><FONT SIZE=2 FACE="Courier New"> just need this little guidance that which file should</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"> <FONT SIZE=2 FACE="Courier New">I</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"><FONT SIZE=2 FACE="Courier New"> edit to</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"> <FONT SIZE=2 FACE="Courier New">get SP working with Freeradius.<BR>
<BR>
I hope</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"> <FONT SIZE=2 FACE="Courier New">I’</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"><FONT SIZE=2 FACE="Courier New">ll get response this time<BR>
<BR>
</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"><FONT SIZE=2 FACE="Courier New">thanking you in advance<BR>
Best Regards</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN></P>
</BODY>
</HTML>