First time here? Check out the FAQ!
0

Query no longer working

  • retag add tags

My programming makes a query each hour to retrieve new MLS entries. This query now returns zero records. I am not sure why it is doing this. Here's an example query.

$results = $rets->Search('Property', 'RE_1', "(L_Status=1_0),(L_UpdateDate=2016-03-31T14:22:18.3Z)");

Oddly, this query still works.

$results = $rets->Search('Property', 'RE_1', "(L_Status=1_0),(L_UpdateDate=2016-03-31T14:22:18.3Z)");

My username is billdunn

bildun's avatar
bildun
asked 2016-11-11 21:28:31 -0500
edit flag offensive 0 remove flag close merge delete

Comments

What MLS? Both of the queries you included are the same.

bwolven's avatar bwolven (2016-11-12 13:46:28 -0500) edit

West Ky mls.

bildun's avatar bildun (2016-11-12 19:13:37 -0500) edit
add a comment see more comments

1 Answer

0

I figured this out. A line in my code changed the time zone to a plus sign. When we changed from daylight savings time to standard time it messed my program up and lost the + at the end of the L_UpdateDate portion of the query that resulted in zero properties returned.

Sorry! Thank you for your assistance!

bildun's avatar
bildun
answered 2016-11-13 07:12:02 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

Your Answer

Login/Signup to Answer