Hi,
I have built a site where i display data from a contact table, to a .asp webpage. Next to each record is a checkbox (within the loop) which contains the contacts uniqueid.
What i have at the moment is the ability to check the first checkbox from the recordset and have that value insert in to a hidden text field, and there after any other checkboxes that are checked, will have the uniqueid added to the hiddenfield. However there are two issues with this.
1st: If the user doesn’t select the first checkbox on each page, the values do not get captured. The same applies on the following pages, this is obviously no good as the user might want to select everything other than the first record on each page, and that means no results are captured.
2nd: I also need the ability to click something (checkbox / link) and have all the checkboxes on a page ticked to save the manual process of going through each record. The problem with this is it does not capture any of the uniqueid's the way i have done it.
Could anyone offer me any help with this, it would be really appreciated.
JavaScript Value Capture: - Current code
Check all Checkboxes on the page: - Current code
Here is the rendered code for the page.
I have built a site where i display data from a contact table, to a .asp webpage. Next to each record is a checkbox (within the loop) which contains the contacts uniqueid.
What i have at the moment is the ability to check the first checkbox from the recordset and have that value insert in to a hidden text field, and there after any other checkboxes that are checked, will have the uniqueid added to the hiddenfield. However there are two issues with this.
1st: If the user doesn’t select the first checkbox on each page, the values do not get captured. The same applies on the following pages, this is obviously no good as the user might want to select everything other than the first record on each page, and that means no results are captured.
2nd: I also need the ability to click something (checkbox / link) and have all the checkboxes on a page ticked to save the manual process of going through each record. The problem with this is it does not capture any of the uniqueid's the way i have done it.
Could anyone offer me any help with this, it would be really appreciated.
JavaScript Value Capture: - Current code
Code:
var myvalue
function mytester(myvalue,myname){
tester='document.getElementById("'+myname+'").checked'
if (eval(tester))
{
if (document.results.compareitems.value=='')
{
document.results.compareitems.value=myvalue+'/'
//alert(myvalue)
}
else
{
document.results.compareitems.value = document.results.compareitems.value+myvalue+'/'
}
}
else
{
document.results.compareitems.value=document.results.compareitems.value.replace(','+myvalue+',', '');
}
}
Check all Checkboxes on the page: - Current code
Code:
function checkAll() {
var is_checked = document.results.checkbox.checked;
//alert(is_checked);
var cbs = document.results.elements["checkbox1863"];
for (var i=0; i<cbs.length; i++) {
cbs[i].checked = is_checked;
}
}
Here is the rendered code for the page.
Code:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>WiredContact Enterprise</title>
<script type="text/javascript">
function openTarget (form, features, windowName) {
if (!windowName)
windowName = 'formTarget' + (new Date().getTime());
form.target = windowName;
open ('', windowName, features);
}
function submitform(){
document.results2.submit()
return true;
}
function validate(){
// Validate if the user has selected select1 dropdown, if not tell the user to start from the first row.
if (mailerlookup.select1.value == "select"){
alert("To run a query you must use the first dropdown on the form")
return false;
}
document.mailerlookup.submit()
return true;
}
// Sets the userselect fields to 0 --- if a numeric field and operator field is selected to is blank.
function zerocorrection(){
if (mailerlookup.operator1.value == "" && mailerlookup.select1.value == "Rooms_From")
mailerlookup.userselect1.value = 0;
else if (mailerlookup.operator1.value == "" && mailerlookup.select1.value == "Rooms_To")
mailerlookup.userselect1.value = 0;
else if (mailerlookup.operator1.value == "" && mailerlookup.select1.value == "Price_From")
mailerlookup.userselect1.value = 0;
else if (mailerlookup.operator1.value == "" && mailerlookup.select1.value == "Price_To")
mailerlookup.userselect1.value = 0;
else if (mailerlookup.operator1.value == "" && mailerlookup.select1.value == "Price")
mailerlookup.userselect1.value = 0;
if (mailerlookup.operator2.value == "" && mailerlookup.select2.value == "Rooms_From")
mailerlookup.userselect2.value = 0;
else if (mailerlookup.operator2.value == "" && mailerlookup.select2.value == "Rooms_To")
mailerlookup.userselect2.value = 0;
else if (mailerlookup.operator2.value == "" && mailerlookup.select2.value == "Price_From")
mailerlookup.userselect2.value = 0;
else if (mailerlookup.operator2.value == "" && mailerlookup.select2.value == "Price_To")
mailerlookup.userselect2.value = 0;
else if (mailerlookup.operator2.value == "" && mailerlookup.select2.value == "Price")
mailerlookup.userselect2.value = 0;
if (mailerlookup.operator3.value == "" && mailerlookup.select3.value == "Rooms_From")
mailerlookup.userselect3.value = 0;
else if (mailerlookup.operator3.value == "" && mailerlookup.select3.value == "Rooms_To")
mailerlookup.userselect3.value = 0;
else if (mailerlookup.operator3.value == "" && mailerlookup.select3.value == "Price_From")
mailerlookup.userselect3.value = 0;
else if (mailerlookup.operator3.value == "" && mailerlookup.select3.value == "Price_To")
mailerlookup.userselect3.value = 0;
else if (mailerlookup.operator3.value == "" && mailerlookup.select3.value == "Price")
mailerlookup.userselect3.value = 0;
if (mailerlookup.operator4.value == "" && mailerlookup.select4.value == "Rooms_From")
mailerlookup.userselect4.value = 0;
else if (mailerlookup.operator4.value == "" && mailerlookup.select4.value == "Rooms_To")
mailerlookup.userselect4.value = 0;
else if (mailerlookup.operator4.value == "" && mailerlookup.select4.value == "Price_From")
mailerlookup.userselect4.value = 0;
else if (mailerlookup.operator4.value == "" && mailerlookup.select4.value == "Price_To")
mailerlookup.userselect4.value = 0;
else if (mailerlookup.operator4.value == "" && mailerlookup.select4.value == "Price")
mailerlookup.userselect4.value = 0;
if (mailerlookup.operator5.value == "" && mailerlookup.select5.value == "Rooms_From")
mailerlookup.userselect5.value = 0;
else if (mailerlookup.operator5.value == "" && mailerlookup.select5.value == "Rooms_To")
mailerlookup.userselect5.value = 0;
else if (mailerlookup.operator5.value == "" && mailerlookup.select5.value == "Price_From")
mailerlookup.userselect5.value = 0;
else if (mailerlookup.operator5.value == "" && mailerlookup.select5.value == "Price_To")
mailerlookup.userselect5.value = 0;
else if (mailerlookup.operator5.value == "" && mailerlookup.select5.value == "Price")
mailerlookup.userselect5.value = 0;
if (mailerlookup.operator6.value == "" && mailerlookup.select6.value == "Rooms_From")
mailerlookup.userselect6.value = 0;
else if (mailerlookup.operator6.value == "" && mailerlookup.select6.value == "Rooms_To")
mailerlookup.userselect6.value = 0;
else if (mailerlookup.operator6.value == "" && mailerlookup.select6.value == "Price_From")
mailerlookup.userselect6.value = 0;
else if (mailerlookup.operator6.value == "" && mailerlookup.select6.value == "Price_To")
mailerlookup.userselect6.value = 0;
else if (mailerlookup.operator6.value == "" && mailerlookup.select6.value == "Price")
mailerlookup.userselect6.value = 0;
if (mailerlookup.operator7.value == "" && mailerlookup.select7.value == "Rooms_From")
mailerlookup.userselect7.value = 0;
else if (mailerlookup.operator7.value == "" && mailerlookup.select7.value == "Rooms_To")
mailerlookup.userselect7.value = 0;
else if (mailerlookup.operator7.value == "" && mailerlookup.select7.value == "Price_From")
mailerlookup.userselect7.value = 0;
else if (mailerlookup.operator7.value == "" && mailerlookup.select7.value == "Price_To")
mailerlookup.userselect7.value = 0;
else if (mailerlookup.operator7.value == "" && mailerlookup.select7.value == "Price")
mailerlookup.userselect7.value = 0;
if (mailerlookup.operator8.value == "" && mailerlookup.select8.value == "Rooms_From")
mailerlookup.userselect8.value = 0;
else if (mailerlookup.operator8.value == "" && mailerlookup.select8.value == "Rooms_To")
mailerlookup.userselect8.value = 0;
else if (mailerlookup.operator8.value == "" && mailerlookup.select8.value == "Price_From")
mailerlookup.userselect8.value = 0;
else if (mailerlookup.operator8.value == "" && mailerlookup.select8.value == "Price_To")
mailerlookup.userselect8.value = 0;
else if (mailerlookup.operator8.value == "" && mailerlookup.select8.value == "Price")
mailerlookup.userselect8.value = 0;
if (mailerlookup.operator9.value == "" && mailerlookup.select9.value == "Rooms_From")
mailerlookup.userselect9.value = 0;
else if (mailerlookup.operator9.value == "" && mailerlookup.select9.value == "Rooms_To")
mailerlookup.userselect9.value = 0;
else if (mailerlookup.operator9.value == "" && mailerlookup.select9.value == "Price_From")
mailerlookup.userselect9.value = 0;
else if (mailerlookup.operator9.value == "" && mailerlookup.select9.value == "Price_To")
mailerlookup.userselect9.value = 0;
else if (mailerlookup.operator9.value == "" && mailerlookup.select9.value == "Price")
mailerlookup.userselect9.value = 0;
if (mailerlookup.operator10.value == "" && mailerlookup.select10.value == "Rooms_From")
mailerlookup.userselect10.value = 0;
else if (mailerlookup.operator10.value == "" && mailerlookup.select10.value == "Rooms_To")
mailerlookup.userselect10.value = 0;
else if (mailerlookup.operator10.value == "" && mailerlookup.select10.value == "Price_From")
mailerlookup.userselect10.value = 0;
else if (mailerlookup.operator10.value == "" && mailerlookup.select10.value == "Price_To")
mailerlookup.userselect10.value = 0;
else if (mailerlookup.operator10.value == "" && mailerlookup.select10.value == "Price")
mailerlookup.userselect10.value = 0;
if (mailerlookup.operator11.value == "" && mailerlookup.select11.value == "Rooms_From")
mailerlookup.userselect11.value = 0;
else if (mailerlookup.operator11.value == "" && mailerlookup.select11.value == "Rooms_To")
mailerlookup.userselect11.value = 0;
else if (mailerlookup.operator11.value == "" && mailerlookup.select11.value == "Price_From")
mailerlookup.userselect11.value = 0;
else if (mailerlookup.operator11.value == "" && mailerlookup.select11.value == "Price_To")
mailerlookup.userselect11.value = 0;
else if (mailerlookup.operator11.value == "" && mailerlookup.select11.value == "Price")
mailerlookup.userselect11.value = 0;
if (mailerlookup.operator12.value == "" && mailerlookup.select12.value == "Rooms_From")
mailerlookup.userselect12.value = 0;
else if (mailerlookup.operator12.value == "" && mailerlookup.select12.value == "Rooms_To")
mailerlookup.userselect12.value = 0;
else if (mailerlookup.operator12.value == "" && mailerlookup.select12.value == "Price_From")
mailerlookup.userselect12.value = 0;
else if (mailerlookup.operator12.value == "" && mailerlookup.select12.value == "Price_To")
mailerlookup.userselect12.value = 0;
else if (mailerlookup.operator12.value == "" && mailerlookup.select12.value == "Price")
mailerlookup.userselect12.value = 0;
return false;
}
// Sets the and or dropdown to AND if the user forgets to select it.
function andor() {
if (mailerlookup.select2.value != "select" )
mailerlookup.andor1.value = "AND";
else if (mailerlookup.select2.value = "select" )
mailerlookup.andor1.value = "";
if (mailerlookup.select3.value != "select" )
mailerlookup.andor2.value = "AND";
else if (mailerlookup.select3.value = "select" )
mailerlookup.andor2.value = "";
if (mailerlookup.select4.value != "select" )
mailerlookup.andor3.value = "AND";
else if (mailerlookup.select4.value = "select" )
mailerlookup.andor3.value = "";
if (mailerlookup.select5.value != "select" )
mailerlookup.andor4.value = "AND";
else if (mailerlookup.select5.value = "select" )
mailerlookup.andor4.value = "";
if (mailerlookup.select6.value != "select" )
mailerlookup.andor5.value = "AND";
else if (mailerlookup.select6.value = "select" )
mailerlookup.andor5.value = "";
if (mailerlookup.select7.value != "select" )
mailerlookup.andor6.value = "AND";
else if (mailerlookup.select7.value = "select" )
mailerlookup.andor6.value = "";
if (mailerlookup.select8.value != "select" )
mailerlookup.andor7.value = "AND";
else if (mailerlookup.select8.value = "select" )
mailerlookup.andor7.value = "";
if (mailerlookup.select9.value != "select" )
mailerlookup.andor8.value = "AND";
else if (mailerlookup.select9.value = "select" )
mailerlookup.andor8.value = "";
if (mailerlookup.select10.value != "select" )
mailerlookup.andor9.value = "AND";
else if (mailerlookup.select10.value = "select" )
mailerlookup.andor9.value = "";
if (mailerlookup.select11.value != "select" )
mailerlookup.andor10.value = "AND";
else if (mailerlookup.select11.value = "select" )
mailerlookup.andor10.value = "";
if (mailerlookup.select12.value != "select" )
mailerlookup.andor11.value = "AND";
else if (mailerlookup.select12.value = "select" )
mailerlookup.andor11.value = "";
return false;
}
function checkAll() {
var is_checked = document.results.checkbox.checked;
//alert(is_checked);
var cbs = document.results.elements["checkbox1863"];
for (var i=0; i<cbs.length; i++) {
cbs[i].checked = is_checked;
}
}
var myvalue
function mytester(myvalue,myname){
tester='document.getElementById("'+myname+'").checked'
if (eval(tester))
{
if (document.results.compareitems.value=='')
{
document.results.compareitems.value=myvalue+'/'
//alert(myvalue)
}
else
{
document.results.compareitems.value = document.results.compareitems.value+myvalue+'/'
}
}
else
{
document.results.compareitems.value=document.results.compareitems.value.replace(','+myvalue+',', '');
}
}
</script>
<style type="text/css">
table.results td
{ font-family: Verdana;
font-weight: normal;
font-size: 11px;
color: #404040;
background-color: #fafafa;
border: 0px #6699CC solid;
border-collapse: collapse;
border-spacing: 0px;
margin-top: 0px;}
table.query td
{ font-family: Verdana;
font-weight: normal;
font-size: 11px;
color: #404040;
background-color: #F7EFCE;
border: 0px #6699CC solid;
border-collapse: collapse;
border-spacing: 2px;
margin-top: 0px;}
A:link {text-decoration: none; color: #ff3300;}
A:visited {text-decoration: none; color: #ff3300;}
A:active {text-decoration: none; color: #ff3300;}
A:hover {text-decoration: none; color: #0099cc;}
.btn {
color: #900;
background: #F7EFCE;
font-weight: bold;
border: 1px solid #900;
}
</style>
</head>
<body bgcolor="#F7EFCE" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form name="mailerlookup" method="post" action="MailerLookup.asp">
<table width="55%" border="0" class="query" cellspacing="2" cellpadding="2">
<tr>
<td colspan="5"><h3>Lookup Mailer</h3></td>
</tr>
<tr>
<td colspan="5"><hr /></td>
</tr>
<tr>
<td colspan="1" align="center"><b><a href="Mailer.asp">Create new Mailer</a></b></td>
<td colspan="1" align="center"><b>|</b></td>
<td colspan="1" align="center"><b><a href="AttachToMailer.asp?type=reviewMailers" target="_blank">Mailer
Library</a></b></td>
<td colspan="1" align="center"><b>|</b></td>
<td colspan="1" align="center"><b><a href="MailerReports.asp" target="_self">Mailer Stats</a></b></td>
</tr>
<tr>
<td colspan="5"><hr /></td>
</tr>
</table>
<table width="45%" border="0" class="query" cellspacing="2" cellpadding="2">
<tr>
<td colspan="4"> </td>
</tr>
<tr>
<td colspan="2" class=ContactBoldText align="center">Field</td>
<td class=ContactBoldText>Operator</td>
<td align="right"class=ContactBoldText>And / Or</td>
</tr>
<tr>
<td>NOT:<input type="checkbox" name="not1" /></td>
<td>
<select name="select1">
<option value="select"></option>
<option value="TypeofHome">Type of Home</option>
<option value="Contact_Type">Contact Type</option>
<option value="Rooms_From">Rooms From</option>
<option value="idstatus">Ref Num</option>
<option value="Rooms_To">Rooms To</option>
<option value="Price_From">Price From</option>
<option value="Price_To">Price To</option>
<option value="Price">Price</option>
<option value="Geography">Geography</option>
<option value="Applicant_Status">Applicant Status</option>
<option value="Details_To_Email">Details To Email</option>
</select>
</td>
<td>
<select name="operator1">
<option value="selectoperator1"></option>
<option value="=">Equal</option>
<option value="contains">Contains</option>
<option value=">=">Greater Than</option>
<option value="<=">Less Than</option>
<option value="startswith">Starts With</option>
<option value="">Is Blank</option>
</select>
</td>
<td>
<input type="text" size="50" name="userselect1" /> <select name="andor1"><option
value=""></option><option value="AND">AND</option><option value="OR">OR</option></select>
</td>
</tr>
<tr>
<td>NOT:<input type="checkbox" name="not2" /></td>
<td>
<select name="select2" onBlur="andor()">
<option value="select"></option>
<option value="TypeofHome">Type of Home</option>
<option value="Contact_Type">Contact Type</option>
<option value="idstatus">Ref Num</option>
<option value="Rooms_From">Rooms From</option>
<option value="Rooms_To">Rooms To</option>
<option value="Price_From">Price From</option>
<option value="Price_To">Price To</option>
<option value="Price">Price</option>
<option value="Geography">Geography</option>
<option value="Applicant_Status">Applicant Status</option>
<option value="Details_To_Email">Details To Email</option>
</select>
</td>
<td>
<select name="operator2">
<option value="selectoperator2"></option>
<option value="=">Equal</option>
<option value="contains">Contains</option>
<option value=">=">Greater Than</option>
<option value="<=">Less Than</option>
<option value="startswith">Starts With</option>
<option value="">Is Blank</option>
</select>
</td>
<td>
<input type="text" size="50" name="userselect2" /> <select name="andor2"><option
value=""></option><option value="AND">AND</option><option value="OR">OR</option></select>
</td>
</tr>
<tr>
<td>NOT:<input type="checkbox" name="not3" /></td>
<td>
<select name="select3" onBlur="andor()">
<option value="select"></option>
<option value="TypeofHome">Type of Home</option>
<option value="Contact_Type">Contact Type</option>
<option value="idstatus">Ref Num</option>
<option value="Rooms_From">Rooms From</option>
<option value="Rooms_To">Rooms To</option>
<option value="Price_From">Price From</option>
<option value="Price_To">Price To</option>
<option value="Price">Price</option>
<option value="Geography">Geography</option>
<option value="Applicant_Status">Applicant Status</option>
<option value="Details_To_Email">Details To Email</option>
</select>
</td>
<td>
<select name="operator3">
<option value="selectoperator3"></option>
<option value="=">Equal</option>
<option value="contains">Contains</option>
<option value=">=">Greater Than</option>
<option value="<=">Less Than</option>
<option value="startswith">Starts With</option>
<option value="">Is Blank</option>
</select>
</td>
<td>
<input type="text" size="50" name="userselect3" /> <select name="andor3"><option
value=""></option><option value="AND">AND</option><option value="OR">OR</option></select>
</td>
</tr>
<tr>
<td>NOT:<input type="checkbox" name="not4" /></td>
<td>
<select name="select4" onBlur="andor()">
<option value="select"></option>
<option value="TypeofHome">Type of Home</option>
<option value="Contact_Type">Contact Type</option>
<option value="idstatus">Ref Num</option>
<option value="Rooms_From">Rooms From</option>
<option value="Rooms_To">Rooms To</option>
<option value="Price_From">Price From</option>
<option value="Price_To">Price To</option>
<option value="Price">Price</option>
<option value="Geography">Geography</option>
<option value="Applicant_Status">Applicant Status</option>
<option value="Details_To_Email">Details To Email</option>
</select>
</td>
<td>
<select name="operator4">
<option value="selectoperator4"></option>
<option value="=">Equal</option>
<option value="contains">Contains</option>
<option value=">=">Greater Than</option>
<option value="<=">Less Than</option>
<option value="startswith">Starts With</option>
<option value="">Is Blank</option>
</select>
</td>
<td>
<input type="text" size="50" name="userselect4" /> <select name="andor4"><option
value=""></option><option value="AND">AND</option><option value="OR">OR</option></select>
</td>
</tr>
<tr>
<td>NOT:<input type="checkbox" name="not5" /></td>
<td>
<select name="select5" onBlur="andor()">
<option value="select"></option>
<option value="TypeofHome">Type of Home</option>
<option value="Contact_Type">Contact Type</option>
<option value="idstatus">Ref Num</option>
<option value="Rooms_From">Rooms From</option>
<option value="Rooms_To">Rooms To</option>
<option value="Price_From">Price From</option>
<option value="Price_To">Price To</option>
<option value="Price">Price</option>
<option value="Geography">Geography</option>
<option value="Applicant_Status">Applicant Status</option>
<option value="Details_To_Email">Details To Email</option>
</select>
</td>
<td>
<select name="operator5">
<option value="selectoperator5"></option>
<option value="=">Equal</option>
<option value="contains">Contains</option>
<option value=">=">Greater Than</option>
<option value="<=">Less Than</option>
<option value="startswith">Starts With</option>
<option value="">Is Blank</option>
</select>
</td>
<td>
<input type="text" size="50" name="userselect5" /> <select name="andor5"><option
value=""></option><option value="AND">AND</option><option value="OR">OR</option></select>
</td>
</tr>
<tr>
<td>NOT:<input type="checkbox" name="not6" /></td>
<td>
<select name="select6" onBlur="andor()">
<option value="select"></option>
<option value="TypeofHome">Type of Home</option>
<option value="Contact_Type">Contact Type</option>
<option value="idstatus">Ref Num</option>
<option value="Rooms_From">Rooms From</option>
<option value="Rooms_To">Rooms To</option>
<option value="Price_From">Price From</option>
<option value="Price_To">Price To</option>
<option value="Price">Price</option>
<option value="Geography">Geography</option>
<option value="Applicant_Status">Applicant Status</option>
<option value="Details_To_Email">Details To Email</option>
</select>
</td>
<td>
<select name="operator6">
<option value="selectoperator6"></option>
<option value="=">Equal</option>
<option value="contains">Contains</option>
<option value=">=">Greater Than</option>
<option value="<=">Less Than</option>
<option value="startswith">Starts With</option>
<option value="">Is Blank</option>
</select>
</td>
<td>
<input type="text" size="50" name="userselect6" /> <select name="andor6"><option
value=""></option><option value="AND">AND</option><option value="OR">OR</option></select>
</td>
</tr>
<tr>
<td>NOT:<input type="checkbox" name="not7" /></td>
<td>
<select name="select7" onBlur="andor()">
<option value="select"></option>
<option value="TypeofHome">Type of Home</option>
<option value="Contact_Type">Contact Type</option>
<option value="idstatus">Ref Num</option>
<option value="Rooms_From">Rooms From</option>
<option value="Rooms_To">Rooms To</option>
<option value="Price_From">Price From</option>
<option value="Price_To">Price To</option>
<option value="Price">Price</option>
<option value="Geography">Geography</option>
<option value="Applicant_Status">Applicant Status</option>
<option value="Details_To_Email">Details To Email</option>
</select>
</td>
<td>
<select name="operator7">
<option value="selectoperator7"></option>
<option value="=">Equal</option>
<option value="contains">Contains</option>
<option value=">=">Greater Than</option>
<option value="<=">Less Than</option>
<option value="startswith">Starts With</option>
<option value="">Is Blank</option>
</select>
</td>
<td>
<input type="text" size="50" name="userselect7" /> <select name="andor7"><option
value=""></option><option value="AND">AND</option><option value="OR">OR</option></select>
</td>
</tr>
<tr>
<td>NOT:<input type="checkbox" name="not8" /></td>
<td>
<select name="select8" onBlur="andor()">
<option value="select"></option>
<option value="TypeofHome">Type of Home</option>
<option value="Contact_Type">Contact Type</option>
<option value="idstatus">Ref Num</option>
<option value="Rooms_From">Rooms From</option>
<option value="Rooms_To">Rooms To</option>
<option value="Price_From">Price From</option>
<option value="Price_To">Price To</option>
<option value="Price">Price</option>
<option value="Geography">Geography</option>
<option value="Applicant_Status">Applicant Status</option>
<option value="Details_To_Email">Details To Email</option>
</select>
</td>
<td>
<select name="operator8">
<option value="selectoperator8"></option>
<option value="=">Equal</option>
<option value="contains">Contains</option>
<option value=">=">Greater Than</option>
<option value="<=">Less Than</option>
<option value="startswith">Starts With</option>
<option value="">Is Blank</option>
</select>
</td>
<td>
<input type="text" size="50" name="userselect8" /> <select name="andor8"><option
value=""></option><option value="AND">AND</option><option value="OR">OR</option></select>
</td>
</tr>
<tr>
<td>NOT:<input type="checkbox" name="not9" /></td>
<td>
<select name="select9" onBlur="andor()">
<option value="select"></option>
<option value="TypeofHome">Type of Home</option>
<option value="Contact_Type">Contact Type</option>
<option value="idstatus">Ref Num</option>
<option value="Rooms_From">Rooms From</option>
<option value="Rooms_To">Rooms To</option>
<option value="Price_From">Price From</option>
<option value="Price_To">Price To</option>
<option value="Price">Price</option>
<option value="Geography">Geography</option>
<option value="Applicant_Status">Applicant Status</option>
<option value="Details_To_Email">Details To Email</option>
</select>
</td>
<td>
<select name="operator9">
<option value="selectoperator9"></option>
<option value="=">Equal</option>
<option value="contains">Contains</option>
<option value=">=">Greater Than</option>
<option value="<=">Less Than</option>
<option value="startswith">Starts With</option>
<option value="">Is Blank</option>
</select>
</td>
<td>
<input type="text" size="50" name="userselect9" /> <select name="andor9"><option
value=""></option><option value="AND">AND</option><option value="OR">OR</option></select>
</td>
</tr>
<tr>
<td>NOT:<input type="checkbox" name="not10" /></td>
<td>
<select name="select10" onBlur="andor()">
<option value="select"></option>
<option value="TypeofHome">Type of Home</option>
<option value="Contact_Type">Contact Type</option>
<option value="idstatus">Ref Num</option>
<option value="Rooms_From">Rooms From</option>
<option value="Rooms_To">Rooms To</option>
<option value="Price_From">Price From</option>
<option value="Price_To">Price To</option>
<option value="Price">Price</option>
<option value="Geography">Geography</option>
<option value="Applicant_Status">Applicant Status</option>
<option value="Details_To_Email">Details To Email</option>
</select>
</td>
<td>
<select name="operator10">
<option value="selectoperator6"></option>
<option value="=">Equal</option>
<option value="contains">Contains</option>
<option value=">=">Greater Than</option>
<option value="<=">Less Than</option>
<option value="startswith">Starts With</option>
<option value="">Is Blank</option>
</select>
</td>
<td>
<input type="text" size="50" name="userselect10" /> <select name="andor10"><option
value=""></option><option value="AND">AND</option><option value="OR">OR</option></select>
</td>
</tr>
<tr>
<td>NOT:<input type="checkbox" name="not11" /></td>
<td>
<select name="select11" onBlur="andor()">
<option value="select"></option>
<option value="TypeofHome">Type of Home</option>
<option value="Contact_Type">Contact Type</option>
<option value="idstatus">Ref Num</option>
<option value="Rooms_From">Rooms From</option>
<option value="Rooms_To">Rooms To</option>
<option value="Price_From">Price From</option>
<option value="Price_To">Price To</option>
<option value="Price">Price</option>
<option value="Geography">Geography</option>
<option value="Applicant_Status">Applicant Status</option>
<option value="Details_To_Email">Details To Email</option>
</select>
</td>
<td>
<select name="operator11">
<option value="selectoperator6"></option>
<option value="=">Equal</option>
<option value="contains">Contains</option>
<option value=">=">Greater Than</option>
<option value="<=">Less Than</option>
<option value="startswith">Starts With</option>
<option value="">Is Blank</option>
</select>
</td>
<td>
<input type="text" size="50" name="userselect11" /> <select name="andor11"><option
value=""></option><option value="AND">AND</option><option value="OR">OR</option></select>
</td>
</tr>
<tr>
<td>NOT:<input type="checkbox" name="not12" /></td>
<td>
<select name="select12" onBlur="andor()">
<option value="select"></option>
<option value="TypeofHome">Type of Home</option>
<option value="Contact_Type">Contact Type</option>
<option value="idstatus">Ref Num</option>
<option value="Rooms_From">Rooms From</option>
<option value="Rooms_To">Rooms To</option>
<option value="Price_From">Price From</option>
<option value="Price_To">Price To</option>
<option value="Price">Price</option>
<option value="Geography">Geography</option>
<option value="Applicant_Status">Applicant Status</option>
<option value="Details_To_Email">Details To Email</option>
</select>
</td>
<td>
<select name="operator12">
<option value="selectoperator12"></option>
<option value="=">Equal</option>
<option value="contains">Contains</option>
<option value=">=">Greater Than</option>
<option value="<=">Less Than</option>
<option value="startswith">Starts With</option>
<option value="">Is Blank</option>
</select>
</td>
<td>
<input type="text" size="50" name="userselect12" /> <!--<select name="andor12"><option
value=""></option><option value="AND">AND</option><option value="OR">OR</option></select>-->
</td>
</tr>
<tr>
<td colspan="3" align="left">Select the sort field:
<select name="orderby">
<option value=""></option>
<option value="TypeofHome">Type of Home</option>
<option value="Contact_Type">Contact Type</option>
<option value="idstatus">Ref Num</option>
<option value="Rooms_From">Rooms From</option>
<option value="Rooms_To">Rooms To</option>
<option value="Price_From">Price From</option>
<option value="Price_To">Price To</option>
<option value="Price">Price</option>
<option value="Geography">Geography</option>
<option value="Applicant_Status">Applicant Status</option>
<option value="Details_To_Email">Details To Email</option>
</select> </td>
<td colspan="1" align="center"><input type="button" onFocus="zerocorrection();validate()" class="btn"
value="Run Query" /></td>
</tr>
<tr>
<td colspan="4"><hr /></td>
</tr>
</table>
</form>
<!--<form name="results" method="post" onSubmit="openTarget(this,
'width=400,height=400,resizable=1,scrollbars=1'); return true;" target="newpopup" action="pooh.asp?
type=SearchMailers">-->
<form name="results" method="post" action="AttachToMailer.asp?type=SearchMailers">
<!--<form name="results2" method="post" action="AttachToMailer.asp?type=SearchMailers">-->
<table width="90%" class="results">
<tr>
<td colspan="6"><input type="hidden" name="compareitems" /></td>
</tr>
<tr>
<td width="2%"> </td>
<td width="15%"><h6>Contact</h6></td>
<td width="10%"><h6>Rooms From</h6></td>
<td width="10%"><h6>Ref Num</h6></td>
<td width="10%"><h6>Price from</h6></td>
<td width="10%"><h6>Price</h6></td>
</tr>
Page: 1 of 1<tr><td bgcolor='#D0D0D0'><input type='checkbox' id='checkbox1863' name='checkbox1863'
value='_31-phCvRnbc' onClick='JavaScript:mytester(this.value,this.name)' /></td><td bgcolor='#D0D0D0'>N
Gregory</td><td bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>3422</td><td bgcolor='#D0D0D0'></td><td
bgcolor='#D0D0D0'>675000</td></tr><tr><td bgcolor='#D0D0D0'><input type='checkbox' id='checkbox1863'
name='checkbox1863' value='3i1,phf_Rnbc' onClick='JavaScript:mytester(this.value,this.name)' /></td><td
bgcolor='#D0D0D0'>P Moore</td><td bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>3122</td><td
bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>225000</td></tr><tr><td bgcolor='#D0D0D0'><input type='checkbox'
id='checkbox1863' name='checkbox1863' value='9d8,phXhRnbc' onClick='JavaScript:mytester(this.value,this.name)'
/></td><td bgcolor='#D0D0D0'>Julie Bell</td><td bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>3228</td><td
bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>675000</td></tr><tr><td bgcolor='#D0D0D0'><input type='checkbox'
id='checkbox1863' name='checkbox1863' value='AYG-ph(vRnbc' onClick='JavaScript:mytester(this.value,this.name)'
/></td><td bgcolor='#D0D0D0'>Valerie Wilson</td><td bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>3227</td><td
bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>1595000</td></tr><tr><td bgcolor='#D0D0D0'><input type='checkbox'
id='checkbox1863' name='checkbox1863' value='CsP,phlhRnbc' onClick='JavaScript:mytester(this.value,this.name)'
/></td><td bgcolor='#D0D0D0'>Paul Rollins</td><td bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>3622</td><td
bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>1400000</td></tr><tr><td bgcolor='#D0D0D0'><input type='checkbox'
id='checkbox1863' name='checkbox1863' value='e2k-ph6vRnbc' onClick='JavaScript:mytester(this.value,this.name)'
/></td><td bgcolor='#D0D0D0'>S / C Bowness</td><td bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>3221</td><td
bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>1560000</td></tr><tr><td bgcolor='#D0D0D0'><input type='checkbox'
id='checkbox1863' name='checkbox1863' value='egk-phlvRnbc' onClick='JavaScript:mytester(this.value,this.name)'
/></td><td bgcolor='#D0D0D0'>Michael & Catherine Fisher</td><td bgcolor='#D0D0D0'></td><td
bgcolor='#D0D0D0'>3223</td><td bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>695000</td></tr><tr><td
bgcolor='#D0D0D0'><input type='checkbox' id='checkbox1863' name='checkbox1863' value='HEb,pht_Rnbc'
onClick='JavaScript:mytester(this.value,this.name)' /></td><td bgcolor='#D0D0D0'>P E / M T Dawson</td><td
bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>3226</td><td bgcolor='#D0D0D0'></td><td
bgcolor='#D0D0D0'>3250000</td></tr><tr><td bgcolor='#D0D0D0'><input type='checkbox' id='checkbox1863'
name='checkbox1863' value='HWL-phcvRnbc' onClick='JavaScript:mytester(this.value,this.name)' /></td><td
bgcolor='#D0D0D0'>Simon & Janet Minns</td><td bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>3224</td><td
bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>650000</td></tr><tr><td bgcolor='#D0D0D0'><input type='checkbox'
id='checkbox1863' name='checkbox1863' value='ia6,phphRnbc' onClick='JavaScript:mytester(this.value,this.name)'
/></td><td bgcolor='#D0D0D0'>Paul Rollins</td><td bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>3622</td><td
bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'></td></tr><tr><td bgcolor='#D0D0D0'><input type='checkbox'
id='checkbox1863' name='checkbox1863' value='iZ9,phZhRnbc' onClick='JavaScript:mytester(this.value,this.name)'
/></td><td bgcolor='#D0D0D0'>Geoff Slater</td><td bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>3229</td><td
bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'></td></tr><tr><td bgcolor='#D0D0D0'><input type='checkbox'
id='checkbox1863' name='checkbox1863' value='kes-phSvRnbc' onClick='JavaScript:mytester(this.value,this.name)'
/></td><td bgcolor='#D0D0D0'>Malcom & Kathleen B Jackson</td><td bgcolor='#D0D0D0'></td><td
bgcolor='#D0D0D0'>3225</td><td bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>865000</td></tr><tr><td
bgcolor='#D0D0D0'><input type='checkbox' id='checkbox1863' name='checkbox1863' value='mtp1dtj3b0qagxga'
onClick='JavaScript:mytester(this.value,this.name)' /></td><td bgcolor='#D0D0D0'>D and A Easdown</td><td
bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>3722</td><td bgcolor='#D0D0D0'></td><td
bgcolor='#D0D0D0'>1600000</td></tr><tr><td bgcolor='#D0D0D0'><input type='checkbox' id='checkbox1863'
name='checkbox1863' value='-oB-ph)vRnbc' onClick='JavaScript:mytester(this.value,this.name)' /></td><td
bgcolor='#D0D0D0'>N Walley</td><td bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>3322</td><td
bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>1600000</td></tr><tr><td bgcolor='#D0D0D0'><input type='checkbox'
id='checkbox1863' name='checkbox1863' value='ruY,ph)hRnbc' onClick='JavaScript:mytester(this.value,this.name)'
/></td><td bgcolor='#D0D0D0'>Tony & Dawn Hill-Eades</td><td bgcolor='#D0D0D0'></td><td
bgcolor='#D0D0D0'>3522</td><td bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>1300000</td></tr><tr><td
bgcolor='#D0D0D0'><input type='checkbox' id='checkbox1863' name='checkbox1863' value='VQ_,ph_vRnbc'
onClick='JavaScript:mytester(this.value,this.name)' /></td><td bgcolor='#D0D0D0'>S & R / D Patel</td><td
bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>3220</td><td bgcolor='#D0D0D0'></td><td
bgcolor='#D0D0D0'>395000</td></tr><tr><td bgcolor='#D0D0D0'><input type='checkbox' id='checkbox1863'
name='checkbox1863' value='WaX-phUpRnbc' onClick='JavaScript:mytester(this.value,this.name)' /></td><td
bgcolor='#D0D0D0'>John & Marlene / Ronald / Jean Marshall</td><td bgcolor='#D0D0D0'></td><td
bgcolor='#D0D0D0'>3222</td><td bgcolor='#D0D0D0'></td><td bgcolor='#D0D0D0'>695000</td></tr><div align='right'>
<a href='#' onClick='window.location="/wirede/MailerLookup.asp?Query=&sqlquery=SELECT+%2A+FROM+wce%
5Fcontact+WHERE+idstatus+LIKE+%22per22per%22+&records=1&hiddenvalue="+encodeURIComponent
(document.results.compareitems.value)+""'>First Page</a> | <span style='color:silver;'>Previous Page</span> |
<span style='color:silver;'>Next Page</span> | <a href='#' onClick='window.location="/wirede/MailerLookup.asp?
Query=&sqlquery=SELECT+%2A+FROM+wce%5Fcontact+WHERE+idstatus+LIKE+%22per22per%
22+&records=1&hiddenvalue="+encodeURIComponent(document.results.compareitems.value)+""'>Last Page</a></div>
<tr>
<td colspan='6' align="right"><input type="checkbox" name="checkbox" onclick="checkAll()" ></td>
</tr>
<tr>
<!--<td colspan='3' align="right"><a href="#" onClick="myPopup()">Find Mailer to attach to selected
lookup</a></td>-->
<td colspan="6" align="center"><input type="Submit" onClick="submitform()" class="btn" value="Select
Mailer" /></td>
</tr>
</table>
</form>
</body>
</html>