Where Clause and XDT:Untyped Issues

Michael Kay mike at saxonica.com
Sun Feb 3 00:48:49 PST 2008

Previous message: Where Clause and XDT:Untyped Issues
Next message: Where Clause and XDT:Untyped Issues
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Play the video

You sent me a sample of the source document off-list, I assume you meant it
to go to the list:

<pb n="29" xml:id="010003-031"/>
        <ad><head><emph rend="bold deepink">Hostess</emph> is back with new
Baseball Cards...to
                    collect and trade with your friends.</head>
        <p><emph rend="bold orange">3 Free Baseball Cards</emph>
        <emph rend="bold">on specially marked boxes of HostessR Snack
                    Cakes.</emph></p>
        <p>A total of 150 cards. Full of facts. Collect 'em. Trade 'em.</p>
        <p>3 full-color cards printed on the bottom of every specially
marked box of
                        Twinkies<emph rend="sup">R</emph>, Cup Cakes, Suzy
Q's <emph rend="sup">R</emph>, and other mmmmmmmm-delicious Hostess<emph
rend="sup">R</emph>  Snacks. </p>
        <note>RHostess. Twinkies and Suzy Q's are registered trademarks of
ITT   Continental Baking Co.
<lb/> Offer expires August 31, 1976</note> </ad>

With this kind of data, I strongly suspect that the reason your attempt to
eliminate duplicates isn't working is that the apparent duplicate ads are
actually different in some minor detail.

Try selecting two ads that you believe to be duplicates and comparing them
using eq.

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

> -----Original Message-----
> From: Wei, Alice J. [mailto:http://x-query.com/mailman/listinfo/talk] 
> Sent: 02 February 2008 22:12
> To: Michael Kay; 'Torsten Grust'
> Cc: http://x-query.com/mailman/listinfo/talk
> Subject: RE:  Where Clause and XDT:Untyped Issues
> 
> Hi, Michael:
> 
>   Thanks, I did not realize that my <head type="main"> and 
> <head type="sub"> can bring so many of these relevant errors.
> 
>    I have fixed up the code to as follows:
> 
> let $ad := fn:collection("xmldb:exist://db/my")//ad
> let $sorted_result:=
> for $doc in distinct-values($ad)
> where contains($ad/head[@type='sub'],'Baseball')
> order by $doc
> return $doc
> for $r at $count in $sorted_result
> let $nodes := $ad[. = $r]
> return
> <ad>
> <statistics>
> Showing Result: {$count} / {count($sorted_result)} 
> </statistics> {$nodes} </ad>
> 
> This produces no type error issues, but neither does it bring 
> back results.
> 
> If I  change the where clause to where 
> contains($doc,'Baseball'), it brings back something like the 
> one in the following:
> 
> <ad>
...
> </ad>
> <!--Another duplicate of the <ad>  -->
> </ad>
>

Previous message: Where Clause and XDT:Untyped Issues
Next message: Where Clause and XDT:Untyped Issues
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Purchase Stylus Studio Online Today!

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

Download The World's Best XML IDE!

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

Subscribe in XML format

RSS 2.0
Atom 0.3


	Stylus Studio® Developer Network \| Contact Us \| Email this page