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 when runing a funciton
I am trying to connect to database using a funciton in a functions.php

<?php
funct

Convert .fdf to .pdf
I currently have a web form that uploads the form data to an .fdf file and emails it.

However

highlighting search terms
well, I started this in the regular PHP section, but it no longer fits there. Suffice it to say, I'm

Filling gaps in dates
So i'm doing a query for sales data and my return array looks like this

('date' => '20

Remove letter from numeric textbox
I have a textbox that will search the employee database by entering in the employee ID and it will r

SAP Business Suite
Hi all:

Within the SAP Business Suite solution I would like to ask you the main differenc

Doubles are giving me problems
Ok so, first of all i made a double = 0.05, but when running the debugger it shows up as 0.04999. I

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

session_destroy();
new to php
I have a simple login and am trying to write a logout.
I set a $_SESSION var to 1 i

HTAccess auto log in?
Hi all.

Too busy driving celebs about lately so I hope someone here can help me out.

I