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

Display thumbnails as square while retaining aspect ratio
I am trying to figure out a way to make an image display as a square, for example 80x80 pixels, when

New Search Engine
Hey everyone,

I have a ZIP Code Radius search engine already functional. it displays all of t

SAP FICO learning materials
Hi all,
I am new to this world of SAP FICO. I have taken training on SAP FICO, but was wonderin

How do i use vars in an array
Hiya peeps!

How do I use a var in an array. You will see $id but it isnt working.

List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab

Members Only
Hi all, for my website i have a members area only which on members can veiw, but at the moment anyon

How to secure my login data to my database?
Hi there,

It may be a stupid question but I don't know how to secure my login data to my data

PHP webpage & array print issue
I have this code running, and it works perfectly … however, see my bottom bit about what I see

Final year project, please point me in the right direction
hi there for my final year project I'm aiming to build a php script shell to use as an expert system

why preg_match_all does not return the number of matches
My regex looks like

X[^x{4e00}-x{9fa5}]*Y

(where X and Y are two Chinese characters)