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

Help If user voted, block them
On my Prayer request site, i let users Click a button to Pray for somone that has posted a pray, i g

Session is not saving
I am not trying to do anything too fancy, I am just trying to get some $_SESSION data to save and us

want a code for uploading and downloading
i m trying to upload and download to my site..i need upload and download code ...i use a code for up

j1inmis Ouput layout changes
Hi,

Can anybody tell how can j1inmis output layout can be changed so that vendor names ge

Multiple PHP errors when clicking a link..and..removing a ghost..
Hi - I have 2 problems with a new website - homeswapvacations.com, which I need help solving.

mysql query with single quotes in a variable
$sitedetails = "INSERT INTO vars (address, sitename, description, ownername, theme) VALUES ('$u

how to remove in php string display
My code is

$message="We're looking at developing our website.";

$body= "

CODE NOT WORKING
Code: [Select]<?php
//include shared codes

include '../lib/common.php';
include

phpmailer class & pop.gmail.com?
Code: <?php
$mail->IsSMTP();
$mail->Host = "pop.gmail.com";

Upload, SSL and more php help
I recently just installed a ssl cert and do i use https for the whole site or just for the checkout.