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

Apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?

Why will this program not run if the variables are not global?
Hey guys I have a kind of perplexing situation that is probably simple, but I can't seem to understa

SELECT * FROM users WHERE Users are not in Blocked
How do I select all users from users table where there users_id is not stored in the block table

Saving data from a form into a file
Hey everybody,

Sorry, I am really new to PHP coding and such but a project kind of got thrust

error checking breaking my code
Hi there, OK first of all, big apologies for what I assume is really fundamental errors in the struc

Hashing?
Hi, I was hoping to take a string value then convert it - consistently - across each of our pages in

Calling variables
I want to call this to my website but it doesn't display what I want it to,

Code: <h5&

login page does not execute a else statement
I've created a login page using sessions.
When an incorrect user name or password is entered then

Where do I put CRON code
So I've figured out alot about how to automatically run a php function. I can't figure out where to

keeps going back to index.html ???????
ok so i started making my site using mostly.html files now i have added a fair chunk of php. My inde