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}
Did you know?Explore Trending and Topic pages for more stories like this.
The problem is that whenever I include the dates, it doesn't return any data. All dates are in XML format.

Thanks
No comments posted yet

Your Answer:

Login to answer
337 Like 35 Dislike
Previous forums Next forums
Other forums

Specific name typed, specific image shown on html page
Hello,

Fairly new to PHP and was curious if someone might know how to solve a fairly simple r

Applet JTextField Size Problem
Hello,

I recently started making an applet to calculate certain values for airplanes. However

question about n
I was looking at some of the things you could do with php and one of the things I have tried is n.<

BSP Ext - tableView - Sort - NEWBIE
Hi,
I have been trying to get the sort to work. I have defined the column definitions by fillin

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game

Auto fill in input value based on User_ID
Hello,

I'm looking form some input on the following problem.

User loads page ->

Can anyone give me some link on .htaccess tutorial
i wish to have friendly url using .htaccess, but no idea yet about this

Hope that anyone cou

Looping Problem
I've got a client that has a database with about 200 events at any given time. I'm trying to loop t

PHP error on MySQL insert
I'm sure it's the simplest of issues, but I can't recall why this isn't working.

Code: [Selec

Form help: Syntax & Logic
Hello again all,

I'm working on a form and ran into a wall (again) and can't seem to think th

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash