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

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

Help: calling function
Hi,
Is it possible to call a php function on page close?
If yes, could you explain how and whe

Ajax Issues - Update Panel / Timer. Intellisense doesn't know about them
Type 'System.Web.UI.ScriptManager' does not have a public property named 'UpdatePanel'. That is wha

What am I missing here? Help!
Hello all!. I can't seem to get this working right. Well - it renders right, but something is goin

order by date not ID number help php
I am trying to orginize the following code to order by date not id number.
any help would be grea

Displaying image pathname instead of image
Hello

Im trying to upload and then display images from a mysql database - Its only basic and

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

I have a java application that periodically pings the d

User input in to variable
Hi all,

I'm sure this is very easy but I'm having another brain freeze!

At the end of

string to currency format
Hi guys...

Actually I chunk out some data from txtfile and one of the data contains amount va

How to search for several parameters from objects in a database?
I have a database with lots of information about objects.
Now I would like to search for 4 or 5 p