[ezRETS-users] City names?

[Keith T. Garner]

On 5/7/07 4:13 PM, Jack Burnish wrote:
> Still utterly stuck with Microsoft Query and Microsoft Query Wizard.  I'm
> really wishing I lived in 'Charlotte' or 'Raleigh' instead of 'Oak Island'.
> My guess is that it's the 'lookup' field.  With City in the 'SELECT'
> section, it returns the city names with no problem, its only when using it
> in the WHERE section of the statement that I run into problems.

Here's two advanced tricks we can do to find out if City is a lookup and
what the lookup values are.

1) Read
http://mail.crt.realtors.org/pipermail/ezrets-users/2007-February/000774.html

In your case, since you already know some .NET programming, the file at
http://code.crt.realtors.org/projects/librets/file/librets/trunk/project/swig/csharp/Metadata.cs
will be more useful to you.

2) Turn on Debug logging and do a query with a City you know works.
Depending on how the RETSQuery is formatted in the debug log will tell us if
its a lookup.

Keith

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