(Fwd) [Cartoweb-users] Query & Zoom in demoEdit

[Jacolin Yves]

Hi,
I didn't use this in my postgis layer : "using unique oid using SRID=-1"
Do you have different projection for your item in your layer ? hum, I am not 
sure ! So either your srid is eaqul to -1 for all item or not.
Is it possible to have different srid in a postgis layer ?

Furthermore, I think oid is always unique ! So have you try to remove this 
part to test ?

Y.
Le Vendredi 9 Juin 2006 11:34, Fabio D'Ovidio a écrit :
> I have found error about zoom like button near selected features, but i am
> not able to solve it.
>
>
> The error is regard to subselect in postgis table
>
>
> This is the layer in the mapfile :
>
> LAYER
>   NAME "POZZI"
>   TYPE POINT
>   CONNECTIONTYPE postgis
>   CONNECTION "user=postgres password=***** dbname=edit_db host=prova
> port=5432" DATA "the_geom from (select the_geom, oid, provincia, comune
> from pozzi)as foo using unique oid using SRID=-1"
>   TEMPLATE "ttt"
>   CLASS
>     NAME "Staz_strum_wgs84utm33"
>    STYLE
>     SYMBOL  "circlefd"
>     SIZE 8
>     COLOR 0 255 255
>     OUTLINECOLOR 0 0 0
>    END
>
>   END
> METADATA
>       "id_attribute_string" "gid"
>       "query_returned_attributes" "provincia comune"
>       "edit_table" "pozzi" # PostGIS table
>       "edit_geometry_column" "the_geom" # PostGIS geometry column
>       "edit_geometry_type" "point" # PostGIS geometry type
>       "edit_srid" "-1"
>       "edit_attributes" "gid,provincia|string,comune|string" # list of the
> editable END
> END
>
>
> I am confused about this string :
>
> the_geom from (select the_geom, oid, provincia, comune from pozzi)as foo
> using unique oid using SRID=-1"
>
> How can I make this string wright?
>
> and about METADATA obj because the error is (when i try to zoom on selected
> layer !!!) :
>
> class: SoapFaultWrapper message: Mapserver error: Error in msDrawMap():
> Failed to draw layer named 'POZZI'.
> Error in prepare_database(): Error executing POSTGIS DECLARE (the actual
> query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
> gid::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),oid::text
> from (select the_geom, oid, provincia, comune from pozzi)as foo WHERE (gid
> = 'gid in ('91')') and (the_geom && setSRID( 'BOX3D(441902 4392657.7,856680
> 4683002.3)'::BOX3D,-1) )'
>
> Postgresql reports the error as 'ERROR: syntax error at or near "91" at
> character 203 '
>
> More Help:
>
> Error with POSTGIS data variable. You specified '<check your .map file>'.
> Standard ways of specifiying are :
> (1) 'geometry_column from geometry_table'
> (2) 'geometry_column from (<sub query>) as foo using unique <column name>
> using SRID=<srid#>'
>
> Make sure you put in the 'using unique <column name>' and 'using SRID=#'
> clauses in.
>
> For more help, please see http://postgis.refractions.net/documentation/
>
> Mappostgis.c - version of Jan 23/2004.
>
>
>
> Which i s the correct order in which I have to write id_attribute_string"
> and "query_returned_attributes" in METADA obj ?
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ------- Forwarded message follows -------
> From:	"Fabio D'Ovidio" <dovidio at planetek.it>
> Organization:	Planetek Italia S.r.l.
> To:	cartoweb-users at lists.maptools.org
> Date sent:	Thu, 08 Jun 2006 15:01:23 +0200
> Priority:	normal
> Subject:	[Cartoweb-users] Query & Zoom in demoEdit
> Send reply to:	dovidio at planetek.it
> 	<mailto:cartoweb-users-request at lists.maptools.org?subject=unsubscribe>
> 	<mailto:cartoweb-users-request at lists.maptools.org?subject=subscribe>
> Keywords:
>
> Hi ML,
> I'd like to know :
>
> 1) In http://www.cartoweb.org/demos/demoEdit.php why doesn't query tool
> (identifier) work fine ? how can I do to solve this problem also in my own
> project edition?
>
>
> 2)How can I do to work with zoom-like button near attribute table of edited
> features ? My own doesn't work. Why ?
>
>
> Thank you
>
>
> ***************************************************************************
>*****************
>
>
> Eng. Fabio D'Ovidio
> WebGIS Staff
> Planetek Italia Srl
> via Massaua, 12 - 70123 Bari - Italy
> web : http ://www.planetek.it
> e-mail : dovidio at planetek.it
>
> ***************************************************************************
>***************** ------- End of forwarded message -------
> ***************************************************************************
>*****************
>
>
>  Ing. Fabio D'Ovidio
>  WebGIS Staff
>  Planetek Italia Srl
>  via Massaua, 12 - 70123 Bari - Italy
>  web : http ://www.planetek.it
>  e-mail : dovidio at planetek.it
>
> ***************************************************************************
>*****************

-- 
Yves Jacolin
http://yjacolin.gloobe.org
----
Stagaire Conservatoire Régional des Espaces Naturels de la région Centre
http://cahiersnaturalistes.free.fr/cpnrc/
----
- Qu'est-ce que cela peut faire que je lutte pour la mauvaise cause 
puisque je suis de bonne foi?
- Et qu'est-ce que ça peut faire que je sois de mauvaise foi
puisque c'est pour la bonne cause. (Jacques Prévert)