Here is some more information that may help to find the problem: Items used to generate the Query file via PHP MapScript-
layers on_air,in_construction,in_acquisition
mapname ipcs_cell_sites
maxfeatures -1
session 4b28e96a69286
spatialfilter POLYGON((-86.158228860555 44.564298461849,
-85.987273183566 44.564298461849, -85.987273183566
44.729555616272, -86.158228860555 44.729555616272,
-86.158228860555 44.564298461849))
variant INTERSECTS
CGI Call Parameters:
imgext -86.545728395062 43.584152580449 -84.807679012346
45.182588160291
imgx 305
imgxy 610 561
imgy 280.5
layers in_acquisition in_construction on_air
map /tmp/sess_4b28e96a69286/ipcs_cell_sites.map
map_imagetype PNG
map_size 610 561
mapext -86.545728395062 43.584152580449 -84.807679012346
45.182588160291
mode map
queryfile /tmp/sess_4b28e96a69286/ipcs_cell_sites_query.qy
session 4b28e96a69286
ts 1260972533510
I have also attached the generated Query file. Thanks.
- Tim
----
Timothy J Nolte - [email protected]
Network Planning Engineer
Sprint Nextel
4717 Broadmoor Ave, Suite G
Kentwood, MI 49512
Office: 616-656-5163
PCS: 616-706-2438
Support: 616-929-0289
Fax: 616-554-6484
-----Original Message-----
From: Lime, Steve D (DNR) [mailto:[email protected]]
Sent: Tuesday, December 15, 2009 10:20 AM
To: Nolte, Tim; [email protected]
Subject: RE: [mapserver-users] MapServer CGI + Oracle + Query,msQueryByShape no
results
The query file format has changed. It had to as part of RFC 52. It may depend
on how PHP/MapScript creates that file. May need to get
Paul Spencer in on this...
Steve
________________________________________
From: [email protected]
[[email protected]] On Behalf Of Nolte, Tim
[[email protected]]
Sent: Monday, December 14, 2009 11:30 PM
To: Lime, Steve D (DNR); [email protected]
Subject: RE: [mapserver-users] MapServer CGI + Oracle + Query, msQueryByShape
no results
Sorry, just got back into work today and as most Mondays seem to go I had a lot
to take care of first. I'll try to provide more details tomorrow. I can say
this, that this is partly being setup and called by the MapGuide Fusion
framework. There is a PHP script being called with the query parameters, this
uses PHP MapScript to generate a .qry file. This .qry file is being used in the
call to the mapserv CGI. The PHP MapScript process is returning list results
for the objects selected, however the map image is failing to generate. The
MODE that is being requested of the CGI is 'map'. I will send an example of the
full URL as well as the contents of the .qry file. I don't currently have a
similar data set in Shapefile format, only within the Oracle database. Also,
the 3 layers in question are Oracle VIEWS and not direct table-based layers.
The layers work just fine in all cases but this.
- Tim
----
Timothy J Nolte - [email protected]
Network Planning Engineer
iPCS Wireless, Inc.
4717 Broadmoor Ave, Suite G
Kentwood, MI 49512
Office: 616-656-5163
PCS: 616-706-2438
Fax: 616-554-6484
Web: www.ipcswirelessinc.com
-----Original Message-----
From: Lime, Steve D (DNR) [mailto:[email protected]]
Sent: Mon 12/14/2009 5:35 PM
To: Lime, Steve D (DNR); Nolte, Tim; [email protected]
Subject: RE: [mapserver-users] MapServer CGI + Oracle + Query,msQueryByShape no
results
Tim: Any more on this? I looked into the source over the weekend but didn't see
any logic errors that would cause what you're seeing. Not that they aren't
there, it's that nothing was obvious...
Steve
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Lime, Steve D
(DNR)
Sent: Friday, December 11, 2009 3:50 PM
To: Nolte, Tim; [email protected]
Subject: RE: [mapserver-users] MapServer CGI + Oracle + Query, msQueryByShape
no results
Does the behavior hold true with shapefiles or is this just Oracle, or can't
you test that.
The queryfile (foo.qf) caches the query parameters itself, not the results. The
pre-5.6 cached the results but it was really expensive to retrieve them with
certain types of data providers, primarily databases. Are you using query files?
A sample query or two would help. Also, how are you presenting the results
(template, querymap or ???)
Steve
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Nolte, Tim
Sent: Friday, December 11, 2009 1:12 PM
To: [email protected]
Subject: [mapserver-users] MapServer CGI + Oracle + Query, msQueryByShape no
results
I have a web client that makes calls to the MapServer (5.6.0rc1) CGI. I'm
requesting the results of a query. The issue I am having is that if one of the
layers specified has no results the whole process fails with:
msQueryByShape(): Search returned no results. No matching record(s)
found.
If I run the same query but only pass a single layer that does have results
then it works. Additionally if I run the same query again and have results in
both of say 2 layers searched, I only get the layer that is searched first to
be highlighted rather than all of the results of all layers. It seems like the
logic that is used for querying is flawed. Was the design of using a query file
only designed to be used with 1 layer at a time? I really need help as this is
breaking the web client and causing users to get unexpected results. Thanks.
- Tim
----
Timothy J Nolte - [email protected]
Network Planning Engineer
Sprint Nextel
4717 Broadmoor Ave, Suite G
Kentwood, MI 49512
Office: 616-656-5163
PCS: 616-706-2438
Fax: 616-554-6484
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
ipcs_cell_sites_query.qy
Description: ipcs_cell_sites_query.qy
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
