[bdbxml] XQuery problem
Manish Rai Jain <[email protected]> Wed, 7 Sep 2005 17:19:45 +0800
| Newsgroups | gmane.comp.db.dbxml.general |
|---|---|
| Message-ID | <[email protected]> |
Hi
I am trying to query across a container. Basically, the query is to have 3
conditions. If ANY of these is TRUE, then return the result.
************************************************************************
for $x in collection("bulk.dbxml")/gnv_enzyme_pathway/db_entry
let $m := $x/enzyme_id
let $s := $x/swissprot_reference_list/reference/@name
where some $r in $s
satisfies contains($r, "FABG1_BRANA")
return
<result>
<Enzyme_id id="{$m}"></Enzyme_id>
</result>
*************************************************
In this query, I need to add another condition, which will go like
.....
where some $r in $s satisfies contains($r, "FABG1_BRANA") OR if
$m="1.1.1.10<http://1.1.1.10>
"
return
.....
But, this is not working properly. Any ideas/suggestions how to add these
conditions in xquery.
I doubt if this question belongs to this mailing list; but, still if you
have any idea abt it, please do let me know.
Regards
Manish