[Cartoweb-users] Problem with edit plugin.

Gilles BÉRÉTA gbereta at agglo-clermont.fr
Thu Mar 8 09:55:33 EST 2007


Hi,

I have a problem with the edit plugin :

I have a table with several field but no "oid" field.
Instead of "oid" field, I have a "gid" one.
When I want to edit this layer Cartoweb doesn't find the "oid" field and 
doesn't want to edit it.
Here is a piece of my .map.

"LAYER
  NAME "eco_locaux_zfu"
  TYPE POINT
  CONNECTIONTYPE POSTGIS
  CONNECTION "dbname=XXX user=XXX password=XXX host=XXX"
  DATA "the_geom from (select the_geom, gid, identifiant_local_zfu, 
numobj, anglobj, idelocal, numero_de_zone, reference_cadastrale, 
sous_partie, datrecen, enseigne, activite, dirigeant, siret, codeape, 
numvoie, adresse, batiment, appart, etage, tel, fax, courriel, 
nom_du_proprietaire, adresse_du_proprietaire, telephone_du_proprietaire, 
fax_du_proprietaire, courriel_du_proprietaire, type_de_terrain, 
surface_du_terrain, type_de_local, surface_du_local, occupe, disponible, 
transaction, fichier, wfiche from eco_locaux_zfu ) as foo"
  TEMPLATE "ttt"
  METADATA
    "id_attribute_string" "identifiant_local_zfu" # query
    "query_returned_attributes" "enseigne activite nom_du_proprietaire 
adresse_du_proprietaire telephone_du_proprietaire"
    "edit_table" "eco_locaux_zfu" # PostGIS table
    "edit_geometry_column" "the_geom" # PostGIS geometry column
    "edit_geometry_type" "point" # PostGIS geometry type
    "edit_srid" "-1"
    "edit_attributes" "numero_de_zone|character 
varying,reference_cadastrale|character varying,sous_partie|character 
varying,datrecen|character varying,enseigne|character 
varying,activite|character varying,dirigeant|character 
varying,siret|character varying,codeape|character 
varying,numvoie|character varying,adresse|character 
varying,batiment|character varying,appart|character 
varying,etage|character varying,tel|character varying,fax|character 
varying,courriel|character varying,nom_du_proprietaire|character 
varying,adresse_du_proprietaire|character 
varying,telephone_du_proprietaire|character 
varying,fax_du_proprietaire|character 
varying,courriel_du_proprietaire|character 
varying,type_de_terrain|character 
varying,surface_du_terrain|bigint,type_de_local|character 
varying,surface_du_local|bigint,occupe|character 
varying,disponible|character varying,transaction|character 
varying,fichier|character varying,wfiche|character varying" # list of 
the editable fields
    "edit_filter" "" # mapserver filter
  END"

What can I do to edit my layer ?

Thanks.

Gilles BERETA




More information about the Cartoweb-users mailing list