SSDN - My XQUERY on Berkley DBXML seems not to like any where statement

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

dreuzel prummel

Subject: My XQUERY on Berkley DBXML seems not to like any where statement
Author: dreuzel prummel
Date: 27 Apr 2006 11:17 AM

im'm working with Berkley XMLDB XQUERY FLOWER

i've a very strange behaviour
xml := <Uit aan='Bok' Remark-'dfsdsdfsdfsd' to='sdfsdfsdfds' ref1='sdsdsddsf'/>

for $x in collection("boek/uit.dbxml")/Uit order by $x/@aan return <test Id='{$x/@aan}' Rem='{$x/@Remark}' to='{$x/@aan}' ref1='{$x/@ref1}'/>

offers me a full result set .... 700 records
inclufding the aan values

as I include the where statement ( records exist with that value 0 records are returned ??)

for $x in collection("boek/uit.dbxml")/Uit[@aan = 'Bok'] order by $x/@Remark return <test Id='{$x/@aan}' Rem='{$x/@Remark}' to='{$x/@aan}' ref1='{$x/@ref1}'/>

for $x in collection("boek/uit.dbxml")/Uit where $x[@aan='Bok'] order by $x/@Rrmark return <test Id='{$x/@aan}' Rem='{$x/@Remark}' to='{$x/@aan}' ref1='{$x/@ref1}'/>
for $x in collection("boek/uit.dbxml")/Uit where $x[@aan='Bok']
for $x in collection("boek/uit.dbxml")/Uit[@aan = 'Bok']

Any idea what i'm doing wrong ????

Minollo I.

Subject: My XQUERY on Berkley DBXML seems not to like any where statement
Author: Minollo I.
Date: 27 Apr 2006 12:43 PM

You are asking your question on the wrong forum; DB XML questions should be asked on the proper Sleepycat discussion lists.

Minollo

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.