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

[Fabio D'Ovidio]

The version is 4.4.1 as prerequisities suggest !

How can I do ?

On 9 Jun 2006 at 13:56, Pierre GIRAUD wrote:

> 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
> 


********************************************************************************************


 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

********************************************************************************************