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

Take info from one coloum and move to another
Hi all,

I have this:
Code: [Select]$array = "SELECT stock_id FROM stocks WHERE stock_

understanding functions and classes
Code: [Select]
class person {
var $name = "Jimmy Goe";

function get_nam

Material Master Update through BAPI - Follow up material not updated
Hi Experts,

I am updating the material master through a custom transaction using the BAPI

What makes a script your own?
If someone finds a login script online, and changes some variable names around and some other minor

Save file by click
Hello.
I'm not understand how to save file from page. I'd like make link to file with save abil

generating all possible random letters
hi'

how can i randomize the letters a,b,c,d,e all possible ways, and i want to print the res

Customizing message/behavior
Hi,I'm using the ASP.NET membership/authorization controls in my application. Some parts of my appli

What's wrong with my code
sobbing for many days, still don't know why please Help. Why my page isn't posted correctly. In a

Wordpress IE issue
So I am trying to add the background shadow to my wordpress page. It works fine in Firefox but does

problem getting my contact form working
Yeah I know this is a pretty basic problem, but it's been a while since I've worked with PHP and I'm

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