xml binding parameters

[Mihai]

Hi to everybody !
I have this query:

select * from registereddatab ases a where

exists(select rights.exist('d eclare namespace x="urn:Reposito ry:UserRights";

/x:Rights/x:Year[@YearId={sql:co lumn("a.year")}]')

from users b where user_pk=8 )



but I have the error message:

XQuery [users.Rights.ex ist()]: An expression was expected

I tried even:

declare @aa integer

set @aa = 2007

select * from registereddatab ases a where

exists(select rights.exist('d eclare namespace x="urn:Reposito ry:UserRights";

/x:Rights/x:Year[@YearId={sql:va riable("@aa")}]')

from users b where user_pk=8 )

but i have the same error message.



Any ideeas?

Mihai

[Martin Honnen]

Re: xml binding parameters

Mihai wrote:

I have this query:
>
select * from registereddatab ases a where
>
exists(select rights.exist('d eclare namespace x="urn:Reposito ry:UserRights";
>
/x:Rights/x:Year[@YearId={sql:co lumn("a.year")}]')
>
from users b where user_pk=8 )

Take out the brackets {}, you simply need
/x:Rights/x:Year[@YearId = sql:column("a.y ear")]


--

Martin Honnen --- MVP XML

http://JavaScript.FAQTs.com/