RE: XQuery Update to return values

The query below does not change the original document. Only the copied =
var $newVar is updated.
I need the $var to be updated and return the updated $var as well. Any =
idea? Thanks.

Emma


-----Original Message-----
From: Carmelo Montanez [mailto:[email protected]]
Sent: Fri 7/27/2007 9:41 AM
To: Wu, Emma; [email protected]
Subject: Re: XQuery Update to return values
=20
Emma:

If I am not mistaken, you can use a Transform expression, which will=20
return a value back.
Something like this:

let $var :=3D fn:doc("works-mod.xml")/works[1]/employee[1]
let $var1 :=3D <pnum>P1-1</pnum>
return
  transform
   copy $newVar :=3D $var
   modify do replace $newVar/pnum[1] with $var1
   return $newVar

Thanks,
Carmelo


At 02:02 PM 7/26/2007, Wu, Emma wrote:
>Hi,
>
>The problem I am trying to solve is that with XQuery Update=20
>faicility, I will update an element and at the same time, I want the=20
>same element to be returned. Something like the following:
>
>1. update a book element's author
>2. return the updated book element
>
>Is there a way to do it in one query instead of two separate=20
>queries? And it looks like update expression does not return anything
>
>Thanks,
>Emma
>
>
>
>