Hi,<br><br>I haven't really taken a look at it, but this project might be relevant: <a href="http://sourceforge.net/projects/erlmysql/">http://sourceforge.net/projects/erlmysql/</a><br><br>cheers,<br>Justin<br><br><div class="gmail_quote">
On 15 August 2012 00:36, kyletu <span dir="ltr"><<a href="mailto:kyletu@ptmind.com" target="_blank">kyletu@ptmind.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>





<div style="MARGIN:10px">
<div>Hello,I want call mysql PROCEDURE  in erlang. but I get a error 
message...  </div>
<div>Is there somebody know how to do it? </div>
<div style="FONT-WEIGHT:bold"> </div>
<div style="FONT-WEIGHT:bold"><pre style="border-right:0px;padding-right:0px;padding-left:0px;padding-top:0px;text-indent:0px;letter-spacing:normal;outline-width:0px;font-variant:normal;font-style:normal;font-weight:normal;padding-bottom:0px;vertical-align:baseline;line-height:25px;outline-style:none;outline-color:invert;text-transform:none;font-size:14px;border-bottom:0px;margin:0px;border-top:0px;word-spacing:0px;border-left:0px">
<span style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;FONT-WEIGHT:normal;BORDER-RIGHT:0px;PADDING-TOP:0px"></span><span style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;FONT-WEIGHT:normal;BORDER-RIGHT:0px;PADDING-TOP:0px"><div style="FONT-WEIGHT:bold">
PROCEDURE  code:</div><div>    <blockquote style="MARGIN-RIGHT:0px" dir="ltr"><pre style="border-right:0px;padding-right:0px;padding-left:0px;padding-top:0px;text-indent:0px;letter-spacing:normal;outline-width:0px;font-variant:normal;font-style:normal;font-weight:normal;padding-bottom:0px;vertical-align:baseline;line-height:25px;outline-style:none;outline-color:invert;text-transform:none;font-size:14px;border-bottom:0px;margin:0px;border-top:0px;word-spacing:0px;border-left:0px">
<span style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;BACKGROUND-COLOR:transparent;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;BORDER-RIGHT:0px;PADDING-TOP:0px"><b style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;FONT-WEIGHT:normal;BORDER-RIGHT:0px;PADDING-TOP:0px">CREATE PROCEDURE simpleproc_04()</b><u></u><u></u><u></u></span></pre>
<pre style="border-right:0px;padding-right:0px;padding-left:0px;padding-top:0px;text-indent:0px;letter-spacing:normal;outline-width:0px;font-variant:normal;font-style:normal;font-weight:normal;padding-bottom:0px;vertical-align:baseline;line-height:25px;outline-style:none;outline-color:invert;text-transform:none;font-size:14px;border-bottom:0px;margin:0px;border-top:0px;word-spacing:0px;border-left:0px">
<span style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;FONT-WEIGHT:normal;BORDER-RIGHT:0px;PADDING-TOP:0px">    <b style="FONT-WEIGHT:normal">BEGIN<u></u><u></u></b></span></pre>
<pre style="border-right:0px;padding-right:0px;padding-left:0px;padding-top:0px;text-indent:0px;letter-spacing:normal;outline-width:0px;font-variant:normal;font-style:normal;font-weight:normal;padding-bottom:0px;vertical-align:baseline;line-height:25px;outline-style:none;outline-color:invert;text-transform:none;font-size:14px;border-bottom:0px;margin:0px;border-top:0px;word-spacing:0px;border-left:0px">
<span style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;BACKGROUND-COLOR:transparent;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;BORDER-RIGHT:0px;PADDING-TOP:0px"><span style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;FONT-WEIGHT:normal;BORDER-RIGHT:0px;PADDING-TOP:0px">        select * from taokeeper_stat limit 10;</span></span></pre>
<pre style="border-right:0px;padding-right:0px;padding-left:0px;padding-top:0px;text-indent:0px;letter-spacing:normal;outline-width:0px;font-variant:normal;font-style:normal;font-weight:normal;padding-bottom:0px;vertical-align:baseline;line-height:25px;outline-style:none;outline-color:invert;text-transform:none;font-size:14px;border-bottom:0px;margin:0px;border-top:0px;word-spacing:0px;border-left:0px">
<span style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;FONT-WEIGHT:normal;BORDER-RIGHT:0px;PADDING-TOP:0px"><span style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;FONT-WEIGHT:normal;BORDER-RIGHT:0px;PADDING-TOP:0px">   </span> <b style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;FONT-WEIGHT:normal;BORDER-RIGHT:0px;PADDING-TOP:0px">END</b></span></pre>
</blockquote></div></span></pre><pre style="border-right:0px;padding-right:0px;padding-left:0px;padding-top:0px;text-indent:0px;letter-spacing:normal;outline-width:0px;font-variant:normal;font-style:normal;font-weight:normal;padding-bottom:0px;vertical-align:baseline;line-height:25px;outline-style:none;outline-color:invert;text-transform:none;font-size:14px;border-bottom:0px;margin:0px;border-top:0px;word-spacing:0px;border-left:0px">
<span>erlang call code:</span></pre><pre style="border-right:0px;padding-right:0px;padding-left:0px;padding-top:0px;text-indent:0px;letter-spacing:normal;outline-width:0px;font-variant:normal;font-style:normal;font-weight:normal;padding-bottom:0px;vertical-align:baseline;line-height:25px;outline-style:none;outline-color:invert;text-transform:none;font-size:14px;border-bottom:0px;margin:0px;border-top:0px;word-spacing:0px;border-left:0px">
<span>    <span style="FONT-WEIGHT:normal">mysql:fetch(poolId,<<"call simpleproc_04">>).  </span></span></pre><pre style="border-right:0px;padding-right:0px;padding-left:0px;padding-top:0px;text-indent:0px;letter-spacing:normal;outline-width:0px;font-variant:normal;font-style:normal;font-weight:normal;padding-bottom:0px;vertical-align:baseline;line-height:25px;outline-style:none;outline-color:invert;text-transform:none;font-size:14px;border-bottom:0px;margin:0px;border-top:0px;word-spacing:0px;border-left:0px">
<span><span style="FONT-WEIGHT:normal"></span></span> </pre><pre style="border-right:0px;padding-right:0px;padding-left:0px;padding-top:0px;text-indent:0px;letter-spacing:normal;outline-width:0px;font-variant:normal;font-style:normal;font-weight:normal;padding-bottom:0px;vertical-align:baseline;line-height:25px;outline-style:none;outline-color:invert;text-transform:none;font-size:14px;border-bottom:0px;margin:0px;border-top:0px;word-spacing:0px;border-left:0px">
<span><span style="FONT-WEIGHT:bold">then I get the error message:</span></span></pre><pre style="border-right:0px;padding-right:0px;padding-left:0px;padding-top:0px;text-indent:0px;letter-spacing:normal;outline-width:0px;font-variant:normal;font-style:normal;font-weight:normal;padding-bottom:0px;vertical-align:baseline;line-height:25px;outline-style:none;outline-color:invert;text-transform:none;font-size:14px;border-bottom:0px;margin:0px;border-top:0px;word-spacing:0px;border-left:0px">
<span><span style="FONT-WEIGHT:normal">    <div>mysql_conn:433: fetch <<"call simpleproc_04">> (id <0.44.0>)</div><div>{error,{mysql_result,[],[],0,0,</div><div>                     "PROCEDURE taokeeper.simpleproc_04 can't return a result set in the given context",</div>
<div>                     1312,"0A000"}}</div></span></span></pre><pre style="border-right:0px;padding-right:0px;padding-left:0px;padding-top:0px;text-indent:0px;letter-spacing:normal;outline-width:0px;font-variant:normal;font-style:normal;font-weight:normal;padding-bottom:0px;vertical-align:baseline;line-height:25px;outline-style:none;outline-color:invert;text-transform:none;font-size:14px;border-bottom:0px;margin:0px;border-top:0px;word-spacing:0px;border-left:0px">
<span style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;FONT-WEIGHT:normal;BORDER-RIGHT:0px;PADDING-TOP:0px"></span> </pre>
<pre style="border-right:0px;padding-right:0px;padding-left:0px;padding-top:0px;text-indent:0px;letter-spacing:normal;outline-width:0px;font-variant:normal;font-style:normal;font-weight:normal;padding-bottom:0px;vertical-align:baseline;line-height:25px;outline-style:none;outline-color:invert;text-transform:none;font-size:14px;border-bottom:0px;margin:0px;border-top:0px;word-spacing:0px;border-left:0px">
<span style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;FONT-WEIGHT:normal;BORDER-RIGHT:0px;PADDING-TOP:0px"></span> </pre>
<pre style="border-right:0px;padding-right:0px;padding-left:0px;padding-top:0px;text-indent:0px;letter-spacing:normal;outline-width:0px;font-variant:normal;font-style:normal;font-weight:normal;padding-bottom:0px;vertical-align:baseline;line-height:25px;outline-style:none;outline-color:invert;text-transform:none;font-size:14px;border-bottom:0px;margin:0px;border-top:0px;word-spacing:0px;border-left:0px">
<span style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;FONT-WEIGHT:normal;BORDER-RIGHT:0px;PADDING-TOP:0px">Thanks to read it...</span></pre>
</div>
<div style="FONT-WEIGHT:bold"><span style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;FONT-WEIGHT:normal;BORDER-RIGHT:0px;PADDING-TOP:0px"></span> </div>
<pre style="border-right:0px;padding-right:0px;padding-left:0px;padding-top:0px;text-indent:0px;letter-spacing:normal;outline-width:0px;font-variant:normal;font-style:normal;font-weight:normal;padding-bottom:0px;vertical-align:baseline;line-height:25px;outline-style:none;outline-color:invert;text-transform:none;font-size:14px;border-bottom:0px;margin:0px;border-top:0px;word-spacing:0px;border-left:0px">
<span style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;BACKGROUND-COLOR:transparent;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;BORDER-RIGHT:0px;PADDING-TOP:0px"><b></b></span> </pre>
<pre style="border-right:0px;padding-right:0px;padding-left:0px;padding-top:0px;text-indent:0px;letter-spacing:normal;outline-width:0px;font-variant:normal;font-style:normal;font-weight:normal;padding-bottom:0px;vertical-align:baseline;line-height:25px;outline-style:none;outline-color:invert;text-transform:none;font-size:14px;border-bottom:0px;margin:0px;border-top:0px;word-spacing:0px;border-left:0px">
<span style="BORDER-BOTTOM:0px;BORDER-LEFT:0px;PADDING-BOTTOM:0px;BACKGROUND-COLOR:transparent;MARGIN:0px;OUTLINE-STYLE:none;OUTLINE-COLOR:invert;PADDING-LEFT:0px;OUTLINE-WIDTH:0px;PADDING-RIGHT:0px;FONT-SIZE:14px;VERTICAL-ALIGN:baseline;BORDER-TOP:0px;BORDER-RIGHT:0px;PADDING-TOP:0px"><b></b><u></u><u></u></span> </pre>

<div> </div>
<hr style="WIDTH:210px;min-height:1px" color="#b5c4df" size="1" align="left"><span class="HOEnZb"><font color="#888888">

<div><span>kyletu</span></div></font></span></div>
<br>_______________________________________________<br>
erlang-questions mailing list<br>
<a href="mailto:erlang-questions@erlang.org">erlang-questions@erlang.org</a><br>
<a href="http://erlang.org/mailman/listinfo/erlang-questions" target="_blank">http://erlang.org/mailman/listinfo/erlang-questions</a><br>
<br></blockquote></div><br>