About wfs update to multiple rows

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

About wfs update to multiple rows

INFANTE, Jorge Luis
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 = myattibute * 2 where id between 10 and 20;

Is it posible?

Thanks

jorge infante
rosario - santa fe - argentina


_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: About wfs update to multiple rows

INFANTE, Jorge Luis
Excuse me.
The message was for geoserver user list.



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user