[Mapserver-users] Always returning first record in DBF on itemquery -- RESOLVED

[Steve Lehr]

For anyone who encounters this problem, the issue was that when I was using
LOCATION it automatically treated the characters as a string since the first
character of the string LOCATION is a non-digit.  In my case, the first
character was a digit, so it was treating it as a numeric comparison (i.e.
perl talk == versus eq).

RESOLUTION: add single quotes around QPID, to force it to a string.

I believe this is not an issue in the full feature 4.0 rather then the
4.0Beta that I've been using; but I have not fully verified, I thought when
I installed 4.0 release yesterday I was seeing the same issue.

All the best and thanks for the help as always.  Mapserv rocks!

Steven Lehr
Visiting Professor
Embry-Riddle Aeronautical University (LB159)
600 S. Clyde Morris Blvd.
Daytona Beach, FL 32114-3900
386-226-7740

-----Original Message-----
From: mapserver-users-admin at lists.gis.umn.edu
[mailto:mapserver-users-admin at lists.gis.umn.edu]On Behalf Of Steve Lehr
Sent: Thursday, August 21, 2003 1:24 PM
To: mapserver-users at lists.gis.umn.edu
Subject: [Mapserver-users] Always returning first record in DBF on
itemquery


Group:

I'm using mapserver 4.0Beta and just tried the 4.0 release, when I query a
layer, I'm always getting the first record in the .dbf file, no matter what
the parameter is that I pass.  I pretty sure I'm sending it the right data,
but I always get the first record?

I call it with:

<A
href="http://127.0.0.1/cgi-bin/mapserv?map=/maps/aerial_lookup.map&qitem=qpi
d&qstring=000098804447&qlayer=parcels&mode=itemquery">000098804447 </A><BR>

I'm querying the lookup map below.  Yet when it forwards to the aerial.map
it always passes the first record in the parcels.dbf, which is not the
correct QPID.

--- lookup.map -- snip--
MAP
  LAYER
    NAME "parcels"
    DATA parcels
    STATUS DEFAULT
    TYPE POLYGON
    CLASS
      TEMPLATE
"http://127.0.0.1/cgi-bin/mapserv?map=/maps/aerial.map&mapxy=[shpmidx]+[shpm
idy]&buffer=500&parcel_id=[QPID]"
    END
  END
END
---end snip --


Anyone seen symptoms of this behavior before.  (**Wild reason thoughts:
layer name can not be the same as the data file name?  Or qpid and QPID are
reserved syntax?)  The thing that is messing me up, is that I have the same
syntax working for another application, except the layer name is doqindex
and the qitem=location and instead of passing along QPID, I pass along
LOCATION.

Thanks for the thoughts..

Steven Lehr
Visiting Professor
Embry-Riddle Aeronautical University (LB159)
600 S. Clyde Morris Blvd.
Daytona Beach, FL 32114-3900
386-226-7740

_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users