Ask Your Question

Query no longer working

asked 2016-11-11 21:28:31 -0600

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

edit retag flag offensive close merge delete


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

bwolven gravatar imagebwolven ( 2016-11-12 13:46:28 -0600 )edit

West Ky mls.

bildun gravatar imagebildun ( 2016-11-12 19:13:37 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2016-11-13 07:12:02 -0600

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!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-11-11 21:28:31 -0600

Seen: 444 times

Last updated: Nov 13 '16