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

calculator
I can't figure out why this code doesn't work. No error messages. Page loads.

Code: <

Showing selected item at top of list
Hi,

I've got a list of names which i am fetching from database like this:
$qry = db_query

setcookie and isset($_COOKIE(name)) seem very finnicky.
I'm currently playing around with a user system with login and registration. I'm trying to use cooki

how can i expire the submitted page using session.
hi,
i'm new to php world.
i'm using "post" method.
when i submit it,data goes to

Include with Parameters
In a particular page I would like to include a file that requires $_GET parameters.

when I go

whats wrong with my code please help!!!
this is the error


Warning: mysql_close(): supplied argument is not a valid MySQL-Link res

building a function with multiple outputs
I want to build a function that has multiple outputs.

I know but am not to sure how I should

Unable to display contents in Second Drop Down Box
Hi All,

What I am trying to do is 2 dependent drop down boxes and when user selects su

Error when call dll from oracle
Hi all, please help me!

I have dll write C language, I want call it from oracle procedur

Creating XML with php
I need to creat an XML with php and have successfully produced a valid output.
The problem I hav