[Geoserver-devel] Fwd: About wfs update to multiple rows

[Jorge Infante]

Hi
I need to produce a wfs update to multiple rows, computing the value of
property using existing value (like property = property * 2).
Is it posible?
I'm preparing this xml, but, I need complete it:

<wfs:Update typeName="mylayer">
 <wfs:Property>
   <wfs:Name>myattribute</wfs:Name>
   <wfs:Value> </wfs:Value>  <---- I need put the computed value here
 </wfs:Property>
 <ogc:Filter>
   <ogc:And>
     <ogc:PropertyIsGreaterThan>
       <ogc:PropertyName>id</ogc:PropertyName>
       <ogc:Literal>9</ogc:Literal>
     </ogc:PropertyIsLessThan>
     <ogc:PropertyIsLessThan>
       <ogc:PropertyName>id</ogc:PropertyName>
       <ogc:Literal>19</ogc:Literal>
     </ogc:PropertyIsLessThan>
   </ogc:And>
 </ogc:Filter>
</wfs:Update>

I need to produce a sql like this:

update mylayer set myattribute = myattribute * 2 where id between 10 and 20;

Is it posible?

Thanks

jorge infante
rosario - santa fe - argentina


_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel