Odd query results on Point layer

[Van Ulden, Joost]

Actually we are having the same problem here.  What version are you
using? 

-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
Behalf Of Lawrence Hartpence
Sent: September 13, 2007 07:36
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: [UMN_MAPSERVER-USERS] Odd query results on Point layer

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%2Fcg
i-bin%2Fmapserv.exe&map=C%3A%5CInetpub%5Cwwwroot%5Cmapdocs%5CSeptic.map&
zoomsize=2&layers=ortho+Septic+Parcels+Lots+ROW+Survey+Section+Sub+Parce
lPt+Water+Shields+Highways+Roads+Watershed+County+Towns&mode=browse&slay
er=Parcels&imgxy=320+240&imgext=1680507.39+547052.00+1844030.00+680312.5
1&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