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

Parse Error with doctype
I'm getting a parse error with this simple code. I don't get it. It worked one time then when I relo

Need help with a mail notify function
I was tasked with setting up a site that's been prewritten. The site is basically a form that captur

New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan

browse folder only
hi,
is there a way i can browse or get the directory or folder only and not the file?
i just w

Hi, explode and strstr.
Hi, I seem to be confused about the strstr function, eg. i have a string like:
"a.b.c.d.e.f&

PHP Session Issue
I'm having an issue with one section on my website dealing with sessions. Now I know that myself and

Why do I get this error
Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/a5488351/public_html/b

Port scanner problem
Hai
recently i developed one app through which u can check the opened and closed ports under an

How to generate a text file using php...?
Hi,
Can anyone give me code to generate a text file using php


Thanks in advance

Help with lottery style system?
I'm working on a currency system for forums and it is going to have a type of lottery system built i