[ezRETS-users] City names?

[Jack Burnish]

Nope, still won't accept City as a criteria.

What I'm trying to create is separate Excel sheets where this page has
everything by X location, then the next one will have by Z location, etc.

So the SQL statement is basically

WHERE city = '"Boiling Spring Lakes"' AND MLNumber > 1

If I use just single quotes, then it tells me that there is an incorrect
syntax at |.  
If I use the SQDQ Blah Blah DQSQ syntax, its tells me it doesn't understand
and that you must have SOMETHING there in order for it to be read.
Apparently VS is reading the DQ and SQ as the same time of object and finds
nothing in between them.  So it only gets to SQDQ finds nothing there,
figures I must have goofed.  I get the same error using Microsoft Query in
Excel.

Shrugs,
Jack


-----Original Message-----
From: ezrets-users-bounces at crt.realtors.org
[mailto:ezrets-users-bounces at crt.realtors.org] On Behalf Of Keith T. Garner
Sent: Monday, May 07, 2007 1:26 PM
To: Support and talk for users of the ezRETS ODBC Driver
Subject: Re: [ezRETS-users] City names?

SQ == single quote
DQ == double quote (and sometimes yummy ice cream)

It should be SQDQBuffalo GroveDQSQ

By putting the double quotes inside the single quotes you work around a
quirk in the SQL to DMQL translator.  DMQL is the RETS query language, we
try to go from our subset of SQL to DMQL on the fly.

I thought we had put in fixes to work around this, but if the quoting like
this works, it's a good thing to go with.  I'll have to re-examine the code
path.

One other issue it could be is that the City name might be a RETS lookup.
This is one of the things that is difficult to communicate from RETS to
ODBC.  If it is a lookup, you need to know what the expected value for a
City would be from the RETS server.  There is no good way to communicate it
through ODBC.  In the future, ezRETS may support "metadata tables" that
allow you to examine the RETS metadata more fully and get the possible
values for a lookup.  However, this might not be the problem.

Keith

On 5/7/07 12:15 PM, Jack Burnish wrote:
> Just to confirm, that's  '"Buffalo Grove"' with " 'Buffalo Grove' "  
> 
> Just checking to make sure I have the order of the Quotation marks 
> correct
> 
> Jack
> 
> 
> -----Original Message-----
> From: ezrets-users-bounces at crt.realtors.org
> [mailto:ezrets-users-bounces at crt.realtors.org] On Behalf Of Tony Russo
> Sent: Monday, May 07, 2007 1:11 PM
> To: 'Support and talk for users of the ezRETS ODBC Driver'
> Subject: RE: [ezRETS-users] City names?
> 
> Hi Jack,
> 
> Try this, it works on the CRT demo site at 
> demo.crt.realtors.org:6103/rets/login
> 
> SELECT * FROM data:Property:ResidentialProperty WHERE City = '"Buffalo 
> Grove"' AND ListPrice >= 0;
> 
> Tony
>  
> -----Original Message-----
> From: ezrets-users-bounces at crt.realtors.org
> [mailto:ezrets-users-bounces at crt.realtors.org] On Behalf Of Jack 
> Burnish
> Sent: Monday, May 07, 2007 12:19 PM
> To: 'Support and talk for users of the ezRETS ODBC Driver'
> Subject: [ezRETS-users] City names?
> 
> What setting do I need to change, or how do I enter the city names in 
> a way that RETS understands?
> 
> For example.  'Southport'  works fine, however 'Oak Island' doesn't.  
> I'm assuming its cause of the space between the words, I just haven't 
> found the correct coding to represent the space.
>  
> Jack
> Port Realty, Inc.
> (910) 457-6711
> 
> _______________________________________________
> ezRETS-users mailing list
> ezRETS-users at crt.realtors.org
> http://mail.crt.realtors.org/mailman/listinfo/ezrets-users
> 
> 
> _______________________________________________
> ezRETS-users mailing list
> ezRETS-users at crt.realtors.org
> http://mail.crt.realtors.org/mailman/listinfo/ezrets-users
> 
> _______________________________________________
> ezRETS-users mailing list
> ezRETS-users at crt.realtors.org
> http://mail.crt.realtors.org/mailman/listinfo/ezrets-users


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

_______________________________________________
ezRETS-users mailing list
ezRETS-users at crt.realtors.org
http://mail.crt.realtors.org/mailman/listinfo/ezrets-users