[libRETS-users] SQL-Like Querying Rets db

[Keith T. Garner]

On 7/3/07 2:41 PM, Agustin Garzon wrote:
> Hey there!
> 
> I've noticed something interesting regarding this topic.
> If I don't disable StandardNames, as recommended by Mark and Keith, and
> I feed the StandardName "ResidentialProperty" (see metadata below) to
> the Class part in the query, I got an error stating:
> "The query Could not be executed because supplied login doesn't have
> access to the MLNumber field"
> Why the heck ?

That's probably because MLNumber doesn't exist in StandardNames mode.
MLNumber is probably the SystemName.  It probably has a different StandardName.

> Anyway, if I disable StandardNames, then everything seems to work fine.
> THANKS MATT! THANKS KEITH!

No problem.

> Finally, I would like to contribute recommending you to name the
> SearchRequest parameters in a way to visually identify if it's referring
> the ClassName or the StandardName.
> SearchRequest(string ResourceID, string ClassName, string Query);

I guess I'm not understanding what you're asking here.  The name could/would
be wrong depending on how you SetStandardNames.

As it is, the current naming in consistant with the RETS spec and the
terminology it uses within it for the Search operation.  I'd rather not move
away from that.

Keith

-- 
  Keith T. Garner - Managing Director - Center for REALTOR® Technology
   kgarner at realtors.org - 312-329-3294 - http://blog.realtors.org/crt