[XQuery Talk Mailing List Archive Home] [By Date] [By Thread] [By Subject] [By Author] [Recent Entries] [Reply To This Message]

distinct-values in Where Clauses

Michael Kay mike at saxonica.com
Thu Jan 17 15:35:09 PST 2008


  distinct-values in Where Clauses
The argument to your call of distinct-values() is a single boolean. If you
call distinct-values(true()) the answer will be true(); similarly
distinct-values(false()) is false(). 

Once again, I have to admit defeat in correcting this query. I simply can't
work out what you thought it might mean. (Sometimes people find it difficult
to explain their requirements either in XQuery or in clear English. If
that's the case, it often helps to show the input and your desired output.)

Michael Kay
http://www.saxonica.com/


> -----Original Message-----
> From: http://x-query.com/mailman/listinfo/talk 
> [mailto:http://x-query.com/mailman/listinfo/talk] On Behalf Of Wei, Alice J.
> Sent: 17 January 2008 15:07
> To: http://x-query.com/mailman/listinfo/talk
> Subject:  distinct-values in Where Clauses
> 
> Hi, XQueryers
> 
>    I am processing some nodes of information using a lot of 
> different "or" in my query structure. Here is the XQuery:
> 
> declare boundary-space preserve;
> declare variable $text external;
> 
> <text>{
> for $find in doc("resume.xml")//div,
> $note in $find/note,
> $head in $find/head,
> $desc in $find/p
> where
> distinct-values((contains($desc,$text)) or 
> (contains($note,$text)) or (contains($head,$text))) return 
> <div> <head>{data($head)}</head> <p>{data($desc)}</p> 
> <note>{data($note)}</note> </div> } </text>
> 
> The query itself is functional, but the problem is that even 
> though my distinct-values function has been set, there are 
> still duplicates. Can anyone help out?
> 
> Thanks to those who can help.
> 
> ======================================================
> Alice Wei
> MIS 2008
> School of Library and Information Science Indiana University 
> Bloomington http://x-query.com/mailman/listinfo/talk<mailto:http://x-query.com/mailman/listinfo/talk>
> 
> _______________________________________________
> http://x-query.com/mailman/listinfo/talk
> http://x-query.com/mailman/listinfo/talk



Purchase Stylus Studio Online Today!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2007 All Rights Reserved.