[libRETS-users] Specific Order

[Tony Manhollan]

The SearchRequest object provides a method SetOffset() for this purpose.
However, I'm not sure that vendors are required to implement it, so it may
not work with your vendor.

One of the vendors I've worked with has a similar requirement: they limit
the number of results depending on how many fields the query returns. For
fewer than 4 fields, it has no record limit. What I do is get all the
records modified in a certain time period, returning only the MLNumber. Then
I request all fields for each of the records returned by the first query. I
execute the same query (e.g. MLNumber=1,2,3,4,5...&offset=0) recursively,
incrementing the offset by the record limit, until I have all the records.

See section 7.4.3-4 of the RETS 1.5 specification for information on the
limit and offset parameters.

Hope that helps.

Tony

> From: Russ Perna <russ.perna at prudentialrand.com>
> Reply-To: For discussion and help for and by the users of the libRETS C++
> library <librets-users at crt.realtors.org>
> Date: Mon, 15 Jan 2007 11:37:59 -0500
> To: 'For discussion and help for and by the users of the libRETS C++library'
> <librets-users at crt.realtors.org>
> Subject: RE: [libRETS-users] Specific Order
> 
> When I asked the MLS, I got a vague answer to the question, and I don't
> think they actually knew.
> 
> If you can't guarantee the sort order, can anyone tell me how they download
> their data when the MLS limits the download size?
> 
> Thanks,
> Russ
> 
> 
> Russ Perna
> --
> Webmaster
> Prudential Rand Realty
> http://www.prudentialrand.com
> 845.825.8036
>  
>  
> 
> -----Original Message-----
> From: librets-users-bounces at crt.realtors.org
> [mailto:librets-users-bounces at crt.realtors.org] On Behalf Of Dave Dribin
> Sent: Monday, January 15, 2007 11:25 AM
> To: For discussion and help for and by the users of the libRETS C++ library
> Subject: Re: [libRETS-users] Specific Order
> 
> 
> Hi Russ,
> 
> RETS has no sorting capabilities, and guarantees no order.  Just because you
> see an order on this one server does not mean that all servers do this.
> Heck, this one  vender could change the sort order tomorrow and still be
> within spec.
> 
> If you're working with one specific server, I suggest contacting their tech
> support to see if you can rely on the sort order.
> 
> -Dave
> 
> On Jan 15, 2007, at 9:08 AM, Russ Perna wrote:
>> Is there a specific order that records are returned in when doing a
>> search on a RETS server?
>> 
>> Our RETS server limits the amount of records that can be returned in a
>> specific query. So in order to download all of the records that were
>> updated since a specific date, it would help if I knew the order that
>> they were returned in, so that I could run multiple queries starting
>> sequentially after the last record returned. It seems that when
>> running a query that they are ordered by MLS number, but I just want
>> to verify this before I program for it.
>> 
>> Thanks for any help,
>> Russ
>> _______________________________________________
>> libRETS-users mailing list
>> libRETS-users at crt.realtors.org
>> http://mail.crt.realtors.org/mailman/listinfo/librets-users
> 
> _______________________________________________
> libRETS-users mailing list
> libRETS-users at crt.realtors.org
> http://mail.crt.realtors.org/mailman/listinfo/librets-users
> 
> 
> _______________________________________________
> libRETS-users mailing list
> libRETS-users at crt.realtors.org
> http://mail.crt.realtors.org/mailman/listinfo/librets-users



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.crt.realtors.org/pipermail/librets-users/attachments/20070115/301d6976/attachment.html