<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>RE: [mapserver-users] MapServer CGI + Oracle + Query,msQueryByShape no results</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>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.<BR>
<BR>
- Tim<BR>
<BR>
----<BR>
Timothy J Nolte - tnolte@ilpcs.com<BR>
Network Planning Engineer<BR>
<BR>
iPCS Wireless, Inc.<BR>
4717 Broadmoor Ave, Suite G<BR>
Kentwood, MI 49512<BR>
<BR>
Office: 616-656-5163<BR>
PCS: 616-706-2438<BR>
Fax: 616-554-6484<BR>
Web: www.ipcswirelessinc.com<BR>
<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: Lime, Steve D (DNR) [<A HREF="mailto:Steve.Lime@state.mn.us">mailto:Steve.Lime@state.mn.us</A>]<BR>
Sent: Mon 12/14/2009 5:35 PM<BR>
To: Lime, Steve D (DNR); Nolte, Tim; mapserver-users@lists.osgeo.org<BR>
Subject: RE: [mapserver-users] MapServer CGI + Oracle + Query,msQueryByShape no results<BR>
<BR>
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...<BR>
<BR>
Steve<BR>
<BR>
-----Original Message-----<BR>
From: mapserver-users-bounces@lists.osgeo.org [<A HREF="mailto:mapserver-users-bounces@lists.osgeo.org">mailto:mapserver-users-bounces@lists.osgeo.org</A>] On Behalf Of Lime, Steve D (DNR)<BR>
Sent: Friday, December 11, 2009 3:50 PM<BR>
To: Nolte, Tim; mapserver-users@lists.osgeo.org<BR>
Subject: RE: [mapserver-users] MapServer CGI + Oracle + Query, msQueryByShape no results<BR>
<BR>
Does the behavior hold true with shapefiles or is this just Oracle, or can't you test that.<BR>
<BR>
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?<BR>
<BR>
A sample query or two would help. Also, how are you presenting the results (template, querymap or ???)<BR>
<BR>
Steve<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: mapserver-users-bounces@lists.osgeo.org [<A HREF="mailto:mapserver-users-bounces@lists.osgeo.org">mailto:mapserver-users-bounces@lists.osgeo.org</A>] On Behalf Of Nolte, Tim<BR>
Sent: Friday, December 11, 2009 1:12 PM<BR>
To: mapserver-users@lists.osgeo.org<BR>
Subject: [mapserver-users] MapServer CGI + Oracle + Query, msQueryByShape no results<BR>
<BR>
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:<BR>
<BR>
msQueryByShape(): Search returned no results. No matching record(s) found.<BR>
<BR>
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.<BR>
<BR>
- Tim<BR>
<BR>
----<BR>
Timothy J Nolte - tnolte@ilpcs.com<BR>
Network Planning Engineer<BR>
<BR>
Sprint Nextel<BR>
4717 Broadmoor Ave, Suite G<BR>
Kentwood, MI 49512<BR>
<BR>
Office: 616-656-5163<BR>
PCS: 616-706-2438<BR>
Fax: 616-554-6484<BR>
<BR>
_______________________________________________<BR>
mapserver-users mailing list<BR>
mapserver-users@lists.osgeo.org<BR>
<A HREF="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</A><BR>
_______________________________________________<BR>
mapserver-users mailing list<BR>
mapserver-users@lists.osgeo.org<BR>
<A HREF="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</A><BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>