No Query (sqlString) given! You must pass this asp program a search query!

Example : sqlString=ActiveData~WHERE~Ecity~LIKE~"HONOLULU"~AND~price~>%~400000&orderby=ORDER+BY+price+ASC&TableName=ActiveData

Use the tilde(~) for spaces in the SQL Query

If you pass at least the tablename EXAMPLE: SearchResults.asp?tablename=ActiveData
the program will give you all the Table Field and Example values for each field.

You can click an existing table to see the fields available to you.

These are the Tables that exist in the database:

Lookup
Agents
Aux_City
Aux_SchoolElem
Aux_SchoolHigh
Aux_SchoolJunior
CustomSearchListBox
Office
PropertyLogs
Br_ResData
PrpDelete
Br_LndData
Br_LotData
Br_MulData
Br_RntData
Br_VirtualTours
Br_CndData
Br_ComData
dtproperties