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

check how many commas the variable containing the query has between [i]select[/i
Hi...

iv made an sql table that contains id number - name of sql query and an sql query.
T

Sending UDP Raw socket
I truly need help on this. I am trying to write a test program that simulate a network environment

path to include folder
Hi everyone,

When I'm testing locally, I have to add the name of the site folder as part of t

Is there a way to override built in php functions without APD?
I am trying to use the
rename_function()
override_function()
options that are built into

Select question
Hi,

First I would like to say that php is pretty new for me..
so please don't shoot me if

Help with search.php
Hello All

I need the search engine on a site I am building at the moment to display the searc

trim function issues
Hi guys, total noob here...

So I've been tinkering around with a html and am using php to em

HeaderSelectedCssClass not working
I have an accordian where I have a drop down list in the first pane and a grid in the second pane.

Working with Dates, help.
Sooo to make a long story short, here's what im trying to accomplish.

I need to create a drop

PHP/PKI
I am trying to set up a web application that uses pki. does anyone have a good tutorial to set this