Xacute search within SQL results


Posted on 16th Feb 2014 07:03 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}
Did you know?Explore Trending and Topic pages for more stories like this.
The problem is that whenever I include the dates, it doesn't return any data. All dates are in XML format.

Thanks
No comments posted yet

Your Answer:

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

Pagination
Hi All,

I think I'm finally getting somewhere with pagination!

I can now submit a quer

how to export excel file in same server
My first post - php newbie, so appreciate your support.

I'm currently using headers to save w

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

Request.UrlReferrer
I need to make it so that a page can only be loaded when a button is clicked on a specific page. I d

Exporting new records
Trying to figure out the best way to set this up.

People register my site.

Their prof

Operator precedence assistance.
I did a quick Google search and couldn't quite find the answer I wanted in terms I could understand,

List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab

error checking breaking my code
Hi there, OK first of all, big apologies for what I assume is really fundamental errors in the struc

Which practice of iteration through containers is preferred
In the "real world" what kind of loop do most people use to iterate through a container like a vecto

Finding digits in variable containing text, and IDing them
$romanstock = "http://www.remoteprice.com/data.asp?storeid=123&itemcode=456&typ

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



Play Free Quiz and Win Cash