[postgis-users] itemnquery limitation

[David Blasby]

Tom,

I've been unable to reproduce your problem.

1. I've been directly accessing the mapserv CGI instead of through a 
http server, so this could be where you're having problems.  You didnt 
sent me "WCms_header.html" - is there anything 'funny' in it?

2. I changed one of the lines in your html file:
	<input type="hidden" name="qstring" value='"nodeid in 
(413.0,430.0,431.0,432.0,433.0,434.0,436.1,450.0,451.0,452.0,453.0,454.0,455.0,456.0,457.1,457.2,457.3,457.4,458.1,458.2,459.0,528.0)"'>

3. I noticed a minor problem in the mappostgis.c - it wasnt finishing 
off its transactions to the query-by-unique-column portion.  I dont 
think this would be the cause of the problem.  I've attached a new 
mappostgis.c that fixes this problem (and throws out some debugging).


Could you try installing the new mappostgis.c and running your query? 
It should give some output (probably in your httpd's error_log) like this:

msPOSTGISLayerGetShape called for record = 3532689
msPOSTGISLayerGetShape sql=DECLARE mycursor BINARY CURSOR FOR SELECT 
asbinary(force_collection(force_2d(the_geom)),'NDR') from nodescomb_2003 
WHERE OID = 3532689

Hopefully this will work.

dave

ps. I think mapserver does its queryN by doing this:
1. turn the query string into a FILTER clause
2. execute the normal LayerWhichShapes(<rect>)- remember the record numbers
3. execute the 'GetShapebyID()' for each of the record numbers.
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: mappostgis.c
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030811/53308fd0/attachment.c>