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

[Pierre GIRAUD]

What is the version of mapserver you are using ?

You're probably facing a know mapserver bug :
http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1629

Pierre

Fabio D'Ovidio wrote:

> 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