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

Curl timeout breaks script
So im having difficulties with skipping timeout error in curl
my script calls different functions

Handling text changed in text box control using Ajax
I need to create a web form with a text box control. When someone types text into the textbox I nee

Form Help
Here is the form:

Line number On/Off | Expand/Contract<? include("../include/sess

Escape Latin Characters
I need to escape latin characters in an xml doc. Example: "é" is escaped to "é". I thoug

Count on multidimensional array
Hi, i got an array as below:

Array
(
=> Array
(

Undefined offset
The following script checks to see if the user answer matches the correct answer.

Form Fiel

Google voice
I currently have a form in html, but I want it in php so the information is not in the source code.<

Attempt to assign property of non-object in...
I'm having issues with the following function in PHP 5...

function getTreeWithChildre

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

have trouble in a if condition
The if below is working ok, it check when indexes, name, zipcode and state are empty.
Code: &