Xacute search within SQL results

Posted on 16th Feb 2014 01:33 pm by admin

I have a query that is pulling data, and I want to return a specific value from the results of that query, so I'm using the following to do this:
sqlData.Results{/Rowsets/Rowset/Row[Productid = #locProductID#]/StartDate}
And this works. The problem comes into play when I try to include a date, for example:
sqlData.Results{/Rowsets/Rowset/Row[Productid = #locProductID# and StartDate >= #locStartDate# and EndDate <= #locEndDate#]/StartDate}
The problem is that whenever I include the dates, it doesn't return any data. All dates are in XML format.


No comments posted yet

Your Answer:

Login to answer
337 Like 35 Dislike
Previous forums Next forums
Other forums

DateObject and Nulls
Hi all,

I have an array mapped to a value object. One of the items in the array is a PHP Date

Kill a process
I have a question - how can I kill a process from a command line or by using Oracle SQL Developer? I

Christian Louboutin Neofilo 120mm Aquamarine WatersnakeChristian Louboutin Neofilo 120mm Aquamarine Watersnake [4123] - NOK 1,302 : Profesjonell Jimmy Choo Sko Outlet Store, shoesjimmychoo.cn
[b][url=http://www.shoesjimmychoo.cn/no/]Jimmy Choo klaring[/url][/b] [b][url=http://www.shoesjimmyc

Detail Expenses Report by Cost Center
I would like to obtain a report out of SAP that shows a list of expenses by cost center that shows t

issues verifying if user is logged in
I am having issues when a user logs in via asp Login control, the IsAuthenticated still seems to com

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Google+ Indyaspeak @ Pinterest RSS