[Mapserver-dev] Bug in mapmygis.c

[Alan Steremberg]

in mapmygis.c, if you use non-binary table layouts, then this doesn't
work:
...
    TYPE ANNOTATION
    CLASS
        NAME "Weather Station"
       TEXT ([f_ID],[f_NEIGHBORHOOD])
...

The problem is that the SELECT queries don't have columns_wanted in them.

in prep_DB from mapmygis.c

This is what it should read:

            sprintf(query_string_0_5_real,"SELECT feature.id,
feature.vertices, geometry.ETYPE, geometry.X1, geometry.Y1, geometry.X2,
geometry.Y2 %s %s from %s WHERE %s AND feature.GID = geometry.GID ORDER BY
feature.id, geometry.ESEQ, geometry.SEQ",
                            columns_wanted, attribselect ,
geom_table,box3d);


I think the filter version of the example needs to be fixed as well.


----------------------------
 Alan Steremberg
 415-543-5021 x 103
 http://www.wunderground.com