[xquery-talk] if statements within where clauses?
Jonathan Robie
jonathan.robie at datadirect.com
Wed Jun 14 15:28:26 PDT 2006
Ooops, I forgot the "then" keyword:
where contains($text, $keyword)
and if ($var ='all')
then
$entries//classcode = $region
else
true()
But you probably caught that error ;->
Jonathan
Jonathan Robie wrote:
> Hi Cindy,
>
> XQuery allows expressions to be combined very freely, and you can
> certainly use an if expression for conditional logic in a WHERE
> clause, as follows:
>
> ....
> where contains($text, $keyword)
> and if ($var ='all')
> $entries//classcode = $region
> else
> true()
>
> I did not understand what you are trying to do well enough to know
> exactly what the query should look like.
>
> Hope this helps!
>
> Jonathan
>
More information about the talk
mailing list