AW: [postgis-users] Postigs layer in Mapserver

[Düster Horst]

You have to use:

DATA "the_geom from (select locarg.the_geom, locarg.oid, count(*) as 
cantidad from locarg, lugar where locarg.codpostal = lugar.codigopostal 
group by 1,2) as prueba using SRID=<your SRID>"

Horst

-----Ursprüngliche Nachricht-----
Von: Oscar Testa [mailto:otesta at s6.coopenet.com.ar]
Gesendet am: Donnerstag, 14. November 2002 21:26
An: postgis-users at postgis.refractions.net
Betreff: [postgis-users] Postigs layer in Mapserver

Hello, iam using Postgis layers with mapserver and php_mapscript.

When a layer data property has de simple value DATA "the_geom from 
xxx", the result is correct. 
But when i try the next:

  DATA "the_geom from (select locarg.the_geom, locarg.oid, count(*) as 
cantidad from locarg, lugar where locarg.codpostal = lugar.codigopostal 
group by 1,2) as prueba"

the next error appear:

MapServer Error in msPOSTGISLayerWhichShapes(): prep_DB:Error executing 
POSTGIS DECLARE statement (0.6 failed - retried 0.5 and it failed too). 
DECLARE mycursor BINARY CURSOR FOR SELECT Provincia::text,asbinary
(force_collection(force_2d(the_geom)),'NDR'),OID::text from (select 
locarg.the_geom, locarg.oid, count(*) as cantidad from locarg, lugar 
where locarg.codpostal = lugar.codigopostal group by 1,2) as prueba 
WHERE the_geom && setSRID('BOX3D(-78.22636066 -55.575152,-48.54710934 -
20.90357)'::BOX3D, find_srid('','locarg,','the_geom') )

Any idea??

Oscar


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users