Problem with Variable having Numericvalue node comparison
Hi, I am trying to compare two variable in basex as given, let $v3 :=<a>7900000.00</a> let $v2:=<a>930000.00</a> return $v2 <= $v3 I am expecting that it will give me true, But it is giving false. I think it is because of the comparison is only string comparison. Is it possible to configure basex for numeric comparison without changing the expression $V2 <= $V3 , or I have to explicitly convert variable value to decimal and then compare it. Thanks, Ankit
Simply convert the values to numbers: let $v3 :=<a>7900000.00</a> let $v2:=<a>930000.00</a> return number($v2) <= number($v3) Best, Christian On Wed, May 13, 2015 at 9:40 AM, ankit kumar <anky4bugs@gmail.com> wrote:
Hi,
I am trying to compare two variable in basex as given,
let $v3 :=<a>7900000.00</a> let $v2:=<a>930000.00</a> return $v2 <= $v3
I am expecting that it will give me true, But it is giving false. I think it is because of the comparison is only string comparison. Is it possible to configure basex for numeric comparison without changing the expression $V2 <= $V3 , or I have to explicitly convert variable value to decimal and then compare it.
Thanks, Ankit
participants (2)
-
ankit kumar -
Christian Grün