[mapserver-users] MapServer CGI + Oracle + Query, msQueryByShape no results

[Lime, Steve D (DNR)]

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: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Lime, Steve D (DNR)
Sent: Friday, December 11, 2009 3:50 PM
To: Nolte, Tim; mapserver-users at lists.osgeo.org
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: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Nolte, Tim
Sent: Friday, December 11, 2009 1:12 PM
To: mapserver-users at lists.osgeo.org
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 - tnolte at ilpcs.com
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
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users