<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I am relatively new to gdal. I have a few spatial tables in
MYSQL and I am currently using ORG as read access to my data for a mapsever
layer. Everything works great with standard select statements however it does
not work when I try to use a stored procedure with the spatial data. When I
use orginfo I get the following error.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>MySQL error message:PROCEDURE spatial.sp_test can't return a
result setin the given context Description: CALL sp_test(24);<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Any suggestions would be greatly appreciated ?<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto'><font size=3 color="#1f497d"
face="Times New Roman"><span style='font-size:12.0pt;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto'><font size=3 color="#1f497d"
face="Times New Roman"><span style='font-size:12.0pt;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto'><font size=3 color="#1f497d"
face="Times New Roman"><span style='font-size:12.0pt;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto'><font size=3 color="#1f497d"
face="Times New Roman"><span style='font-size:12.0pt;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto'><font size=3 color="#1f497d"
face="Times New Roman"><span style='font-size:12.0pt;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto'><font size=3 color="#1f497d"
face="Times New Roman"><span style='font-size:12.0pt;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto'><font size=3 color="#1f497d"
face="Times New Roman"><span style='font-size:12.0pt;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto'><font size=3 color="#1f497d"
face="Times New Roman"><span style='font-size:12.0pt;color:#1F497D'><o:p> </o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
<!--[object_id=#awtwater.com#]--><P align=left> </P>
<P align=left>
<HR>
<P></P>
<P align=left>THIS EMAIL IS CONFIDENTIAL. Its use or disclosure by any person other than the addressee is unauthorised. Anyone other than the intended recipient must not rely on the content of this email or any attachment to it. The sender cannot guarantee that this email or any attachment to it is free of computer viruses or other conditions which may damage or interfere with other computer systems.</P>
<P align=left>
<HR>
<P></P></body>
</html>