MyGis connection question

[John Prof]

Hello,

I'm trying to connect mapserver's map with a mysql datatable like this:

id                            int
name                      varchar(20)
description              varchar(100)
location                  point

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.
I'd like to do something like this example:


LAYER

CONNECTIONTYPE mygis
NAME "City"
CONNECTION "host:user:passwd:database:bin"
DATA "location from city"
TYPE POINT
STATUS ON
.
.
.
END

It fails. I've tried with some mysql functions like AsBinary(point), but it
doesn't work.
I must use sh2mysql structure to store data in my database? Is not possible
make my simply case?

Thanks and sorry for my english :p
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060613/8df3f6a5/attachment.htm>