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

Need help with an email blocker for a guessbook
I am new with php and here is a simple guessbook page but I am being hit with spam from a group of t

! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement

Saving data from a form into a file
Hey everybody,

Sorry, I am really new to PHP coding and such but a project kind of got thrust

NOOB needs help with upload file
The intent of this form is to create a folder for a client and upload an image into another folder '

Members Only
Hi all, for my website i have a members area only which on members can veiw, but at the moment anyon

Gantt Chart Tool
Does anyone know of a good free gantt chart creator tool

Thanks

gmdate() - want 1 hr before time
Hi,
I am using php gmdate().
Now I am entering all dates in my dbase using gmdate("Y-m-d

mysql select with $_get ?
Hi, i have this code:
Code: // If char id is 0 and character dont exist do:
if ($_GET["id

Echo-ing MySQL content and Keep Formatting?
I have data in my MySQL such as:

QuoteBlah blah

Blah blah

etc
but when i ech

Loop column after 2 results
Hello All.

Here is what I have:

Client ID Company name Clien