function replaceString(cadena,antigua,nueva){
      var ino=0;
      do {
        ino=cadena.indexOf(antigua);
        if (ino>=0) cadena = cadena.substring(0,ino)+nueva+cadena.substring(ino+antigua.length);     
      } while (ino>=0); 
      return cadena;
}


function trim(str){

 str = str.replace(/^\s*|\s*$/g,"");
 return str; 
}

function makeDummy(){

   var DateC=new Date();
   return DateC.getTime(); 

}

function queryExec(Query,SpanD,Headers,Click,Done,Multioption){
    var queryCad=proccessQuery(Query);
    var queryFrame="queryExec.jsp?dummy="+makeDummy()+"&busqueda="+queryCad;
    if (Headers!="") queryFrame=queryFrame+"&header="+Headers;
    if (Click!="") queryFrame=queryFrame+"&onclick="+Click;
    if (Done!="") queryFrame=queryFrame+"&done="+Done;
    if (Multioption!="") queryFrame=queryFrame+"&multioption="+Multioption;

    //document.getElementById(SpanD).innerHTML=queryFrame; 
    //document.getElementById(SpanD).innerHTML="http://localhost:8080/hesfresenius/"+queryFrame;
    //alert(queryFrame);
    var frameSrc="<iframe frameborder='0' id='"+SpanD+"_id' name='"+SpanD+"_name' src='"+queryFrame+"'  width='100%' height='100%'></iframe>";
    document.getElementById(SpanD).innerHTML=frameSrc;
  


}

function queryExcel(Query,FrameD,Headers,Components,Click,Done,Select){
    var queryCad=proccessQuery(Query);
    var queryFrame="queryExcel.jsp?dummy="+makeDummy()+"&busqueda="+queryCad;
    if (Headers!="") queryFrame=queryFrame+"&header="+Headers;
    if (Click!="") queryFrame=queryFrame+"&onclick="+Click;
    if (Done!="") queryFrame=queryFrame+"&done="+Done;
    if (Select!="") queryFrame=queryFrame+"&onselect="+Select;
    if (Components!="") queryFrame=queryFrame+"&types="+Components;
     document.getElementById(FrameD).src=queryFrame;
}


function queryEx(Query,FrameD,Headers,Click,Done,Multioption){
    var queryCad=proccessQuery(Query);
    var queryFrame="queryExec.jsp?dummy="+makeDummy()+"&busqueda="+queryCad;
    if (Headers!="") queryFrame=queryFrame+"&header="+Headers;
    if (Click!="") queryFrame=queryFrame+"&onclick="+Click;
    if (Done!="") queryFrame=queryFrame+"&done="+Done;
    if (Multioption!="") queryFrame=queryFrame+"&multioption="+Multioption;
    document.getElementById(FrameD).src=queryFrame;
    //document.getElementById(SpanD).innerHTML=queryFrame; 
    //document.getElementById(SpanD).innerHTML="http://localhost:8080/hesfresenius/"+queryFrame;
    //var frameSrc="<iframe frameborder='0' id='"+SpanD+"_id' name='"+SpanD+"_name' src='"+queryFrame+"'  width='100%' height='100%'></iframe>";
    //document.getElementById(SpanD).innerHTML=frameSrc;
  


}


function proccessQuery(query){
   var myString=new String(query);
   var queryC=replaceString(myString,"@","~");
   queryC=replaceString(queryC,"%","@");
   queryC=replaceString(queryC,"?","%3F");
   queryC=replaceString(queryC,"#","%23");
   queryC=replaceString(queryC,":","%3A");
   queryC=replaceString(queryC,"=","%3D"); 
   //queryC=replaceString(queryC,"'","^"); 
   //alert("Proccess query :"+queryC);
   return queryC;

}


function deProccessQuery(query){
   var myString=new String(query);

   var queryC=replaceString(myString,"~","@");
   queryC=replaceString(queryC,"@","%"); 
   queryC=replaceString(queryC,"^","'"); 

   return queryC;

}




function queryExecute(Query,FrameD,Done){
    var queryCad=proccessQuery(Query);
    var queryFrame="queryExecute.jsp?dummy="+makeDummy()+"&busqueda="+queryCad;
    if (Done!="") queryFrame=queryFrame+"&done="+Done;
    //alert(queryFrame);
    document.getElementById(FrameD).src=queryFrame;
    
}



function queryUpdate(Query,FrameD,Done){
    var queryCad=proccessQuery(Query);
    var queryFrame="queryUpdate.jsp?dummy="+makeDummy()+"&";
    
    
    if (Done!="") queryFrame=queryFrame+"done="+Done+"&";
    queryFrame=queryFrame+"sql="+queryCad;

    //alert(queryFrame);
    //document.getElementById("results").innerHTML=queryFrame;

    /*
    var alMess=getVar("messageResult");
    if (alMess) { 
       getVar("messageResult").innerHTML="http://localhost:8080/hes2/"+queryFrame;
    }*/

    document.getElementById(FrameD).src=queryFrame;
   
}