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:

spt_monitor
spt_values
spt_fallback_db
spt_fallback_dev
spt_fallback_usg
Residential
ResidentialIncome
REMAX_RENT_dat
REMAX_DTQ_dat
REMAX_LAND_dat
REMAX_RES_dat
Analysis
Zip
Schools
RESI
Res
spt_provider_types
Lookup
Accounts
spt_datatype_info_ext
MSreplication_options
spt_datatype_info
spt_server_info