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
Raghav TulshibagwaleSubject: Use of if-then-else
Author: Raghav Tulshibagwale
Date: 18 Nov 2008 01:49 AM
Originally Posted: 18 Nov 2008 01:47 AM
Hello ...

I have the following query which is giving me an error. The problem comes when I put the "if-then-else" statements there!! Can any one of you put some light on it??

The query is as follows....
let $customer :=doc("cust.xml")/cust_information/cust
let $mall :=doc("mall.xml")/mall_information/mall

for $cust in $customer
let $x := count ((for $temp in $mall where $temp/mall_cust = $cust/cust_id and $temp/mall_addr = "Main street" return $temp) )

let $y := count ((for $temp in $mall where $temp/mall_cust = $cust/cust_id and $temp/mall_addr = "downtown" return $temp) )

if ($x < $x )
then return $cust/cust_id

This query is intended to return all customers who go to mall on "main street" MORE THAN mall at "Downtown". This query gives errors!!

Minollo I.Subject: Use of if-then-else
Author: Minollo I.
Date: 18 Nov 2008 08:40 AM
Try changing:
if ($x < $y )
then return $cust/cust_id


if ($x < $y )
then $cust/cust_id

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!  

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.