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

UDS 4.0 Datatype issue
UDS 4.0.322 -- connecting to NI Labview 9.0

When using connection method: Cache with live

Code doesn't print what i wanted it too. Please help!
Hi there,

I wrote this code to mae it so that in the form before it that the user said their

filesize() returns 0
I have a socket program that runs in an infinite loop, listening for connections, in this socket I h

Sorting JTable on more than just the values listed in the columns
I have a collection of objects that store (among other things) two integer values. I only want to di

include problem
I have my root folder as:
Code: $root = $_SERVER["SITE_HTMLROOT"]; // the server root<

Problems with array
This code is the last lines in an upload script that uploads 4 images at the same time and writes th

Calander Basic Spript help
hi, just starting out with PHP and have the following script:

<?php
//This gets t

Including calander to page - will not show other months than current??
im trying to add an existaing calander onto a profile page by using Code: <?php include "

PHP Redirecting
Hello everyone. Is there a way to redirect people to pages within a statement in PHP? Since there is

change text color with a jQuery code
Hihow can I change the text in a asp:TextBox to a different color when I start typing using jQuery?I

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