function FindRecord(inpaddr, inpzip){
try{
var strHtml ="";

//Database Connection
var adoConn = new ActiveXObject("ADODB.Connection");
var rs = new ActiveXObject("ADODB.Recordset");

var lookupstr = "";
//adoConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='//websource1w/d$/webdev2/WebServices/WO/Survey/RoundRock.mdb'");
//adoConn.Open("DSN=RoundRock;Uid=RR;Pwd=Tex@s");
adoConn.Open("Provider=sqloledb; Data Source=SQLENTERPRISEW\SQL2; Initial Catalog=RoundRockSurvey; User ID=RR;Password=Tex@s");

if (inpzip > "") { 
lookupstr="Zip like '%" + inpzip + "%'";
}
else {
lookupstr="Zip like '%'"; 
}

if (inpaddr > "") {
	lookupstr +=" AND Address like '%" + inpaddr + "%'"; 
}
else { 
lookupstr += " AND Address like '%'"; 
} 

rs.Open("Select Address, Zip, TaxableValue From tblProperty WHERE " + lookupstr, adoConn, 1, 3);

if(!rs.bof){

rs.MoveFirst();
while(!rs.eof) {

strHtml += rs.fields(0).value + " ";
strHtml += rs.fields(1).value + " VALUED AT: $";
strHtml += rs.fields(2).value + "\n\r ";

rs.MoveNext();
}
}
else{
//No Records.
strHtml += "No Records";
}
rs.Close();
adoConn.Close();

alert(strHtml);
}catch(ex){
alert(ex.message);
}
}
