<%
response.buffer = true
response.ExpiresAbsolute = Now() - 1
response.expires = 0
Response.CacheControl = "no-chache"
%>
|
|
|
|
|
 |
Our Appraisers |
|
 |
|
|
|
|
Expiration |
Years of |
|
Name |
License |
License # |
Date |
Experience |
<%
dim ssql,con,rs,appldir,mapPath,constr
appldir = Request.ServerVariables("APPL_PHYSICAL_PATH")
mapPath = "..\cgi-bin\appraisers.mdb"
Set Con = Server.CreateObject("ADODB.Connection")
Set Rs = Server.CreateObject("ADODB.RecordSet")
constr="PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & Server.MapPath(mapPath)
con.open(constr)
ssql = "select * from appraiser a, experience b "
ssql = ssql & " where a.appraiser_id = b.appraiser_id "
ssql = ssql & " order by lastname,firstname,uid"
set rs = con.execute(ssql)
response.write(ssql)
%>
|
|
|
|
Expiration |
Years of |
|
Name |
License |
License # |
Date |
Experience |