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

[Nolte, Tim]

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 - tnolte at ilpcs.com
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:Steve.Lime at state.mn.us]
Sent: Mon 12/14/2009 5:35 PM
To: Lime, Steve D (DNR); Nolte, Tim; mapserver-users at lists.osgeo.org
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: 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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20091215/3a953717/attachment.htm>