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

Fri, 09 Jun 2006 02:35:11 -0700

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


********************************************************************************************
graphic

Eng. Fabio D'Ovidio
WebGIS Staff
Planetek Italia Srl
via Massaua, 12 - 70123 Bari - Italy
web : http ://www.planetek.it
e-mail : [EMAIL PROTECTED]

********************************************************************************************
------- End of forwarded message -------
********************************************************************************************
graphic

Ing. Fabio D'Ovidio
WebGIS Staff
Planetek Italia Srl
via Massaua, 12 - 70123 Bari - Italy
web : http ://www.planetek.it
e-mail : [EMAIL PROTECTED]

********************************************************************************************
The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.

   ---- File information -----------
     File:  FILE25281.gif
     Date:  9 Jun 2006, 11:28
     Size:  1899 bytes.
     Type:  Unknown

The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.

   ---- File information -----------
     File:  planetek.gif
     Date:  28 Feb 2006, 16:15
     Size:  1899 bytes.
     Type:  Unknown

_______________________________________________
Cartoweb-users mailing list
[email protected]
http://lists.maptools.org/mailman/listinfo/cartoweb-users

Reply via email to