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

how to insert value
I am having file bookissueadd.php..... in which i am having tag

<td height="21&q

Coding Critique
I was hoping someone could take a second and look down my code and see if they see any problems with

phpMailer not working ..........
HI,
I was playing with the phpMailer script and tried to send a smiple mail using their test scri

IIS on 2003 anon access disabled issue
I have an IIS server that belongs to a domain, and anonymous access is turned off for all my sites.

Unique Visitor Tracking
Hello. Currently, I run a voting site where voters are tracked by their IP address and can only vote

php/xmlrpc class issue
I am working on xml-rpc in php to start with.

I have a class that only has variables defined

Confused with Loop
guys, i got confused with Looping...this is the case

I have 3 stocks, let say "Stock A&q

array & querys help/advice.
Ok so here goes , I have a mysql database and basically here's what I need to do.

// foreach

sql problems
I am having a small problem with my sql statement. it is inserting into 4 of the fields.

fie

Error Messaging not working
I changed the way my form tells the user of an error. But I can't seem to get it to work properly.