Connecting to RETS 1.7

[troydavisson]

Connecting to RETS 1.7

[troydavisson]

This could be lots of things. My first suggestion is to check the return of SearchQuery to see if it's false. If it is false, print_r($rets->Error()) and see what that says. It'll probably hint at bad syntax, unknown field, or not satisfying a search requirement in which case you might double check your parameters and field names included in your request and make sure they match what the server understands by looking at the metadata using retsmd.com

[thezenmonkey]

I'm getting Invalid Query Type (20203) my query string is
$query = "(Idx_dt=2012-10-31+),(Timestap_sql=00:00:00+)";

At this point in developemnt it may be more cost/time effecient to hire someone who knows phRETS, if you're interested or know anyone it would be great.

[troydavisson]

I'm going to guess that the cause is because either (or maybe both) Idx_dt and Timestap_sql are DateTime fields which means they require a full timestamp. RETS has those formatted like:

2012-12-07T16:53:17

If you look at the metadata using retsmd.com, you'll be able to tell the data type for those fields.

[thezenmonkey]

Thanks, looks like Idx_dt was just a the date while timestamp_sql was a full timestamp. The documentation provided by board was misleading.

Sent from my iPhone

On 2012-12-07, at 4:54 PM, Troy Davisson [email protected] wrote:

I'm going to guess that the cause is because either (or maybe both) Idx_dt and Timestap_sql are DateTime fields which means they require a full timestamp. RETS has those formatted like:

2012-12-07T16:53:17

If you look at the metadata using retsmd.com, you'll be able to tell the data type for those fields.

—
Reply to this email directly or view it on GitHub.