<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=994485512-13062006><FONT face=Arial color=#0000ff size=2>John,
</FONT></SPAN></DIV>
<DIV><SPAN class=994485512-13062006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=994485512-13062006><FONT face=Arial color=#0000ff size=2>Take a
look at this: <A
href="http://mapserver.gis.umn.edu/docs/howto/ogrmysql">http://mapserver.gis.umn.edu/docs/howto/ogrmysql</A></FONT></SPAN></DIV>
<DIV><SPAN class=994485512-13062006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=994485512-13062006><FONT face=Arial color=#0000ff 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 class=994485512-13062006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=994485512-13062006><FONT face=Arial color=#0000ff 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>
<DIV><SPAN class=994485512-13062006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=994485512-13062006><FONT face=Arial color=#0000ff
size=2>David.</FONT></SPAN></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> UMN MapServer
Users List [mailto:MAPSERVER-USERS@LISTS.UMN.EDU] <B>On Behalf Of </B>John
Prof<BR><B>Sent:</B> Tuesday, June 13, 2006 4:03 AM<BR><B>To:</B>
MAPSERVER-USERS@LISTS.UMN.EDU<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></BODY></HTML>