[libRETS-users] Invalid Query Syntax
Bill Linker
blinker at ziprealty.com
Wed Dec 19 17:33:34 CST 2007
I am trying to add in a way of excluding listings with XML parse
errors...at least temporarily when waiting for the server to fix the
error. It took them 5 or 6 days to fix the last error I found, so I
would like to be able to just skip the bad listing(s) in the future.
However, I am getting an ArgumentOutOfRangeException (C#) with the
Message: "Invalid Query Syntax".
Here is the query:
"(LISTSTATUS=|ACT),(LISTPRICE=400001-470000),(MLSNUM=~1234567)"
However, based on the example given in the RETS 1.5 documentation this
looks valid to me. The target server is RETS version 1.5
Any ideas on what the problem is with my query? Or an alternate
solution? Thanks,
Bill
>From http://www.rets.org/files/retsproto1.5e2.pdf (page 49 in Adobe):
7.7.3 Sub-queries
This query language provides for a nesting of sub-queries. For example:
Query=((AREA=|1,2)|(CITY=ACTON)),(LP=200000+)
Example: Query=(ST=|ACT,S OLD),
(LP=200000-350 000),
(STR=RIV ER*),
(STYLE=RA NCH),
(EXT=+WTRFRNT,D OCK),
(LDATE=2000-03- 01+),
(REM=*FORECLO SE*),
(TYPE=~CONDO,TWN HME),
(OWNER=P?LE)
Verbally, this would be interpreted as "return properties with (ST equal
ACT or SOLD) and (LP between 200000 and 350000, inclusive) and (STR
beginning with RIVER) and (STYLE equal RANCH) and (EXT equal WTRFRNT and
DOCK) and (LDATE greater than or equal to 2000-03-01) and (REM
containing FORECLOSE) and (TYPE not equal to CONDO and not equal to
TWNHME) and (OWNER starting with P and having LE in the 3rd and 4th
characters)."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.crt.realtors.org/pipermail/librets-users/attachments/20071219/7647d7ab/attachment.html
More information about the libRETS-users
mailing list