[ezRETS-users] Need sample web base RETS search codes

[Keith T. Garner]

Simon,

Please read the SQL Reference that ships with ezRETS.  Your primary 
problem is that you are not providing a WHERE clause.  RETS does not 
have the concept of a query without a WHERE clause.

A WHERE clause that will work in the demo server is 'LP>0' or 
'ListPrice>0' depending on if you have StandardNames on or not.

Keith

On Mon, 12 Mar 2007 5:23 pm, Simon Sheu wrote:
> Hey Tony,
>
> Thanks for replying so quickly!  Yea, I already ran the test DNS 
> installer and saw the samples codes but they only have an  asp.NET 
> example but I just code in just plain old ASP 3.0.  I also couldn't get 
> the ASP page to display any data from the Test server. I am using 
> Dreamweaver and I was able to connect to the server but the dataset is 
> empty.   
>
> I also notice that when I use "Select * from 
> [data:Property:ResidentialProperty]" it always kicks back the brackets 
> "[" and "]" saying it's not proper SQL syntax. I had to remove them.
>
> Can you tell me what I am doing wrong with this code? I would really 
> appreicate if you can send me a sample page I can plug into my server 
> to get a response.
>
> my test page:
>
> <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
> <%
> Dim MM_conRETS_STRING
> MM_conRETS_STRING = "dsn=ezRETS;uid=Joe;pwd=Schmoe;"
>
> Dim Recordset1
> Dim Recordset1_cmd
> Dim Recordset1_numRows
>
> Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
> Recordset1_cmd.ActiveConnection = MM_conRETS_STRING
> Recordset1_cmd.CommandText = "SELECT * FROM 
> data:Property:ResidentialProperty"
> Recordset1_cmd.Prepared = true
>
> Set Recordset1 = Recordset1_cmd.Execute
> Recordset1_numRows = 0
> %>
>
> thanks
>
> On 3/12/07, Tony Russo <tonyrusso at bellsouth.net> wrote:
>
>> Hi Simon,
>>
>> See if this help:
>>
>> How to install and has test server credentials 
>> http://www.crt.realtors.org/projects/rets/ezrets/documentation/InstallTutorial/
>>
>> Code examples 
>> http://code.crt.realtors.org/projects/ezrets/wiki/UsageExamples
>>
>> Probably better for performance to download to your local database 
>> than doing a RETS query live, but that's just my opinion, I don't do 
>> live queries only back office downloads.
>>
>> Tony
>>
>> -----Original Message-----
>>
>> From: ezrets-users-bounces at crt.realtors.org 
>> [mailto:ezrets-users-bounces at crt.realtors.org] On Behalf Of Simon Sheu
>> Sent: Monday, March 12, 2007 4:49 PM
>> To: ezrets-users at crt.realtors.org
>> Subject: [ezRETS-users] Need sample web base RETS search codes
>>
>> Hello Everyone,
>>
>> I am trying to develop an browser-base Active Server Pages (ASP 3.0)  
>> project using ezRETS. This app will allow users to submit search 
>> queries to the RETS servers and return a listing of homes in a Results 
>> page with a picture and property descriptions. Similiar to Century 
>> 21 or RE/MAX's property searches on their websites.
>>
>> Can someone please give me a sample DSN Connection String (to some 
>> sort of test server, I'm not asking for personal info.) and a sample 
>> SQL string to pass it? I'm asking for this becasue I cannot seem to 
>> understand all the documentations on both the RETS and my MLS sites 
>> that seems to refer me back to the other and I'm really confused with 
>> everything now.
>>
>> I'm I going the right direction? Is it possible to query a RETS server 
>> with each search or do i have to pull down the dataset to my own 
>> server for users to search against?
>>
>> Thanks in advance for helping a lost soul!
>>
>> Simon
>>
>> _______________________________________________
>>
>> ezRETS-users mailing list
>> ezRETS-users at crt.realtors.org
>> http://mail.crt.realtors.org/mailman/listinfo/ezrets-users
>

--
Keith T. Garner                   kgarner at realtors.org
Managing Director - Center for REALTOR Technology
National Association of REALTORS
(From his mobile device)