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}
The problem is that whenever I include the dates, it doesn't return any data. All dates are in XML format.

Thanks

Your Answer:

Login to answer

Other forums

help with multi-update
Now sure how to ask this really....
10g database if that matters.

I have a customer

Problem with passing variables
I'm not really a php programmer so I'm really struggling with this issue.

I have a banner s

SAP Management Console is blank
Dear All ,

I am facing problem in my des sever suddely in SAP Management Console is blank and

help with email script...
hey

I need help with my mail script

when the form on http://www.mcgdesignstudio.com/c

need help modifying script
Hi guys,

I'm fairly new to php and am having a bit of trouble modifying a script.

This

User feedback after MySQL query has been executed
Hi all, I've just registered on PHPFreaks because I've got a question that I simply can't work out b

How to submit a form to the same page?
I have a table containing information about books in my library and this table has the following col

reating a background image
I am building a site in drupal and have a php form in it, due to certain annoyances with module buil

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

need a script for 3 pages
I have a customer who wants me to set up a site with a number of pages with the following requiremen