[Rets-dev] More search problems on Rapattoni server

[Joey Marino]

On 4/7/07, Keith T. Garner <kgarner at crt.realtors.org> wrote:
>
> Joey Marino wrote:
> > I am having a problem creating legal dmql queries on a Rapattoni server
> > for string fields. I get the following error when trying to query Status
> > field:
> >  `Search': Invalid Query Syntax. The syntax for the field: Status does
> > not match its search type. (ArgumentError)
> > The metadata says the datatype for this field is character size 1, but
> > when I perform legal queries I get the whole status word returned to me.
>
> If you're requesting that the format be COMPACT-DECODED, it'll be expanded
> to the long version by the server.  If you only do COMPACT, you should get
> only the short version.
>
> > Maybe incorrect metadata?
> > I've tried the following in my query: (Status=A) (Status='A')
> > (Status="A") (Status=A*) (Status=Active) (Status='Active)
> > (Status="Active") I can't think of what I am doing wrong. Also would
> > anyone know where I could find documentation or BNF on DMQL2 Syntax?
>
> http://rets.org/documentation
>
> Check out the sections on the Search transaction in the RETS 1.5 and/or
> RETS
> 1.7 specifications.


I knew that BNF was there, I was just testing to see if you guys were paying
attention! =)

Keith
>
>
> --
>   Keith T. Garner - Managing Director - Center for REALTOR(r) Technology
>    kgarner at realtors.org - 312-329-3294 - http://blog.realtors.org/crt
>
> _______________________________________________
> Rets-dev mailing list
> Rets-dev at rets.org
> http://lists.rets.org/mailman/listinfo/rets-dev
>

Have you tried contacting Rapattoni?

Also, have you looked the the metadata? It is possible (actually it is
likely) that Status is a lookup. In which case you should probably have
Status=|A

That did it!! Thanks

In the most obvious place, the RETS 1.7document. Or in this case,
perhaps the RETS 1.5 document.

http://www.rets.org/files/retsproto1.7d6.pdf

http://www.rets.org/files/retsproto1.5e2.pdf

section 7.7 documents the BNF

Paul

-- 
Joey Marino
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.rets.org/pipermail/rets-dev/attachments/20070407/67be34a0/attachment.html