<html>
<head>
<style>
P
{
margin:0px;
padding:0px
}
body
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body><BR>Hi Oliver,<BR>
I do have the edit plugin in my project, but i have modified it and nothing changes. I have also renamed the edit plugin in the plugins folder so it is not in use,It is apparent the changes need to be made else where.<BR>Broun Uganda<BR><BR><BR><BR>
<BLOCKQUOTE>
<HR id=EC_stopSpelling>
From: oliver.christen@camptocamp.com<BR>To: tekuganda@hotmail.com; cartoweb-users@lists.maptools.org<BR>Subject: Re: [Cartoweb-users] Edit plugin MULTILINESTRING ERROR<BR>Date: Mon, 2 Jul 2007 16:23:27 +0200<BR><BR>
<META content="Microsoft SafeHTML" name=Generator>
<STYLE>
.ExternalClass P
{padding-right:0px;padding-left:0px;padding-bottom:0px;padding-top:0px;}
.ExternalClass
{font-size:10pt;font-family:Tahoma;}
</STYLE>
<DIV><FONT face=Arial>maybe try 'edit_geometry_type' 'multilinestring' </FONT></DIV>
<BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> <A title=tekuganda@hotmail.com href="mailto:tekuganda@hotmail.com">Broun Uganda</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=oliver.christen@camptocamp.com href="mailto:oliver.christen@camptocamp.com">Oliver Christen</A> ; <A title=cartoweb-users@lists.maptools.org href="mailto:cartoweb-users@lists.maptools.org">cartoweb-users@lists.maptools.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, July 02, 2007 3:34 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [Cartoweb-users] Edit plugin MULTILINESTRING ERROR</DIV>
<DIV><BR></DIV>Hey,<BR>The layer with its metadata is as below but still giving me the same error:<BR><FONT size=2><EM>LAYER # Links lines layer begins here</EM><BR><EM>NAME "Links"</EM><BR><EM>CONNECTIONTYPE POSTGIS</EM><BR><EM>CONNECTION 'dbname=MU_maarten user=postgres password={Guma}no host=localhost'</EM><BR><EM>DATA 'the_geom from (select the_geom, oid, gid, year, material, condition, diameter, from_node, to_node from links) as foo'</EM><BR><EM>TYPE LINE</EM><BR><EM>TEMPLATE "ttt"</EM><BR><EM>CLASS</EM><BR><EM>NAME "Links"</EM><BR><EM>STYLE</EM><BR><EM>COLOR 100 100 100</EM><BR><EM>OUTLINECOLOR 5 5 5</EM><BR><EM>END</EM><BR><EM>END</EM><BR><EM>METADATA</EM><BR><EM>"id_attribute_string""gid"</EM><BR><EM>"query_returned_attributes" "material year condition diameter"</EM><BR><EM>'edit_table' 'links' # PostGIS table</EM><BR><EM>'edit_geometry_column' 'the_geom' # PostGIS geometry column</EM><BR><EM>'edit_geometry_type' 'line' # geometry type, may differ from layer type in mapfile</EM><BR><EM>'edit_srid' '-1'</EM><BR><EM>'edit_attributes' 'gid,id|string,material|string,year|string,condition|string,diameter|string,from_node|string,to_node|string' # list of the editable fields</EM><BR><EM>END</EM><BR></FONT><BR>And the constraint is<BR><EM>ALTER TABLE links<BR> ADD CONSTRAINT enforce_geotype_<FONT face="">the_geom</FONT> CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL);<BR></EM>I changed the returntype to multilinestring.<BR> <BR><EM> if (strtoupper($geometryType) == 'LINE')<BR> return 'MULTILINESTRING';<BR> <BR> return strtoupper($geometryType);</EM><BR><EM><BR></EM>Broun Uganda<BR><BR><BR><BR>
<BLOCKQUOTE>
<HR id=EC_EC_stopSpelling>
From: oliver.christen@camptocamp.com<BR>To: tekuganda@hotmail.com; cartoweb-users@lists.maptools.org<BR>Subject: Re: [Cartoweb-users] Edit plugin MULTILINESTRING ERROR<BR>Date: Mon, 2 Jul 2007 13:59:17 +0200<BR><BR>
<STYLE>
.ExternalClass P
{padding-right:0px;padding-left:0px;padding-bottom:0px;padding-top:0px;}
.ExternalClass
{font-size:10pt;font-family:Tahoma;}
</STYLE>
<DIV><FONT face=Arial>"delicate" as "there could be side effects".</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>the geometry definition is $feature->WKTString</FONT></DIV>
<DIV><FONT face=Arial>that wkt seems to ge generated based on the 'edit_geometry_column' metadata for the related layer or, if it is not set, on the "edit_geometry_type" metadata for the related layer.</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>what metadata did you set for that problematic multistring layer ?</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>regards</FONT></DIV>
<DIV><FONT face=Arial>Oliver</FONT></DIV>
<BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> <A title=tekuganda@hotmail.com href="mailto:tekuganda@hotmail.com">Broun Uganda</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=oliver.christen@camptocamp.com href="mailto:oliver.christen@camptocamp.com">Oliver Christen</A> ; <A title=cartoweb-users@lists.maptools.org href="mailto:cartoweb-users@lists.maptools.org">cartoweb-users@lists.maptools.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, July 02, 2007 1:46 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [Cartoweb-users] Edit plugin MULTILINESTRING ERROR</DIV>
<DIV><BR></DIV>Hey<BR>Could you explain what you mean by delicate,<BR>I just changed the linestring to multilinestring<BR>It still returns the same error.<BR>Broun Uganda<BR><BR><BR><BR>
<BLOCKQUOTE>
<HR id=EC_EC_EC_stopSpelling>
From: <A href="mailto:oliver.christen@camptocamp.com">oliver.christen@camptocamp.com</A><BR>To: <A href="mailto:tekuganda@hotmail.com">tekuganda@hotmail.com</A>; <A href="mailto:cartoweb-users@lists.maptools.org">cartoweb-users@lists.maptools.org</A><BR>Subject: Re: [Cartoweb-users] Edit plugin MULTILINESTRING ERROR<BR>Date: Mon, 2 Jul 2007 08:32:59 +0200<BR><BR>
<STYLE>
.ExternalClass P
{padding-right:0px;padding-left:0px;padding-bottom:0px;padding-top:0px;}
.ExternalClass
{font-size:10pt;font-family:Tahoma;}
</STYLE>
<DIV><FONT face=Arial>Hi</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>most likely because only LINESTRING was implemented in the plugin and not MULTILINESTRING</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>it should be possible to implemente that, though it may be delicate.</FONT></DIV>
<DIV><FONT face=Arial>I think the code to modify is in the function getGeometryType (ServerEdit.php)</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>regards</FONT></DIV>
<DIV><FONT face=Arial>Oliver</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> <A title=tekuganda@hotmail.com href="mailto:tekuganda@hotmail.com">Broun Uganda</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=cartoweb-users@lists.maptools.org href="mailto:cartoweb-users@lists.maptools.org">cartoweb-users@lists.maptools.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, July 02, 2007 4:17 AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Cartoweb-users] Edit plugin MULTILINESTRING ERROR</DIV>
<DIV><BR></DIV>
<DIV style="TEXT-ALIGN: left"><PRE style="BORDER-RIGHT: 0pt; BORDER-TOP: 0pt; BORDER-LEFT: 0pt; BORDER-BOTTOM: 0pt">Hi all,<BR>May some one advise me what the error is in this case. Every time i move a line in my edit i get this error below. why does it return a <SPAN style="FONT-WEIGHT: bold">linestring</SPAN> instead of a<SPAN style="FONT-WEIGHT: bold"> multilinestring</SPAN>? The geometry constranint is that it should return a multiline string or null but why does it return a linestring?<BR>UPDATE public.links SET the_geom = GeometryFromText('LINESTRING(493630.4177779367 1995850.7688888889,493350.18066688 1995824.71352007)', -1) , id = '53', year = '1978', material = 'Ceramic', condition = 'Fair', diameter = '255', from_node = '18', to_node = '17' WHERE gid = 43 [nativecode=ERROR: new row for relation "links" violates check constraint "enforce_geotype_the_geom"]</PRE></DIV><BR>Broun Uganda<BR>
<HR>
Live Earth is coming. Learn more about the hottest summer event - only on MSN. <A href="http://liveearth.msn.com/?source=msntaglineliveearthwlm" target=_blank>Check it out!</A>
<HR>
<BR>_______________________________________________<BR>Cartoweb-users mailing list<BR>Cartoweb-users@lists.maptools.org<BR>http://lists.maptools.org/mailman/listinfo/cartoweb-users<BR><BR></BLOCKQUOTE></BLOCKQUOTE><BR>
<HR>
Hotmail to go? Get your Hotmail, news, sports and much more! <A href="http://mobile.msn.com/" target=_blank>Check out the New MSN Mobile</A> </BLOCKQUOTE></BLOCKQUOTE><BR>
<HR>
Change is good. See what's different about Windows Live Hotmail. <A href="http://www.windowslive-hotmail.com/learnmore/default.html?locale=en-us&ocid=RMT_TAGLM_HMWL_reten_changegood_0607" target=_blank>Check it out!</A> </BLOCKQUOTE></BLOCKQUOTE><br /><hr />Make every IM count. Download Windows Live Messenger and join the i'm Initiative now. It's free. <a href='http://im.live.com/messenger/im/home/?source=TAGWL_June07' target='_new'>Make it count!</a></body>
</html>