function addNewClause(tbox, fbox1, fbox2) {
	var clause = "";
	var selCampo=0;
	var selOper=0;
	comodin="";

	if (fbox1.options.value != "puesto=" && fbox1.options.value != "examenrespondido.numExamen=" && fbox1.options.value != "empleado=" && fbox1.options.value != "escolaridadaplicante.areaEstudios=" && fbox1.options.value != "experiencialaboral.giroempresa="){
		if (fbox2.options.value ==" like ")
			comodin="%";
			else
			comodin="";

		if (fbox1.options[fbox1.options.selectedIndex].text == "Edad" || fbox1.options[fbox1.options.selectedIndex].text == "Sueldo deseado" || fbox1.options.selectedIndex > 36)
			comilla=" ";
			else
			comilla="'";

			clause=fbox1.options.value + fbox2.options.value + comilla + document.whereClause.whereValue.value + comodin + comilla + " and ";

	} else {

		if (fbox1.options.value == "puesto=")
			clause=fbox1.options.value + fbox2.options.value + " and ";
		else
			clause=fbox1.options.value + "'" + fbox2.options.value + "' and ";

	}


// validaciones especiales para campos que requieren mas SQL *********************************

	if( fbox1.options.value == "examenrespondido.fechaHora" || fbox1.options.value == "aplicante.fechaHora"){
		fecha = formatDate(new Date(getDateFromFormat(document.whereClause.whereValue.value,"dd/MM/yyyy")),"yyyy/MM/dd");
		if (fbox2.options.value == "=")
			clause= fbox1.options.value + " >= '" + fecha + " 00:00:00'" + " and " + fbox1.options.value + " <= '" + fecha + " 23:59:59' and ";
		else
			clause=fbox1.options.value + fbox2.options.value + "'" + fecha + "' and ";
	}

	if( fbox1.options.value == "idioma")
			clause="(idioma1 = '" + document.whereClause.whereValue.value + "' or idioma2 = '"+ document.whereClause.whereValue.value + "' or idioma3 = '"+ document.whereClause.whereValue.value + "') and ";

	if( fbox1.options.value == "sexo" || fbox1.options.value == "edocivil" || fbox1.options.value == "tieneComentarios")
			clause=fbox1.options.value + " = '" + document.whereClause.operation.value + "' and ";


// fin de validaciones especiales para campos que requieren mas SQL **************************



	var no = new Option();
	no.value = clause;
	if (fbox1.options[fbox1.options.selectedIndex].text == "Examen Respondido" || fbox1.options[fbox1.options.selectedIndex].text == "Puesto" || fbox1.options[fbox1.options.selectedIndex].text == "Status Laboral Actual" || fbox1.options[fbox1.options.selectedIndex].text == "Sexo" || fbox1.options[fbox1.options.selectedIndex].text == "Area de estudios" || fbox1.options[fbox1.options.selectedIndex].text == "Estado Civil" || fbox1.options[fbox1.options.selectedIndex].text == "Giro de la empresa" || fbox1.options[fbox1.options.selectedIndex].text == "Ver candidatos con comentarios" ){
		no.text = fbox1.options[fbox1.options.selectedIndex].text + ": '" + fbox2.options[fbox2.options.selectedIndex].text + "'";
		} else {
		no.text = fbox1.options[fbox1.options.selectedIndex].text + " " + fbox2.options[fbox2.options.selectedIndex].text + " '" + document.whereClause.whereValue.value + "'";
		}
	tbox.options[tbox.options.length] = no;
}




function ejecutaConsulta() {
var clauseFinal=""
var textoFinal=""

if (document.whereList.listClauses.options.length > 0) {

		for(var j=0; j<document.whereList.listClauses.options.length; j++ ){
			clauseFinal= clauseFinal + document.whereList.listClauses[j].value;
			textoFinal= textoFinal + document.whereList.listClauses[j].text + "<br>";
		}
		document.whereList.query.value = clauseFinal;
		document.whereList.queryTxt.value = textoFinal;
		//document.whereClause.field[0].selected=true;

		if (quienlollamo==0){
			htmlizquierdo="./instr2a.html";
			top.frames[1].location=htmlizquierdo;
		} else if (quienlollamo==1){
			htmlizquierdo="./instr3a.html";
			top.frames[1].location=htmlizquierdo;
		} else if (quienlollamo==2){
			document.whereList.action = "../Consultas/listaAplicantes.jsp"
			htmlizquierdo="../Consultas/instrucciones2.html";
			//top.frames[1].location=htmlizquierdo;
		} else if (quienlollamo==3){
			document.whereList.action = "../Usuarios/listaAplicantes.jsp"
		}

		document.whereList.submit();

} else {
	alert ("Necesita incluir algún filtro para poder continuar");
}

}


function checkdate(a){
//	window.onerror=null // for all other strange errors
	var err=0
	var psj=0;
//	a=document.whereClause.whereValue.value

	if (a.length != 10) err=1
	d = a.substring(0, 2)// día
	c = a.substring(2, 3)// '/'
	b = a.substring(3, 5)// mes
	e = a.substring(5, 6)// '/'
	f = a.substring(6, 10)// year

	//basic error checking
	if (b<1 || b>12) err = 1
	if (c != '/') err = 1
	if (d<1 || d>31) err = 1
	if (e != '/') err = 1
	if (f<0) err = 1

	//advanced error checking

	// months with 30 days
	if (b==4 || b==6 || b==9 || b==11){
		if (d==31) err=1
	}

	// february, leap year
	if (b==2){
		// feb
		var g=parseInt(f/4)
		if (isNaN(g)) {
			err=1
		}

		if (d>29) err=1
		if (d==29 && ((f/4)!=parseInt(f/4))) err=1
	}

	if (err==1){
		alert('¡¡ Fecha inválida !!  verifique por favor. ');
		//document.whereClause.whereValue.focus();
		return false;
	}
	else{
		return true;
	}

}



var MONTH_NAMES=new Array('January','February','March','April','May','June','July','August','September','October','November','December','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
function LZ(x) {return(x<0||x>9?"":"0")+x}


function formatDate(date,format) {
	format=format+"";
	var result="";
	var i_format=0;
	var c="";
	var token="";
	var y=date.getYear()+"";
	var M=date.getMonth()+1;
	var d=date.getDate();
	var H=date.getHours();
	var m=date.getMinutes();
	var s=date.getSeconds();
	var yyyy,yy,MMM,MM,dd,hh,h,mm,ss,ampm,HH,H,KK,K,kk,k;
	// Convert real date parts into formatted versions
	var value=new Object();
	if (y.length < 4) {y=""+(y-0+1900);}
	value["y"]=""+y;
	value["yyyy"]=y;
	value["yy"]=y.substring(2,4);
	value["M"]=M;
	value["MM"]=LZ(M);
	value["MMM"]=MONTH_NAMES[M-1];
	value["d"]=d;
	value["dd"]=LZ(d);
	value["H"]=H;
	value["HH"]=LZ(H);
	if (H==0){value["h"]=12;}
	else if (H>12){value["h"]=H-12;}
	else {value["h"]=H;}
	value["hh"]=LZ(value["h"]);
	if (H>11){value["K"]=H-12;} else {value["K"]=H;}
	value["k"]=H+1;
	value["KK"]=LZ(value["K"]);
	value["kk"]=LZ(value["k"]);
	if (H > 11) { value["a"]="PM"; }
	else { value["a"]="AM"; }
	value["m"]=m;
	value["mm"]=LZ(m);
	value["s"]=s;
	value["ss"]=LZ(s);
	while (i_format < format.length) {
		c=format.charAt(i_format);
		token="";
		while ((format.charAt(i_format)==c) && (i_format < format.length)) {
			token += format.charAt(i_format++);
			}
		if (value[token] != null) { result=result + value[token]; }
		else { result=result + token; }
		}
	return result;
	}



function borraElementos(){

cuantos=document.whereClause.operation.options.length

	for(var i=0; i<cuantos; i++) {
		document.whereClause.operation.options[0] = null;
		}
}

function borraFiltro(tbox) {
for(var i=0; i<tbox.options.length; i++) {
if(tbox.options[i].selected && tbox.options[i] != "") {
tbox.options[i] = null;
   }
}

}



function getDateFromFormat(val,format) {

	val=val+"";
	format=format+"";
	var i_val=0;
	var i_format=0;
	var c="";
	var token="";
	var token2="";
	var x,y;
	var now=new Date();
	var year=now.getYear();
	var month=now.getMonth()+1;
	var date=1;
	var hh=now.getHours();
	var mm=now.getMinutes();
	var ss=now.getSeconds();
	var ampm="";

	while (i_format < format.length) {
		// Get next token from format string
		c=format.charAt(i_format);
		token="";
		while ((format.charAt(i_format)==c) && (i_format < format.length)) {
			token += format.charAt(i_format++);
			}
		// Extract contents of value based on format token
		if (token=="yyyy" || token=="yy" || token=="y") {
			if (token=="yyyy") { x=4;y=4; }
			if (token=="yy")   { x=2;y=2; }
			if (token=="y")    { x=2;y=4; }
			year=_getInt(val,i_val,x,y);
			if (year==null) { return 0; }
			i_val += year.length;
			if (year.length==2) {
				if (year > 70) { year=1900+(year-0); }
				else { year=2000+(year-0); }
				}
			}
		else if (token=="MMM"){
			month=0;
			for (var i=0; i<MONTH_NAMES.length; i++) {
				var month_name=MONTH_NAMES[i];
				if (val.substring(i_val,i_val+month_name.length).toLowerCase()==month_name.toLowerCase()) {
					month=i+1;
					if (month>12) { month -= 12; }
					i_val += month_name.length;
					break;
					}
				}
			if ((month < 1)||(month>12)){return 0;}
			}
		else if (token=="MM"||token=="M") {
			month=_getInt(val,i_val,token.length,2);
			if(month==null||(month<1)||(month>12)){return 0;}
			i_val+=month.length;}
		else if (token=="dd"||token=="d") {
			date=_getInt(val,i_val,token.length,2);
			if(date==null||(date<1)||(date>31)){return 0;}
			i_val+=date.length;}
		else if (token=="hh"||token=="h") {
			hh=_getInt(val,i_val,token.length,2);
			if(hh==null||(hh<1)||(hh>12)){return 0;}
			i_val+=hh.length;}
		else if (token=="HH"||token=="H") {
			hh=_getInt(val,i_val,token.length,2);
			if(hh==null||(hh<0)||(hh>23)){return 0;}
			i_val+=hh.length;}
		else if (token=="KK"||token=="K") {
			hh=_getInt(val,i_val,token.length,2);
			if(hh==null||(hh<0)||(hh>11)){return 0;}
			i_val+=hh.length;}
		else if (token=="kk"||token=="k") {
			hh=_getInt(val,i_val,token.length,2);
			if(hh==null||(hh<1)||(hh>24)){return 0;}
			i_val+=hh.length;hh--;}
		else if (token=="mm"||token=="m") {
			mm=_getInt(val,i_val,token.length,2);
			if(mm==null||(mm<0)||(mm>59)){return 0;}
			i_val+=mm.length;}
		else if (token=="ss"||token=="s") {
			ss=_getInt(val,i_val,token.length,2);
			if(ss==null||(ss<0)||(ss>59)){return 0;}
			i_val+=ss.length;}
		else if (token=="a") {
			if (val.substring(i_val,i_val+2).toLowerCase()=="am") {ampm="AM";}
			else if (val.substring(i_val,i_val+2).toLowerCase()=="pm") {ampm="PM";}
			else {return 0;}
			i_val+=2;}
		else {
			if (val.substring(i_val,i_val+token.length)!=token) {return 0;}
			else {i_val+=token.length;}
			}
		}
	// If there are any trailing characters left in the value, it doesn't match
	if (i_val != val.length) { return 0; }
	// Is date valid for month?
	if (month==2) {
		// Check for leap year
		if ( ( (year%4==0)&&(year%100 != 0) ) || (year%400==0) ) { // leap year
			if (date > 29){ return false; }
			}
		else { if (date > 28) { return false; } }
		}
	if ((month==4)||(month==6)||(month==9)||(month==11)) {
		if (date > 30) { return false; }
		}
	// Correct hours value
	if (hh<12 && ampm=="PM") { hh=hh-0+12; }
	else if (hh>11 && ampm=="AM") { hh-=12; }
	var newdate=new Date(year,month-1,date,hh,mm,ss);
	return newdate.getTime();
	}


function _isInteger(val) {
	var digits="1234567890";
	for (var i=0; i < val.length; i++) {
		if (digits.indexOf(val.charAt(i))==-1) { return false; }
		}
	return true;
	}

function _getInt(str,i,minlength,maxlength) {
	for (var x=maxlength; x>=minlength; x--) {
		var token=str.substring(i,i+x);
		if (token.length < minlength) { return null; }
		if (_isInteger(token)) { return token; }
		}
	return null;
	}