[UMN_MAPSERVER-USERS] Odd query results on Point layer

[Lawrence Hartpence]

Hello,

I have a point layer which is actually a database with X & Y fields.  When I
perform use query mode and select points, the results I get don't match the
point I am selecting.  Could someone help me understand what I am doing wrong?

Lawrence

http://gismap/JasperMaps/cgi-bin/mapserv.exe?&program=%2FJasperMaps%2Fcgi-bin%2Fmapserv.exe&map=C%3A%5CInetpub%5Cwwwroot%5Cmapdocs%5CSeptic.map&zoomsize=2&layers=ortho+Septic+Parcels+Lots+ROW+Survey+Section+Sub+ParcelPt+Water+Shields+Highways+Roads+Watershed+County+Towns&mode=browse&slayer=Parcels&imgxy=320+240&imgext=1680507.39+547052.00+1844030.00+680312.51&mapshape=&imgshape=&imgbox=&qstring=&qlayer=Parcels&qitem=&shapeindex=&savequery=

Here is the point layer in my MAP file:

LAYER
        CONNECTION "<OGRVRTDataSource>
        <OGRVRTLayer  name='Septic'>
        <SrcDataSource>ODBC:@Septic</SrcDataSource>
        <SrcLayer>tblSewersyAllHistoricInfo</SrcLayer>
        <GeometryField encoding='PointFromColumns' x='X' y='Y'/>
        <GeometryType>wkbPoint</GeometryType>
        </OGRVRTLayer>
        </OGRVRTDataSource>"
        CONNECTIONTYPE OGR
        DATA "Septic"
        #METADATA
        #        "wms_srs"   "4326"
        #        "wms_title"   "Septic"
        #END
        NAME "Septic"
          DUMP TRUE
          TEMPLATE 'C:\MS4W\Apache\htdocs\Septic\Septic_query.html'
          HEADER 'C:\MS4W\Apache\htdocs\Septic\Septic_head.html'
          TRANSPARENCY 100
        SIZEUNITS PIXELS
        STATUS ON
        TOLERANCE 7
        TOLERANCEUNITS PIXELS
        TYPE POINT
        UNITS FEET
          LABELITEM 'septicpermitnumber'
        CLASS
          STYLE
            COLOR 170 0 170
            MAXSIZE 100
            MINSIZE 1
            SIZE 6
            SYMBOL "square"
          END
   LABEL
    TYPE TRUETYPE
    SIZE 10
    FONT Arial  
    COLOR 170 0 150
    OUTLINECOLOR 255 255 255
    POSITION UC
    #ANGLE AUTO
    OFFSET 0 5
    MINDISTANCE 200
   END #LABEL

        END
END