<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7653.15">
<TITLE>MyGIS without shp2mysql.pl</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Hi,<BR>
I would like to know if it is possible to use mygis layers without having to convert the data with shp2mysql.pl.<BR>
That script creates 3 different tables for each layer, and for my application I need to have only 1 table per layer, having a gid and the geometric field...<BR>
However, if I try to configure my layer in the map file in this way:<BR>
CONNECTION "host:user:password:dbname:bin:"<BR>
CONNECTIONTYPE mygis<BR>
DATA "the_geom from table53"<BR>
<BR>
where table53 is like this:<BR>
gid bigint(20)<BR>
the_geom blob (stored in WKB format)<BR>
<BR>
mapserver crashes without any error message.<BR>
<BR>
thanks for you help...<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>