[xquery-talk] more readable format - can let clause help me here

pooja singh p03singh at yahoo.com
Sun Oct 31 08:39:27 PST 2004

I am using VB.net and microsoft.xml.xquery.dll. I want to break this long xquery into more readable format. Can someone please suggest me what I am doing wrong.
this Query works:(give me the right sum, but very cumbersome to read) 
query =       "let $price:=sum(document(""f1"")//Repair[((RP02/TypeCode='NW' and RP05/Type='0')or (RP02/LaborCode='G' and RP02/ModCode!='LK' and RP02/PartCode!='SL' and RP02/ModCode!='SL' and RP05/Type='0'))]/RP01/DisplayPrice)  " & _

         "return <Amount>{$price}</Amount> "

I tried to break it down like this and obviously this does not work...

query = "let $c1:=""(RP02/TypeCode='NW' and RP05/Type='0')"" " & _

        "let $c2:=""(RP02/LaborCode='G' and RP02/ModCode='LK' and  and RP02/PartCode!='SL' and RP02/ModCode!='SL' and RP05/Type='0' )""  " & _

         "let $price:=sum((document(""f1"")//Repair[$c1 or $c2]/RP01/DisplayPrice))  " & _

         "return <Amount>{$price}</Amount> "


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://xquery.com/pipermail/talk/attachments/20041031/01447a52/attachment.htm

More information about the talk mailing list