[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

Florent Georges lists at fgeorges.org
Thu Jan 17 17:04:55 PST 2008


  distinct-values in Where Clauses
"Wei, Alice J." wrote:

  Hi

> <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.

  The distinct-values is evaluated within the where clause,
so for each div independently.  It is not clear to me what
the distinct-values should be about.  If it is on the div
itself, you can use something like that (but I doubt this
would be on the div itself):

    <text> {
      doc("resume.xml")/distinct-values(
        //div[
            contains(note, $text)
            or contains(head, $text)
            or contains(p, $text)
          ]
      )/
      <div>
         <head>{ data($head) }</head>
         <p>{ data($desc) }</p>
         <note>{ data($note) }</note>
      </div>
    }
    </text>

  If you told us what you want too achieve (for instance
with a simple example of what you mean is duplicate), we
would help you better.

  Regards,

--drkm
























      _____________________________________________________________________________ 
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail http://mail.yahoo.fr



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.