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

updating a single value to multiple non consecutive rows
I need to update the same value to multiple non consecutive rows. I need to add an experation date t

Mouseover to edit (Ajax)
hi friends, can anyone help with the code behind to get this application working, please in VB (new

How to pass parameter to tag query?
Hi,
I want to get the value of a tag at a specific time (like 10/27/09 15:29:59), I need to giv

Php navigation
I have four buttons on a php page.
If i click a button it will redirect to different php pages.

Dynamic links in an include file
I am working on a small piece of code that counts records from a database and displays the result to

PHP Surveys
I really would like some advice.

If you have a client come to you asking for a survey to be d

Return X values where an ID number doesnt matter
Well as for subject heading, thats the best i could think of.

Currently im having a problem w

Trouble with a select list
Hello All!
I was wondering if any of you guys could help me with a small problem I'm having!

Multiple Dropdown Selections
I have a form that let's a user insert a page with the ability to select categories. I want them to

How do I create a 2D game "camera" to follow player?
In J2ME programming I'm targeting MIDP 2.0 devices.

I'm using gamecanvas and I was thinking t