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" <[EMAIL PROTECTED]>* > > Organization: *Planetek Italia S.r.l.* > > To: [EMAIL PROTECTED] > > Date sent: *Thu, 08 Jun 2006 15:01:23 +0200* > > Priority: *normal* > > Subject: *[Cartoweb-users] Query & Zoom in demoEdit* > > Send reply to: [EMAIL PROTECTED] > > *<mailto:[EMAIL PROTECTED]>* > > *<mailto:[EMAIL PROTECTED]>* > > 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 : [EMAIL PROTECTED] ******************************************************************************************** _______________________________________________ Cartoweb-users mailing list [email protected] http://lists.maptools.org/mailman/listinfo/cartoweb-users
