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

ECC6 - Single sign-on
We are in the process of upgrading to ECC 6 which will support single sign on with user passwords al

question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.

I hav

help with insert
Hi there,

I am trying to insert some data into a database, but for some reason, it is not ins

path to include folder
Hi everyone,

When I'm testing locally, I have to add the name of the site folder as part of t

Displaying returned XML in another PHP page
I have an online payment form that will return XML given if a payment is successful or declines. I

Session is not saving
I am not trying to do anything too fancy, I am just trying to get some $_SESSION data to save and us

why preg_match_all does not return the number of matches
My regex looks like

X[^x{4e00}-x{9fa5}]*Y

(where X and Y are two Chinese characters)

TemplatePower & AJAX
Hi all,



I'm currently implementing some AJAX features in my PHP-framework (which is b

PHP form help required
Hi all! Apologies in advance for having to message the forum for help. I know you must get a lot of

send message to the java application
Oracle 10g with Windows platform.

I have a java application that periodically pings the d