XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Matthew O'BrienSubject: it's possible to have a where clause with variables?
Author: Matthew O'Brien
Date: 09 May 2007 12:59 PM
hi all,
i'll show you my problem!

it's possible to replace something like this:

for $a in doc( '/db/tesi/UtentiIstanza.xml' )/utenti/utente
where $a/credenziali/unacredenziale[nomecredenziale='CI']/residenza='Milano'
return $a/id

with something like this:

let $expcred := "credenziali/unacredenziale[nomecredenziale='CI']/residenza='Milano'"
for $a in doc( '/db/tesi/UtentiIstanza.xml' )/utenti/utente
where $a/$expcred
return $a/id

the first example works,the second no,how can i do?
I need to use this in a function and $expcred is one of my parameters

thanks a lot for your help
Matthew

_______________________________________
this is my XML

<utenti >
<utente>
<id>0</id>
<username>admin</username>
<password>admin</password>
<credenziali/>
</utente>
<utente>
<id>1</id>
<username>teyo</username>
<password>qwerty</password>
<credenziali>
<unacredenziale>
<nomecredenziale>CI</nomecredenziale>
<cognome>O'Brien</cognome>
<nome>Matthew</nome>
<residenza>Milano</residenza>
<professione>studente</professione>
</unacredenziale>
<unacredenziale>
<nomecredenziale>BIB</nomecredenziale>
<cognome>O'Brien</cognome>
<nome>Matthew</nome>
<numerotessera>MI12345</numerotessera>
</unacredenziale>
</credenziali>
</utente>
</utenti>

Posttop
Alberto MassariSubject: it's possible to have a where clause with variables?
Author: Alberto Massari
Date: 11 May 2007 08:38 AM
Hi Matthew,
what you want to do is not possible, unless you use a non-standard function that lets you evaluate a query at runtime (e.g. with Saxon, it's saxon:eval)

Hope this helps,
Alberto

 
Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.