Hi David,<br>I would prefer use the spatial extensions but I can't find nothing about. Your method works fine.<br>Thanks<br><br><div><span class="gmail_quote">2006/6/13, Fawcett, David <<a href="mailto:David.Fawcett@state.mn.us" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
David.Fawcett@state.mn.us
</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div><span><font color="#0000ff" face="Arial" size="2">John,
</font></span></div>
<div><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div><span><font color="#0000ff" face="Arial" size="2">Take a
look at this: <a href="http://mapserver.gis.umn.edu/docs/howto/ogrmysql" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://mapserver.gis.umn.edu/docs/howto/ogrmysql</a></font></span></div>
<div><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div><span><font color="#0000ff" face="Arial" size="2">You
would need to change your data structure so that you store your x and y values
in separate columns. </font></span></div>
<div><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div><span><font color="#0000ff" face="Arial" size="2">Note
that this method doesn't use MyGIS, it uses a direct connection driver in OGR,
so your MapServer binary would need to be compiled with OGR support (as most
are).</font></span></div><span>
<div><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div><span><font color="#0000ff" face="Arial" size="2">David.</font></span></div></span><div><span>
<blockquote style="margin-right: 0px;">
<div></div>
<div dir="ltr" align="left" lang="en-us"><font face="Tahoma" size="2">-----Original Message-----<br><b>From:</b> UMN MapServer
Users List [mailto:<a href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">MAPSERVER-USERS@LISTS.UMN.EDU</a>] <b>On Behalf Of </b>John
Prof<br><b>Sent:</b> Tuesday, June 13, 2006 4:03 AM<br><b>To:</b>
<a href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">MAPSERVER-USERS@LISTS.UMN.EDU</a><br><b>Subject:</b> [UMN_MAPSERVER-USERS] MyGis
connection question<br><br></font></div>Hello,<br><br>I'm trying to connect
mapserver's map with a mysql datatable like
this:<br><br>id
int<br>name
varchar(20)<br>description
varchar(100)<br>location
point <br><br>I'd like to create a shape with the points and the labels of the
name. Is it possible? I've tried many ways but I have errors.<br>I'd like to
do something like this example:<pre><br>LAYER<br></pre>CONNECTIONTYPE mygis <br>NAME "City"<br>CONNECTION
"host:user:passwd:database:bin"<br>DATA "location from city"<br>TYPE
POINT<br>STATUS ON<br>.<br>.<br>.<br>END<br><br>It fails. I've tried with some
mysql functions like AsBinary(point), but it doesn't work. <br>I must use
sh2mysql structure to store data in my database? Is not possible make my
simply case?<br><br>Thanks and sorry for my english
:p<br></blockquote></span></div></div>
</blockquote></div><br>