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

getting weird error..
okay, I'm getting an error on this particular function, something about the syntax in the mysql LIMI

tag inside php...
hi


Code: <?php
echo "<td width="$columnWidth%" align=&

Forgot password won't work
My forgot password thing is not working properly. It is giving me this errorMailbox unavailable. The

Good Programming and Web Design Books
Hi,

I recived a pm today from a fellow phpfreaker regarding php books, i replied with the fo

Why does first ever HttpSendRequest take longer?
I promise this isn't as simple as it sounds. I'm wondering why the the first ever call to HttpSendRe

how to get IP address?
hey guys,

i have this code which is supposed to get me the IP address of my site visitors:

rename the file
File.txt

Code: ***DOCUMENT***
..DN:
000044255
..CB:
..SN:
..PY:
2009
..E

How to make URL loads only on login
On my page, when a user login he's redirects to user_home.php. I made it also to open the chat scree

selectbox+database connection retrive problem
Code: [Select]
<tr>
<th align="left" scope="c

Hyperlink is adding an extra gap to variable
Hi, here's my problem..

I have a php generated page with a hyperlink which opens in a new win