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

No comments posted yet

Your Answer:

Login to answer
337 Like 35 Dislike
Previous forums Next forums
Other forums

Help with file_get_html
The following code gives the expected results:

<html>
<head&g

Help, Base64 encoding url and decoding server side.
Hello everyone, i have a website with videos and games and also provide an embed code which people c

Get to know your fellow coder
I think it's time we got personal around here. There's a lot of code swapping and a few members kno

Request for tunning the below query
Hi,

Can any one help me on the below query while improving the performance,

Get ID from Database when Posting with a HTML Form
I have a form I am submitting to a MySql database. Each product has an ID # attached to it that auto

Taking an HTML form and a PHP program and making it into one working file.
Hello,

So I would like to display everything INSIDE a specific directory. In other words, I

CURL question
i am wondering if it's possible to use multi curl with login something like

login once to web

TabControl Inside ListView Not Editing
Hello everybodyI have a ListView on my page. Inside the ListView I put a TabControl, cuz I want to p

connect() succeeds but accept() does not?
Please help me with this problem. I'm working on a time-sensitive project where I'm using TCP socket

Need help with unexpected T-STRING error
I'm a newbie and I'm still learning PHP. However this error has me stumped. I've googled, searched t

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash