<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Hi<div>I need to produce a wfs update to multiple rows, computing the value of property using existing value (like property = property * 2).</div><div>Is it posible?</div><div>I'm preparing this xml, but, I need complete it:</div><div><br></div><div><span style="font-family:monospace"><span style="color:rgb(0,0,0)"><wfs:Update typeName="mylayer">                        </span><br>  <wfs:Property>
<br>    <wfs:Name>myattribute</wfs:Name>   <br>    <wfs:Value> </wfs:Value>  <---- I need put the computed value here
<br>  </wfs:Property>
<br>  <ogc:Filter>
<br>    <ogc:And>
<br>      <ogc:PropertyIsGreaterThan>   <br>        <ogc:PropertyName>id</ogc:PropertyName>
<br>        <ogc:Literal>9</ogc:Literal>                      <br>      </ogc:PropertyIsLessThan>
<br>      <ogc:PropertyIsLessThan>
<br>        <ogc:PropertyName>id</ogc:PropertyName>
<br>        <ogc:Literal>19</ogc:Literal>
<br>      </ogc:PropertyIsLessThan>
<br>    </ogc:And>
<br>  </ogc:Filter>
<br></wfs:Update><br>
<br></span></div><div><span style="font-family:monospace">I need to produce a sql like this:</span></div><div><span style="font-family:monospace"><br></span></div><div><span style="font-family:monospace">update mylayer set myattribute = myattibute * 2 where id between 10 and 20;</span></div><div><span style="font-family:monospace"><br></span></div><div><span style="font-family:monospace">Is it posible?</span></div><div><span style="font-family:monospace"><br></span></div><div><span style="font-family:monospace">Thanks</span></div><div><span style="font-family:monospace"><br></span></div><div><span style="font-family:monospace">jorge infante</span></div><div><span style="font-family:monospace">rosario - santa fe - argentina</span></div><div><span style="font-family:monospace"><br></span></div></div></div></div></div>