[libRETS-users] Strange Error

[Mark Klein]

On Dec 20, 2007, at 7:13 AM, Russ Perna wrote:

> I have one more question and I should be good to go. When I did my  
> other
> RETS boards, I was immediately able to parse the returned data by  
> field
> name, whereas here I am required to query by field number since  
> using the
> field name throws an error. I assume I have to match up the metadata
> somehow, but I'm not sure how I would go about doing this. Anyone  
> have any
> thoughts.

Hmmm ... It would be worth a look at the metadata, or even the  
<COLUMN> row from your resultset. Sounds like SystemName may contain  
numbers instead of names. I wondered about that when I saw your  
sample query. You can try using StandardName, but we both know what  
that means. :-)

Regards,


M.



> Thanks a lot to everyone for working me through our other issue.
>
> Thanks,
> Russ
>
>
>
> -----Original Message-----
> From: librets-users-bounces at crt.realtors.org
> [mailto:librets-users-bounces at crt.realtors.org] On Behalf Of Mark  
> Klein
> Sent: Wednesday, December 19, 2007 10:52 PM
> To: For discussion and help for and by the users of the libRETS C++  
> library
> Subject: Re: [libRETS-users] Strange Error
>
>
> On Dec 19, 2007, at 10:06 AM, Russ Perna wrote:
>
>> This is the request from RETS Connector:
>> URI:
>> /Search.asmx/Search?
>> SearchType=Property&Class=1&Select=217&Format=COMPACT&Qu
>> eryType=DMQL2&Query=(290=%7CACT),(40=%7C440)
>>
>> This is the request from libRets:
>> URI:
>> /Search.asmx/Search?Class=1&Count=1&Format=COMPACT&Query=(290%
>> 3dACT),(40%3d4
>> 40)&QueryType=DMQL2&SearchType=Property&Select=217&StandardNames=0
>
> Sorry for being late to the party. :-)
>
> I don't see in the thread whether or not you actually tried the proper
> lookup syntax. I would expect to see the query from librets to look  
> like:
>
> ...;Query=(290%3d%7cACT),(40%3d%7c440)...
>
> One thing to try is to attempt to issue this query from your favorite
> browser if possible (some servers will allow it, some won't). You  
> can also
> try it from cURL. Here is a sample using the crt demo server:
>
> http://demo.crt.realtors.org:6103/rets/login
>
> (use Joe for the user and Schmoe for the password)
>
> The next line may be wrapped, so you may need to untangle it ... it  
> should
> be one long line:
>
> http://demo.crt.realtors.org:6103/rets/search?
> Format=COMPACT&SearchType=Property&Class=ResidentialProperty&StandardN 
> am
> es=0&QueryType=DMQL&Query=(LN%3D1%2B)%2C(BATHS%3D3%2B)%2C(BEDROOMS%
> 3D3%2B)
>
> This should show 3 properties. Unfortunately, I can't demo this with a
> lookup.
>
> Try doing the same with your provider and see if the query works  
> outside of
> librets. That will help us get a better handle on things.
>
> Regards,
>
>
>
> M.
>
>
>
> --
> Mark Klein
> PGP Key Available
> www.dis.com
>
>
> _______________________________________________
> 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
>
>

--
Mark Klein
PGP Key Available
www.dis.com