Retrieve data from database with radio button

 
0
 

Hello,
I need the jsp scripts to retrieve data of my radio button from database to my form which i have developed using jsp and connected to oracle database. Find below sample of my radio button code. Thank you

<td width="147" valign="middle"><input type="radio" name="biztype" id="biztype3" value="corporate" onclick="checko();"/>          Corporate/Limited</td>
        <td width="182" valign="middle"><input type="radio" name="biztype" id="biztype2" value="partnership" onclick="checko();"/>
          Partnership</td>
        <td width="254" valign="middle"><input type="radio" name="biztype" id="biztype1" value="other" onclick="checko();"/>
          Other 
		<input name="biztypeo" type="text" id="biztypeo" size="20" maxlength="20" disabled="disabled" value="<%=biztypeo%>"/></td>
 
0
 

ppomu,

Use bb code tags. Your source code must be surrounded with code tag. Read this How to use bb code tags?

I will be pleased if you give a hint about your program/page:
>Which web server are using? (name and version)
>Are there any jsp beans or database classes with your application?
--- Post source code of these classes and jsp page.

 
0
 

I have below the codes for my edit form where i have initialized the fields to retrieve data from my database but for the check boxes and radio button i am unable to do so. I think there should be an if else statement right, I have tried but its not working

I am using Oracle 9i database with a dbcon connection with websphere as webserver version 5.1.

Its very urgent can u plz give me a solution to this problem as i have to submit my website very soon, deadline is approaching
I am giving a hint of how my website link will be:

http://www.gov.mu/portal/*****/index.jsp (this will be the login page)

*********************************

<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <%@ page import="java.util.*" %> <%@ page import="oracle.jdbc.pool.*" %> <%@ include file ="dbcon.jsp"%> <% String username = ""; String password = ""; String password2 = ""; String namefirm = ""; String bizadd = ""; String address = ""; String telephone = ""; String fax = ""; String country = ""; String email = ""; String website = ""; String yearest = ""; String license = ""; String bizreg = ""; String vat = ""; String yearex = ""; String autho = ""; String noemp = ""; String tan = ""; String biztype = ""; String biztypeo=""; String typecons = ""; String typeconso = ""; String qualification = ""; String parent = ""; String relation = ""; String consultancy1 = ""; String consultancy2 = ""; String consultancy3 = ""; String consultancy4 = ""; String consultancy5 = ""; String consultancy6 = ""; String consultancy7 = ""; String consultancy8 = ""; String consultancy9 = ""; String consultancy10 = ""; String consultancy11 = ""; String consultancy12 = ""; String consultancy13 = ""; String othercons = ""; String turnoveryr1 = ""; String turnoveramt1 = ""; String turnoveryr2 = ""; String turnoveramt2 = ""; String turnoveryr3 = ""; String turnoveramt3 = ""; String qualassu = ""; String interoffice = ""; String niqs = ""; String expeorg1 = ""; String convalue1 = ""; String contactyr1 = ""; String conserv1 = ""; String expeorg2 = ""; String convalue2 = ""; String contactyr2 = ""; String conserv2 = ""; String expeorg3 = ""; String convalue3 = ""; String contactyr3 = ""; String conserv3 = ""; String expeorg4 = ""; String convalue4 = ""; String contactyr4 = ""; String conserv4 = ""; String expeorg5 = ""; String convalue5 = ""; String contactyr5 = ""; String conserv5 = ""; String expeorg6 = ""; String convalue6 = ""; String contactyr6 = ""; String conserv6 = ""; String legaldisp = ""; String nitorg = ""; String sprovider = ""; String disqual = ""; String debarred = ""; String suspend = ""; String certname = ""; String certfun = ""; String certdate = ""; String regid = ""; username = (String) session.getAttribute("username"); String query = "SELECT * FROM TBL_PPO_USERS where USERNAME ='"+ username +"'"; ResultSet resultSet = statement.executeQuery(query); if (resultSet.next()){ username = resultSet.getString("USERNAME"); password = resultSet.getString("PASSWORD"); password2 = resultSet.getString("PASSWORD2"); namefirm = resultSet.getString("NAMEFIRM"); bizadd = resultSet.getString("BIZADD"); address = resultSet.getString("ADDRESS"); telephone = resultSet.getString("TELEPHONE"); fax = resultSet.getString("FAX"); email = resultSet.getString("EMAIL"); country = resultSet.getString("COUNTRY"); website = resultSet.getString("WEBSITE"); yearest = resultSet.getString("YEAREST"); yearex = resultSet.getString("YEAREX"); license = resultSet.getString("LICENSE"); autho = resultSet.getString("AUTHO"); bizreg = resultSet.getString("BIZREG"); noemp = resultSet.getString("NOEMP"); vat = resultSet.getString("VAT"); tan = resultSet.getString("TAN"); biztype = resultSet.getString("BIZTYPE"); biztypeo = resultSet.getString("BIZTYPEO"); parent = resultSet.getString("PARENT"); relation = resultSet.getString("RELATION"); consultancy1 = resultSet.getString("CONSULTANCY1"); consultancy2 = resultSet.getString("CONSULTANCY2"); consultancy3 = resultSet.getString("CONSULTANCY3"); consultancy4 = resultSet.getString("CONSULTANCY4"); consultancy5 = resultSet.getString("CONSULTANCY5"); consultancy6 = resultSet.getString("CONSULTANCY6"); consultancy7 = resultSet.getString("CONSULTANCY7"); consultancy8 = resultSet.getString("CONSULTANCY8"); consultancy9 = resultSet.getString("CONSULTANCY9"); consultancy10 = resultSet.getString("CONSULTANCY10"); consultancy11 = resultSet.getString("CONSULTANCY11"); consultancy12 = resultSet.getString("CONSULTANCY12"); consultancy13 = resultSet.getString("CONSULTANCY13"); turnoveryr1 = resultSet.getString("TURNOVERYR1"); turnoveramt1 = resultSet.getString("TURNOVERAMT1"); turnoveryr2 = resultSet.getString("TURNOVERYR2"); turnoveramt2 = resultSet.getString("TURNOVERAMT2"); turnoveryr3 = resultSet.getString("TURNOVERYR3"); turnoveramt3 = resultSet.getString("TURNOVERAMT3"); qualassu = resultSet.getString("QUALASSU"); interoffice = resultSet.getString("INTEROFFICE"); expeorg1=resultSet.getString("expeorg1"); convalue1=resultSet.getString("convalue1"); contactyr1=resultSet.getString("contactyr1"); conserv1=resultSet.getString("conserv1"); expeorg2=resultSet.getString("expeorg2"); convalue2=resultSet.getString("convalue2"); contactyr2=resultSet.getString("contactyr2"); conserv2=resultSet.getString("conserv2"); expeorg3=resultSet.getString("expeorg3"); convalue3=resultSet.getString("convalue3"); contactyr3=resultSet.getString("contactyr3"); conserv3=resultSet.getString("conserv3"); expeorg4=resultSet.getString("expeorg4"); convalue4=resultSet.getString("convalue4"); contactyr4=resultSet.getString("contactyr4"); conserv4=resultSet.getString("conserv4"); expeorg5=resultSet.getString("expeorg5"); convalue5=resultSet.getString("convalue5"); contactyr5=resultSet.getString("contactyr5"); conserv5=resultSet.getString("conserv5"); expeorg6=resultSet.getString("expeorg6"); convalue6=resultSet.getString("convalue6"); contactyr6=resultSet.getString("contactyr6"); conserv6=resultSet.getString("conserv6"); legaldisp=resultSet.getString("legaldisp"); nitorg=resultSet.getString("nitorg"); sprovider=resultSet.getString("sprovider"); disqual=resultSet.getString("disqual"); debarred=resultSet.getString("debarred"); suspend=resultSet.getString("suspend"); certname=resultSet.getString("certname"); certfun=resultSet.getString("certfun"); certdate=resultSet.getString("certdate"); } %> <% String SQL_STMT="SELECT * FROM TBL_PPO_DEPTS ORDER BY DEPTS ASC"; ResultSet resul= statement2.executeQuery(SQL_STMT); ResultSet resul2 = statement3.executeQuery(SQL_STMT); String SQL_STMT1="SELECT * FROM TBL_PPO_COUNTRY ORDER BY COUNTRY_NAME ASC"; ResultSet resul4= statement.executeQuery(SQL_STMT1); int j=0; while(resul2.next()){ j++; } String[] usr= new String[j]; int k=0; while(resul.next()){ usr[k]=resul.getString(1); k++; } %> <head> <html xmlns="http://www.w3.org/1999/xhtml"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <style type="text/css"> <!-- .style1 { color: #800000; font-family: Arial, Helvetica, sans-serif; font-weight: bold; font-style: italic; font-size: 14px; } .style4 { color:#000000; font-size: 12px; font-weight:normal; font-family: Verdana, Arial, Helvetica, sans-serif; } .style7 {color: #FFFFFF} .style10 { font-size: 16 } .style11 { color: #FF0000; font-size: 12px; } .style12 { font-size: 10px; font-style: italic; color: #82AD5A; } --> </style> <SCRIPT language="javascript"> function echeck(str) { var at="@" var dot="." var lat=str.indexOf(at) var lstr=str.length var ldot=str.indexOf(dot) if (str.indexOf(at)==-1){ alert("Please enter a valid Email address") return false } if (str.indexOf(at)==-1 || str.indexOf(at)==0 || str.indexOf(at)==lstr){ alert("Please enter a valid Email address") return false } if (str.indexOf(dot)==-1 || str.indexOf(dot)==0 || str.indexOf(dot)==lstr){ alert("Please enter a valid Email address") return false } if (str.indexOf(at,(lat+1))!=-1){ alert("Please enter a valid Email address") return false } if (str.substring(lat-1,lat)==dot || str.substring(lat+1,lat+2)==dot){ alert("Please enter a valid Email address") return false } if (str.indexOf(dot,(lat+2))==-1){ alert("Please enter a valid Email address") return false } if (str.indexOf(" ")!=-1){ alert("Please enter a valid Email address") return false } return true } function checkcon() { var conso=document.getElementById('consultancy13'); if(conso.checked==false) { document.getElementById('othercons').value=""; document.getElementById('othercons').disabled=true; } if(conso.checked==true) { document.getElementById('othercons').disabled=false; } } function checkoc() { var typeconsch=document.getElementById('typecons2'); if(typeconsch.checked==false) { document.getElementById('typeconso').value=""; document.getElementById('typeconso').disabled=true; } if(typeconsch.checked==true) { document.getElementById('typeconso').disabled=false; } } function checko() { var biztypech=document.getElementById('biztype1'); if(biztypech.checked==false) { document.getElementById('biztypeo').value=""; document.getElementById('biztypeo').disabled=true; } if(biztypech.checked==true) { document.getElementById('biztypeo').disabled=false; } } function resetpass() { document.getElementById('m1').style.backgroundImage = ""; document.getElementById('m2').style.backgroundImage = ""; document.getElementById('m3').style.backgroundImage = ""; } function passstrength() { document.getElementById('m1').style.backgroundImage = ""; document.getElementById('m2').style.backgroundImage = ""; document.getElementById('m3').style.backgroundImage = ""; var spcheck=0; var nucheck=0; var upcheck=0; var opass=document.getElementById('password').value; var sChars = ["!","@","#","$","%","^","&",".","*","(",")","+","=","-","[","]",";",",",".","/","{","}","|",":","<",">","?","`","~","\\","'"]; var nChars = ["0","1","2","3","4","5","6","7","8","9"]; var pChars = ["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]; var carray=[]; if(opass.length<=8) { document.getElementById('m1').style.backgroundImage = "url(images/weak1.gif)"; for(var i=0;i<opass.length;i++) { carray[i]=opass.charAt(i); } var spcheck=0; var nucheck=0; var upcheck=0; for(var j=0;j<carray.length;j++) { //Check input string for special characters--Start for(var k=0;k<sChars.length;k++) { if (sChars[k]==carray[j]) { spcheck=spcheck+1; //alert(sChars[k]+" = "+carray[j]+" = "+spcheck); } } //Check input string for special characters--Stop //Check input string for numeric characters--Start for(var l=0;l<nChars.length;l++) { if (nChars[l]==carray[j]) { nucheck=nucheck+1; //alert(nChars[l]+" = "+carray[j]+" = "+nucheck); } } //Check input string for numeric characters--Stop //Check input string for uppercase characters--Start for(var m=0;m<pChars.length;m++) { if (pChars[m]==carray[j]) { upcheck=upcheck+1; //alert(pChars[m]+" = "+carray[j]+" = "+upcheck); } }//Check input string for uppercase characters--Stop } //Medium Password Test if (spcheck>=1 || nucheck>=1 ||upcheck>=1) { document.getElementById('m1').style.backgroundImage = ""; document.getElementById('m1').style.backgroundImage = "url(images/weak.gif)"; document.getElementById('m2').style.backgroundImage = "url(images/medium1.gif)"; } //Medium Password Test //Strong Password Test if (spcheck>0 && nucheck>0 && upcheck>0) { document.getElementById('m1').style.backgroundImage = ""; document.getElementById('m2').style.backgroundImage = ""; document.getElementById('m1').style.backgroundImage = "url(images/weak.gif)"; document.getElementById('m2').style.backgroundImage = "url(images/medium.gif)"; document.getElementById('m3').style.backgroundImage = "url(images/strong1.gif)"; } //Strong Password Test } } function valid() { if(document.user.username.value=="" || document.user.username.length==0) { alert("Username should not be left blank"); document.user.username.focus(); return false; } if(document.user.password.value=="" || document.user.password.length==0) { alert("Password should not be left blank"); document.user.password.focus(); return false; } if(document.user.password2.value=="" || document.user.password2.length==0) { alert("Please Re-type your password for confirmation"); document.user.password2.focus(); return false; } if(document.user.password.value!=document.user.password2.value) { alert("The two passwords do not match. Please re-type your password."); document.user.password2.value=""; document.user.password2.focus(); return false; } if(document.user.namefirm.value=="") { alert("Name of firm should not be left blank"); document.user.namefirm.focus(); return false; } if(document.user.bizadd.value=="") { alert("Business Address should not be left blank"); document.user.bizadd.focus(); return false; } if(document.user.address.value=="") { alert("Mailing Address should not be left blank"); document.user.address.focus(); return false; } if(document.user.telephone.value=="") { alert("Telephone should not be left blank"); document.user.telephone.focus(); return false; } if(document.user.email.value=="") { alert("Email should not be left blank"); document.user.email.focus(); return false; } if (echeck(document.user.email.value)==false) { document.user.email.focus(); return false; } if(document.user.yearest.value=="") { alert("Year established should not be left blank"); document.user.yearest.focus(); return false; } if(document.user.license.value=="") { alert("License number should not be left blank"); document.user.license.focus(); return false; } if(document.user.bizreg.value=="") { alert("Business registration number should not be left blank"); document.user.bizreg.focus(); return false; } if(document.user.turnoveryr1.value=="") { alert("You must enter at least 1 year for turnover"); document.user.turnoveryr1.focus(); return false; } if(document.user.turnoveramt1.value=="") { alert("You must enter amount for turnover"); document.user.turnoveramt1.focus(); return false; } if(document.user.certname.value=="" || document.user.certname.length==0) { alert("Please enter Name for certification"); document.user.certname.focus(); return false; } if(document.user.certfun.value=="" || document.user.certfun.length==0) { alert("Please enter Functional Title for certification"); document.user.certfun.focus(); return false; } } function addSrcToDestList() { destList = document.user.dest; srcList = document.user.sourc; var len = destList.length; for(var i = 0; i < srcList.length; i++) { if ((srcList.options[i] != null) && (srcList.options[i].selected)) { var found = false; for(var count = 0; count < len; count++) { if (destList.options[count] != null) { if (srcList.options[i].text == destList.options[count].text) { found = true; break; } } } if (found != true) { destList.options[len] = new Option(srcList.options[i].text, srcList.options[i].value); len++; } } } var srcList = document.user.sourc; var len = srcList.options.length; for(var i = (len-1); i >= 0; i--) { if((srcList.options[i] != null) && (srcList.options[i].selected == true)) { srcList.options[i] = null; } } } // Deletes from the destination list. function deleteFromDestList() { destList = document.user.dest; srcList = document.user.sourc; var len = srcList.length; for(var i = 0; i < destList.length; i++) { if ((destList.options[i] != null) && (destList.options[i].selected)) { //Check if this value already exist in the destList or not //if not then add it otherwise do not add it. //srcList.options[i] = null; var found = false; for(var count = 0; count < len; count++) { if (srcList.options[count] != null) { if (destList.options[i].text == srcList.options[count].text) { found = true; break; } } } if (found != true) { srcList.options[len] = new Option(destList.options[i].text, destList.options[i].value); len++; } } } var destList = document.user.dest; var len = destList.options.length; for(var i = (len-1); i >= 0; i--) { if ((destList.options[i] != null) && (destList.options[i].selected == true)) { destList.options[i] = null; } } } function selectbodies() { document.user.selectedbod.value=""; var leng=document.user.dest.length; for(var i=0; i<leng; i++){ document.user.dest[i].selected= true; var tess=document.user.dest[i].text; document.user.selectedbod.value=document.user.selectedbod.value+" * "+tess; } } </script> <script src="scripts/AC_RunActiveContent.js" type="text/javascript"></script> </head> <body> <form name="user" onSubmit="return valid()" action="myEditUser2.jsp" method="post"> <table width="840" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#999999"> <tr> <td align="center" valign="middle" class="style4 style10"><script type="text/javascript"> AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','900','height','100','src','images/bannerconsul','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','images/bannerconsul' ); //end AC code </script> <noscript> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="900" height="100"> <param name="movie" value="images/bannerconsul.swf" /> <param name="quality" value="high" /> <embed src="images/bannerconsul.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="900" height="100"></embed>
      </object>
      </noscript></td>
  </tr>
  <tr>
    <td>
    <table width="100%" border="0" cellpadding="2" cellspacing="2" class="style4">
      <tr>
        <td height="20" colspan="4" bgcolor="#C0C0C0" class="style1">Login Details</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td colspan="2">&nbsp;</td>
      </tr>
      <tr>
        <td width="2%">&nbsp;</td>
        <td width="26%">Username</td>
        <td width="29%">
		<input name="username" type="text" id="username" size="18" maxlength="15" value="<%=username%>" readonly="readonly"/><span class="style11">&nbsp;*</span></td>
        <td width="43%">Password Strength Meter. <a href="passwordstrength.jsp" target="page" onClick="window.open('forgotpassform.jsp','page','toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=0,width=400,height=500,left=50,top=50,titlebar=no')">Learn more</a></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">Password</td>
        <td>
		<input name="password" type="password" id="password" size="20" maxlength="8" onkeydown="passstrength();" value="<%=password%>"/><span class="style11">&nbsp;*</span></td>
        <td>
        <table border="0" cellspacing="0" cellpadding="0">
          <tr>            
            <td width="75" height="15" id="m1">&nbsp;</td>            
            <td width="75" height="15" id="m2">&nbsp;</td>            
            <td width="75" height="15" id="m3">&nbsp;</td>                       
          </tr>
        </table>        </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">&nbsp;</td>
        <td><span class="style12">Password must contain only 8 characters.</span></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">Confirm Password</td>
        <td>
		<input name="password2" type="password" id="password2" size="20" maxlength="8" value="<%=password2%>" /><span class="style11">&nbsp;*</span></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="4">&nbsp;</td>
        </tr>
    </table>    </td>
  </tr>
  
  <tr>
    <td>
    <table width="100%" border="0" cellpadding="2" cellspacing="2" class="style4">
      <tr>
        <td colspan="5" bgcolor="#C0C0C0" height="20"><span class="style1">Section 1: Company Details and General Information</span></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td colspan="3">&nbsp;</td>
      </tr>
      <tr>
        <td width="8">&nbsp;</td>
        <td width="277" class="style4">Name of Firm</td>
        <td colspan="3">
		<input name="namefirm" type="text" id="namefirm" size="80" maxlength="80" value="<%=namefirm%>" /><span class="style11">&nbsp;*</span></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">Business Address</td>
        <td colspan="3">
		<input name="bizadd" type="text" id="bizadd" size="80" maxlength="80" value="<%=bizadd%>" /><span class="style11">&nbsp;*</span></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">P.O Box &amp; Mailing Address</td>
        <td colspan="3">
		<input name="address" type="text" id="address" size="80" maxlength="80" value="<%=address%>" /><span class="style11">&nbsp;*</span></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">Telephone</td>
        <td colspan="3">
		<input name="telephone" type="text" id="telephone" size="20" maxlength="20" value="<%=telephone%>" /><span class="style11">&nbsp;*</span></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">Fax</td>
        <td colspan="3">
		<input name="fax" type="text" id="fax" size="20" maxlength="20" value="<%=fax%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">Email Address</td>
        <td colspan="3">
		<input name="email" type="text" id="email" size="50" maxlength="50" value="<%=email%>" /><span class="style11">&nbsp;*</span></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">Country</td>
        <td colspan="3">
          <select name="country" id="country">
            <%
			while(resul4.next()){%>
    		<option value="<%=resul4.getString(2)%>"><%=resul4.getString(2)%></option>
   			<% } %>
          </select><span class="style11">&nbsp;*</span></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Website</td>
        <td colspan="3">
		<input name="website" type="text" id="website" size="50" maxlength="50" value="<%=website%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Year Established</td>
        <td colspan="3">
		<input name="yearest" type="text" id="yearest" size="12" maxlength="4" value="<%=yearest%>" /><span class="style11">&nbsp;*</span></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Years of experience in the current business</td>
        <td colspan="3">
		<input name="yearex" type="text" id="yearex" size="20" maxlength="4" value="<%=yearex%>" /></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>License No</td>
        <td colspan="3">
		<input name="license" type="text" id="license" size="20" maxlength="20" value="<%=license%>" /><span class="style11">&nbsp;*</span></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Licensing Authority</td>
        <td colspan="3">
		<input name="autho" type="text" id="autho" size="20" maxlength="20" value="<%=autho%>" /></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Business Reg. No</td>
        <td colspan="3">
		<input name="bizreg" type="text" id="bizreg" size="20" maxlength="20" value="<%=bizreg%>" /><span class="style11">&nbsp;*</span></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>No. of full-time Employees</td>
        <td colspan="3">
		<input name="noemp" type="text" id="noemp" size="20" maxlength="4" value="<%=noemp%>" /></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>VAT No</td>
        <td colspan="3">
		<input name="vat" type="text" id="vat" size="20" maxlength="20" value="<%=vat%>" /></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Tax Account No</td>
        <td colspan="3" valign="middle">
		<input name="tan" type="text" id="tan" size="20" maxlength="4" value="<%=tan%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Type of Business</td>
        <td width="147" valign="middle"><input type="radio" name="biztype" id="biztype3" value="corporate" onclick="checko();"/>          Corporate/Limited</td>
        <td width="182" valign="middle"><input type="radio" name="biztype" id="biztype2" value="partnership" onclick="checko();"/>
          Partnership</td>
        <td width="254" valign="middle"><input type="radio" name="biztype" id="biztype1" value="other" onclick="checko();"/>
          Other 
		<input name="biztypeo" type="text" id="biztypeo" size="20" maxlength="20" disabled="disabled" value="<%=biztypeo%>"/></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Types of consultancy
provided</td>
        <td><input type="radio" name="typecons" id="typecons" value="Firm" onclick="checkoc();"/>          
          Firm</td>
        <td><input type="radio" name="typecons" id="typecons1" value="Individual Consultant" onclick="checkoc();"/>
Individual Consultant</td>
        <td><input type="radio" name="typecons" id="typecons2" value="other" onclick="checkoc();"/>
          Other 
		<input name="typeconso" type="text" id="typeconso" size="20" maxlength="20" disabled="disabled" value="<%=typeconso%>"/></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="4">
        <table  border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td height="5"></td>
          </tr>
          <tr>
            <td>Names and Qualifications of main partners</td>
          </tr>
          <tr>
          <td height="5"></td>
          </tr>
          <tr>
            <td>&nbsp;&nbsp;<textarea name="qualification" id="qualification" cols="80" rows="5"><%=qualification%></textarea></td>
          </tr>
        </table>        </td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Parent Company (If Any)</td>
        <td colspan="3">
		<input name="parent" type="text" id="parent" size="70" maxlength="50" value="<%=parent%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Relation with Parent Co.</td>
        <td colspan="3"><input type="radio" name="relation" id="relation" value="corporate" />          
          Subsidiaries&nbsp;&nbsp;&nbsp;
          <input type="radio" name="relation" id="relation" value="Associates" />
          Associates&nbsp;&nbsp;&nbsp;
          <input type="radio" name="relation" id="relation" value="Joint Venture" /> 
          Joint Venture&nbsp;&nbsp;&nbsp;
          <input type="radio" name="relation" id="relation" value="Overseas Representative" /> 
          Overseas Representative</td>
      </tr>
      <tr>
        <td height="10">&nbsp;</td>
        <td height="10">&nbsp;</td>
        <td colspan="3" height="10">&nbsp;</td>
      </tr>
    </table>    </td>
  </tr>
  <tr>
    <td>
    <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
      <tr>
        <td height="20" colspan="4" bgcolor="#000000" class="style1 style7">Types of consultancy provided: Please select the type of services that you could provide.</td>
        </tr>
      <tr>
        <td height="10" valign="middle" class="style4"></td>
        <td height="10" valign="middle" class="style4"></td>
        <td height="10" valign="middle" class="style4"></td>
        <td height="10" valign="middle" class="style4"></td>
      </tr>
      <tr>
        <td width="12" valign="middle" class="style4">&nbsp;</td>
        <td width="273" valign="middle" class="style4"><input name="consultancy1" type="checkbox" id="consultancy1" value="Architectural Services" /> Architectural Services</td>
        <td width="252" valign="middle" class="style4"><input name="consultancy2" type="checkbox" id="consultancy2" value="Design Services" /> 
          Design Services</td>
        <td width="277" valign="middle" class="style4"><input name="consultancy3" type="checkbox" id="consultancy3" value="Engineering Services" /> Engineering Services</td>
      </tr>
      <tr>
        <td valign="middle" class="style4">&nbsp;</td>
        <td valign="middle" class="style4"><input name="consultancy4" type="checkbox" id="consultancy4" value="Financial Intermediation Services" />
Financial Intermediation Services</td>
        <td valign="middle" class="style4"><input name="consultancy5" type="checkbox" id="consultancy5" value="Financial Services" />
Financial Services</td>
        <td valign="middle" class="style4"><input name="consultancy6" type="checkbox" id="consultancy6" value="Integrated Engineering Services" />
Integrated Engineering Services</td>
      </tr>
      <tr>
        <td valign="middle" class="style4">&nbsp;</td>
        <td valign="middle" class="style4"><input name="consultancy7" type="checkbox" id="consultancy7" value="IT Services" /> 
          IT Services</td>
        <td valign="middle" class="style4"><input name="consultancy8" type="checkbox" id="consultancy8" value="Legal Services" />
Legal Services</td>
        <td valign="middle" class="style4"><input name="consultancy9" type="checkbox" id="consultancy9" value="Natural Resources Services" />
Natural Resources Services</td>
      </tr>
      <tr>
      <td valign="middle" class="style4">&nbsp;</td>
        <td colspan="3" valign="middle" class="style4"><input name="consultancy10" type="checkbox" id="consultancy10" value="Research and Development Services on Natural Sciences" /> 
        Research and Development Services on Natural Sciences</td>
        </tr>
      <tr>
      <td valign="middle" class="style4">&nbsp;</td>
        <td colspan="3" valign="middle" class="style4"><input name="consultancy11" type="checkbox" id="consultancy11" value="Research and Development Services on Social Sciences and Humanities" /> 
        Research and Development Services on Social Sciences and Humanities</td>
        </tr>
      <tr>
      <td valign="middle" class="style4">&nbsp;</td>
        <td colspan="3" valign="middle" class="style4"><input name="consultancy12" type="checkbox" id="consultancy12" value="Urban Planning and Landscape Services" /> 
        Urban Planning and Landscape Services</td>
        </tr>
      <tr>
      <td valign="middle" class="style4">&nbsp;</td>
        <td colspan="3" valign="middle" class="style4"><input name="consultancy13" type="checkbox" id="consultancy13" value="Other" onclick="checkcon();"/>
Other (Specify)&nbsp;&nbsp;&nbsp;&nbsp;
<input name="othercons" type="text" id="othercons" size="70" maxlength="50" disabled="disabled" value="<%=othercons%>"/></td>
        </tr>
      <tr>
        <td height="10" valign="middle" class="style4"></td>
        <td height="10" valign="middle" class="style4"></td>
        <td height="10" valign="middle" class="style4"></td>
        <td height="10" valign="middle" class="style4"></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td class="style1" height="20">
    <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
      <tr>
        <td colspan="3" bgcolor="#C0C0C0" class="style1" height="20">Section 2: Financial Information</td>
        </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td colspan="2" class="style4">&nbsp;</td>
      </tr>
      <tr>
        <td width="12" class="style4">&nbsp;</td>
        <td colspan="2" class="style4">Annual turnover for the last 3 years</td>
        </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td width="359" class="style4">Year&nbsp;&nbsp;<input name="turnoveryr1" type="text" id="turnoveryr1" size="12" maxlength="4" value="<%=turnoveryr1%>" /><span class="style11">&nbsp;*</span></td>
        <td width="449" class="style4">Rs.&nbsp;<input name="turnoveramt1" type="text" id="turnoveramt1" size="20" maxlength="12" value="<%=turnoveramt1%>" />&nbsp;&nbsp;million<span class="style11">&nbsp;*</span></td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">Year&nbsp;&nbsp;<input name="turnoveryr2" type="text" id="turnoveryr2" size="12" maxlength="4" value="<%=turnoveryr2%>" /></td>
        <td class="style4">Rs.&nbsp;<input name="turnoveramt2" type="text" id="turnoveramt2" size="20" maxlength="12" value="<%=turnoveramt2%>" />&nbsp;&nbsp;million</td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">Year&nbsp;&nbsp;<input name="turnoveryr3" type="text" id="turnoveryr3" size="12" maxlength="4" value="<%=turnoveryr3%>" /></td>
        <td class="style4">Rs.&nbsp;<input name="turnoveramt3" type="text" id="turnoveramt3" size="20" maxlength="12" value="<%=turnoveramt3%>" />&nbsp;&nbsp;million</td>
      </tr>

      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">&nbsp;</td>
        <td class="style4">&nbsp;</td>
      </tr>
    </table>    </td>
  </tr>  
  <tr>
    <td>
    <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
      <tr>
        <td height="20" colspan="2" bgcolor="#C0C0C0" class="style1">Section 3: Technical Capabilities and Information on Services Offered</td>
        </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">&nbsp;</td>
      </tr>
      <tr>
        <td class="style4" width="12">&nbsp;</td>
        <td class="style4">Quality Assurance Certification of Company (e.g. ISO 9000 or Equivalent)</td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">
		<input name="qualassu" type="text" id="qualassu" size="100" maxlength="100" value="<%=qualassu%>" /></td>
      </tr>
      <tr>
        <td class="style4" height="10"></td>
        <td class="style4" height="5"></td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">International Offices/Representation (Countries where the company has local/Offices/Representation)</td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">
		<input name="interoffice" type="text" id="interoffice" size="100" maxlength="100" value="<%=interoffice%>" /></td>
      </tr>
      <tr>
        <td class="style4" height="10"></td>
        <td class="style4"></td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">Do the Services provided conform to National/International Quality Standards?</td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4"><input type="radio" name="niqs" value="yes">&nbsp;&nbsp;Yes<br /><input type="radio" name="niqs" value="no">&nbsp;&nbsp;No</td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">&nbsp;</td>
      </tr>
    </table>    </td>
  </tr>
  <tr>
    <td>
    <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
      <tr>
        <td colspan="5" bgcolor="#C0C0C0" class="style1" height="20">Section 4: Experience</td>
        </tr>
      <tr>
        <td colspan="5">&nbsp;</td>
        </tr>
      <tr>
        <td width="11">&nbsp;</td>
        <td colspan="4">Recent Contracts with Public Bodies</td>
        </tr>
      <tr>
        <td align="center" valign="middle" width="11">&nbsp;</td>
        <td width="237" align="center" valign="middle">Organisation</td>
        <td width="167" align="center" valign="middle">Contract Value (Rs)</td>
        <td width="106" align="center" valign="middle">Year</td>
        <td width="287" align="center" valign="middle">Consultancy Services Provided</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td align="center" valign="middle">
		<input name="expeorg1" type="text" id="expeorg1" size="39" maxlength="12" value="<%=expeorg1%>" /></td>
        <td align="center" valign="middle">
		<input name="convalue1" type="text" id="convalue1" size="25" maxlength="12" value="<%=convalue1%>" /></td>
        <td align="center" valign="middle">
		<input name="contactyr1" type="text" id="contactyr1" size="15" maxlength="4" value="<%=contactyr1%>" /></td>
        <td align="center" valign="middle">
		<input name="conserv1" type="text" id="conserv1" size="41" maxlength="12" value="<%=conserv1%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td align="center" valign="middle">
		<input name="expeorg2" type="text" id="expeorg2" size="39" maxlength="12" value="<%=expeorg2%>" /></td>
        <td align="center" valign="middle">
		<input name="convalue2" type="text" id="convalue2" size="25" maxlength="12" value="<%=convalue2%>" /></td>
        <td align="center" valign="middle">
		<input name="contactyr2" type="text" id="contactyr2" size="15" maxlength="4" value="<%=contactyr2%>" /></td>
        <td align="center" valign="middle">
		<input name="conserv2" type="text" id="conserv2" size="41" maxlength="12" value="<%=conserv2%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td align="center" valign="middle">
		<input name="expeorg3" type="text" id="expeorg3" size="39" maxlength="12" value="<%=expeorg3%>" /></td>
        <td align="center" valign="middle">
		<input name="convalue3" type="text" id="convalue3" size="25" maxlength="12" value="<%=convalue3%>" /></td>
        <td align="center" valign="middle">
		<input name="contactyr3" type="text" id="contactyr3" size="15" maxlength="4" value="<%=contactyr3%>" /></td>
        <td align="center" valign="middle">
		<input name="conserv3" type="text" id="conserv3" size="41" maxlength="12" value="<%=conserv3%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td align="center" valign="middle">
		<input name="expeorg4" type="text" id="expeorg4" size="39" maxlength="12" value="<%=expeorg4%>" /></td>
        <td align="center" valign="middle">
		<input name="convalue4" type="text" id="convalue4" size="25" maxlength="12" value="<%=convalue4%>" /></td>
        <td align="center" valign="middle">
		<input name="contactyr4" type="text" id="contactyr4" size="15" maxlength="4" value="<%=contactyr4%>" /></td>
        <td align="center" valign="middle">
		<input name="conserv4" type="text" id="conserv4" size="41" maxlength="12" value="<%=conserv4%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td align="center" valign="middle">
		<input name="expeorg5" type="text" id="expeorg5" size="39" maxlength="12" value="<%=expeorg5%>" /></td>
        <td align="center" valign="middle">
		<input name="convalue5" type="text" id="convalue5" size="25" maxlength="12" value="<%=convalue5%>" /></td>
        <td align="center" valign="middle">
		<input name="contactyr5" type="text" id="contactyr5" size="15" maxlength="4" value="<%=contactyr5%>" /></td>
        <td align="center" valign="middle">
		<input name="conserv5" type="text" id="conserv5" size="41" maxlength="12" value="<%=conserv5%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td align="center" valign="middle">
		<input name="expeorg6" type="text" id="expeorg6" size="39" maxlength="12" value="<%=expeorg6%>" /></td>
        <td align="center" valign="middle">
		<input name="convalue6" type="text" id="convalue6" size="25" maxlength="12" value="<%=convalue6%>" /></td>
        <td align="center" valign="middle">
		<input name="contactyr6" type="text" id="contactyr6" size="15" maxlength="4" value="<%=contactyr6%>" /></td>
        <td align="center" valign="middle">
		<input name="conserv6" type="text" id="conserv6" size="41" maxlength="12" value="<%=conserv6%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td align="center" valign="middle">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td>
    <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
      <tr>
        <td height="20" colspan="3" bgcolor="#C0C0C0" class="style1">Section 5: Others</td>
        </tr>
      <tr>
        <td colspan="3">&nbsp;</td>
        </tr>
      <tr>
        <td width="12">&nbsp;</td>
        <td colspan="2">Please list any current legal disputes in which your company may be involved.</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2"><textarea name="legaldisp" id="legaldisp" cols="90" rows="3"><%=legaldisp%></textarea></td>
        </tr>
      <tr>
        <td height="10"></td>
        <td colspan="2"></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">List any national or international Trade or Professional Organisation of which your Company is a member.</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2"><textarea name="nitorg" id="nitorg" cols="90" rows="3"><%=nitorg%></textarea></td>
        </tr>
      <tr>
        <td height="10"></td>
        <td width="466"></td>
        <td width="342"></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">Any particular Ministry or Departments, Parastatal Body or Local Authority for which you would wish to be registered as Service Provider/Consultant.</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="2%">&nbsp;</td>
            <td width="40%"><div style="width:340px; overflow-x:auto"><select name="sourc" size="6" id="sourc" style="OVERFLOW: auto;width: 340px; margin: 0px 0 5px 0">
       				  <%
							for(int i=0;i<j;i++)
     						{
							String countr=usr[i];
							%>
							<OPTION selected> <%= countr %> </OPTION>
							<%}%>
                            </select>                  </div></td>
            <td width="6%"><input type="button" name="todest" id="todest" value=">>>" onClick="javascript:addSrcToDestList();"/><br /><br /><input type="button" name="tosourc" id="tosourc" value="<<<" onClick="javascript:deleteFromDestList();"/></td>
          <td width="52%"><select name="dest" size="6" multiple="multiple" id="dest" style="width: 340px; margin: 0px 0 5px 0">
                        </select>
              <input type="text" name="selectedbod" id="selectedbod" style="display:none"/></td>
          </tr>
          
        </table></td>
      </tr>
      <tr>
        <td height="10" colspan="3"></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Have you been disqualified by the Procurement Policy Office?</td>
        <td><input type="radio" name="disqual" value="yes">
        &nbsp;&nbsp;Yes&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="disqual" value="no">
        &nbsp;&nbsp;No</td>
      </tr>
      <tr>
        <td height="10" colspan="3"></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Have you been debarred by the Procurement Policy Office?</td>
        <td><input type="radio" name="debarred" value="yes">
        &nbsp;&nbsp;Yes&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="debarred" value="no">
        &nbsp;&nbsp;No</td>
      </tr>
      <tr>
        <td height="10"></td>
        <td height="10"></td>
        <td height="10"></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Have you been suspended by the Procurement Policy Office?</td>
        <td><input type="radio" name="suspend" value="yes">
        &nbsp;&nbsp;Yes&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="suspend" value="no">
        &nbsp;&nbsp;No</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">Certification</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">I, the undersigned, certify that the information provided in this form is correct, and in the event of changes details will be provided as soon as possible.</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2"><table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
          <tr>
            <td width="16%">Name</td>
            <td width="45%">
			<input name="certname" type="text" id="certname" size="40" maxlength="40" value="<%=certname%>" /><span class="style11">&nbsp;*</span></td>
            <td width="10%">&nbsp;</td>
            <td width="29%">&nbsp;</td>
          </tr>
          <tr>
            <td height="10"></td>
            <td height="10"></td>
            <td height="10"></td>
            <td height="10"></td>
          </tr>
          <tr>
            <td>Functional Title</td>
            <td>
			<input name="certfun" type="text" id="certfun" size="40" maxlength="40" value="<%=certfun%>" /><span class="style11">&nbsp;*</span></td>
            <td>Date</td>
            <td>
			<input name="certdate" type="text" id="certdate" size="20" maxlength="20" value="<%=certdate%>" readonly="readonly"/></td>
          </tr>
        </table></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td height="20" colspan="3" bgcolor="#000000"><span class="style7">Note:</span></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">All procurement dealings will be guided by the Public Procurement Act 2006 and its corresponding Regulations 2008.</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Documents to be submitted upon request:</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td height="10" align="left" valign="top"></td>
        <td colspan="2"></td>
      </tr>
      <tr>
        <td align="left" valign="top"><img src="images/304.gif" width="5" height="12" /></td>
        <td colspan="2">A listing of reference sources for works performed by your firm within the last 12 weeks, Please also indicate fax numbers and contact person for your reference sources.</td>
        </tr>
      <tr>
        <td><img src="images/304.gif" width="5" height="12" /></td>
        <td colspan="2">A copy of the company's Annual Financial Report for the past 3 years.</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td>
    <table width="100%" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <td width="50%" align="right"><input type="reset" name="Reset" id="Reset" value="Reset Form" onclick="resetpass();"/></td>
        <td align="left"><input type="submit" name="submit" id="submit" value="Submit Form" onclick="selectbodies();"/></td>
        </tr>
    </table></td>
  </tr>
</table>
</form>
</body>
</html>
 
0
 

Please edit your post and pust whole code in bb code tags.
Source program must be surrounded with BB code tags: See # icon at toolbar and also read How to use bb code tags?.

 
0
 

I have edit my post but I am not so sure if i have reply to your question as I am not able to understand what u have asked me to do. If you could give me an example to answer u better.

Thank you

<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <%@ page import="java.util.*" %> <%@ page import="oracle.jdbc.pool.*" %> <%@ include file ="dbcon.jsp"%> <% String username = ""; String password = ""; String password2 = ""; String namefirm = ""; String bizadd = ""; String address = ""; String telephone = ""; String fax = ""; String country = ""; String email = ""; String website = ""; String yearest = ""; String license = ""; String bizreg = ""; String vat = ""; String yearex = ""; String autho = ""; String noemp = ""; String tan = ""; String biztype = ""; String biztypeo=""; String typecons = ""; String typeconso = ""; String qualification = ""; String parent = ""; String relation = ""; String consultancy1 = ""; String consultancy2 = ""; String consultancy3 = ""; String consultancy4 = ""; String consultancy5 = ""; String consultancy6 = ""; String consultancy7 = ""; String consultancy8 = ""; String consultancy9 = ""; String consultancy10 = ""; String consultancy11 = ""; String consultancy12 = ""; String consultancy13 = ""; String othercons = ""; String turnoveryr1 = ""; String turnoveramt1 = ""; String turnoveryr2 = ""; String turnoveramt2 = ""; String turnoveryr3 = ""; String turnoveramt3 = ""; String qualassu = ""; String interoffice = ""; String niqs = ""; String expeorg1 = ""; String convalue1 = ""; String contactyr1 = ""; String conserv1 = ""; String expeorg2 = ""; String convalue2 = ""; String contactyr2 = ""; String conserv2 = ""; String expeorg3 = ""; String convalue3 = ""; String contactyr3 = ""; String conserv3 = ""; String expeorg4 = ""; String convalue4 = ""; String contactyr4 = ""; String conserv4 = ""; String expeorg5 = ""; String convalue5 = ""; String contactyr5 = ""; String conserv5 = ""; String expeorg6 = ""; String convalue6 = ""; String contactyr6 = ""; String conserv6 = ""; String legaldisp = ""; String nitorg = ""; String sprovider = ""; String disqual = ""; String debarred = ""; String suspend = ""; String certname = ""; String certfun = ""; String certdate = ""; String regid = ""; username = (String) session.getAttribute("username"); String query = "SELECT * FROM TBL_PPO_USERS where USERNAME ='"+ username +"'"; ResultSet resultSet = statement.executeQuery(query); if (resultSet.next()){ username = resultSet.getString("USERNAME"); password = resultSet.getString("PASSWORD"); password2 = resultSet.getString("PASSWORD2"); namefirm = resultSet.getString("NAMEFIRM"); bizadd = resultSet.getString("BIZADD"); address = resultSet.getString("ADDRESS"); telephone = resultSet.getString("TELEPHONE"); fax = resultSet.getString("FAX"); email = resultSet.getString("EMAIL"); country = resultSet.getString("COUNTRY"); website = resultSet.getString("WEBSITE"); yearest = resultSet.getString("YEAREST"); yearex = resultSet.getString("YEAREX"); license = resultSet.getString("LICENSE"); autho = resultSet.getString("AUTHO"); bizreg = resultSet.getString("BIZREG"); noemp = resultSet.getString("NOEMP"); vat = resultSet.getString("VAT"); tan = resultSet.getString("TAN"); biztype = resultSet.getString("BIZTYPE"); biztypeo = resultSet.getString("BIZTYPEO"); parent = resultSet.getString("PARENT"); relation = resultSet.getString("RELATION"); consultancy1 = resultSet.getString("CONSULTANCY1"); consultancy2 = resultSet.getString("CONSULTANCY2"); consultancy3 = resultSet.getString("CONSULTANCY3"); consultancy4 = resultSet.getString("CONSULTANCY4"); consultancy5 = resultSet.getString("CONSULTANCY5"); consultancy6 = resultSet.getString("CONSULTANCY6"); consultancy7 = resultSet.getString("CONSULTANCY7"); consultancy8 = resultSet.getString("CONSULTANCY8"); consultancy9 = resultSet.getString("CONSULTANCY9"); consultancy10 = resultSet.getString("CONSULTANCY10"); consultancy11 = resultSet.getString("CONSULTANCY11"); consultancy12 = resultSet.getString("CONSULTANCY12"); consultancy13 = resultSet.getString("CONSULTANCY13"); turnoveryr1 = resultSet.getString("TURNOVERYR1"); turnoveramt1 = resultSet.getString("TURNOVERAMT1"); turnoveryr2 = resultSet.getString("TURNOVERYR2"); turnoveramt2 = resultSet.getString("TURNOVERAMT2"); turnoveryr3 = resultSet.getString("TURNOVERYR3"); turnoveramt3 = resultSet.getString("TURNOVERAMT3"); qualassu = resultSet.getString("QUALASSU"); interoffice = resultSet.getString("INTEROFFICE"); expeorg1=resultSet.getString("expeorg1"); convalue1=resultSet.getString("convalue1"); contactyr1=resultSet.getString("contactyr1"); conserv1=resultSet.getString("conserv1"); expeorg2=resultSet.getString("expeorg2"); convalue2=resultSet.getString("convalue2"); contactyr2=resultSet.getString("contactyr2"); conserv2=resultSet.getString("conserv2"); expeorg3=resultSet.getString("expeorg3"); convalue3=resultSet.getString("convalue3"); contactyr3=resultSet.getString("contactyr3"); conserv3=resultSet.getString("conserv3"); expeorg4=resultSet.getString("expeorg4"); convalue4=resultSet.getString("convalue4"); contactyr4=resultSet.getString("contactyr4"); conserv4=resultSet.getString("conserv4"); expeorg5=resultSet.getString("expeorg5"); convalue5=resultSet.getString("convalue5"); contactyr5=resultSet.getString("contactyr5"); conserv5=resultSet.getString("conserv5"); expeorg6=resultSet.getString("expeorg6"); convalue6=resultSet.getString("convalue6"); contactyr6=resultSet.getString("contactyr6"); conserv6=resultSet.getString("conserv6"); legaldisp=resultSet.getString("legaldisp"); nitorg=resultSet.getString("nitorg"); sprovider=resultSet.getString("sprovider"); disqual=resultSet.getString("disqual"); debarred=resultSet.getString("debarred"); suspend=resultSet.getString("suspend"); certname=resultSet.getString("certname"); certfun=resultSet.getString("certfun"); certdate=resultSet.getString("certdate"); } %> <% String SQL_STMT="SELECT * FROM TBL_PPO_DEPTS ORDER BY DEPTS ASC"; ResultSet resul= statement2.executeQuery(SQL_STMT); ResultSet resul2 = statement3.executeQuery(SQL_STMT); String SQL_STMT1="SELECT * FROM TBL_PPO_COUNTRY ORDER BY COUNTRY_NAME ASC"; ResultSet resul4= statement.executeQuery(SQL_STMT1); int j=0; while(resul2.next()){ j++; } String[] usr= new String[j]; int k=0; while(resul.next()){ usr[k]=resul.getString(1); k++; } %> <head> <html xmlns="http://www.w3.org/1999/xhtml"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <style type="text/css"> <!-- .style1 { color: #800000; font-family: Arial, Helvetica, sans-serif; font-weight: bold; font-style: italic; font-size: 14px; } .style4 { color:#000000; font-size: 12px; font-weight:normal; font-family: Verdana, Arial, Helvetica, sans-serif; } .style7 {color: #FFFFFF} .style10 { font-size: 16 } .style11 { color: #FF0000; font-size: 12px; } .style12 { font-size: 10px; font-style: italic; color: #82AD5A; } --> </style> <SCRIPT language="javascript"> function echeck(str) { var at="@" var dot="." var lat=str.indexOf(at) var lstr=str.length var ldot=str.indexOf(dot) if (str.indexOf(at)==-1){ alert("Please enter a valid Email address") return false } if (str.indexOf(at)==-1 || str.indexOf(at)==0 || str.indexOf(at)==lstr){ alert("Please enter a valid Email address") return false } if (str.indexOf(dot)==-1 || str.indexOf(dot)==0 || str.indexOf(dot)==lstr){ alert("Please enter a valid Email address") return false } if (str.indexOf(at,(lat+1))!=-1){ alert("Please enter a valid Email address") return false } if (str.substring(lat-1,lat)==dot || str.substring(lat+1,lat+2)==dot){ alert("Please enter a valid Email address") return false } if (str.indexOf(dot,(lat+2))==-1){ alert("Please enter a valid Email address") return false } if (str.indexOf(" ")!=-1){ alert("Please enter a valid Email address") return false } return true } function checkcon() { var conso=document.getElementById('consultancy13'); if(conso.checked==false) { document.getElementById('othercons').value=""; document.getElementById('othercons').disabled=true; } if(conso.checked==true) { document.getElementById('othercons').disabled=false; } } function checkoc() { var typeconsch=document.getElementById('typecons2'); if(typeconsch.checked==false) { document.getElementById('typeconso').value=""; document.getElementById('typeconso').disabled=true; } if(typeconsch.checked==true) { document.getElementById('typeconso').disabled=false; } } function checko() { var biztypech=document.getElementById('biztype1'); if(biztypech.checked==false) { document.getElementById('biztypeo').value=""; document.getElementById('biztypeo').disabled=true; } if(biztypech.checked==true) { document.getElementById('biztypeo').disabled=false; } } function resetpass() { document.getElementById('m1').style.backgroundImage = ""; document.getElementById('m2').style.backgroundImage = ""; document.getElementById('m3').style.backgroundImage = ""; } function passstrength() { document.getElementById('m1').style.backgroundImage = ""; document.getElementById('m2').style.backgroundImage = ""; document.getElementById('m3').style.backgroundImage = ""; var spcheck=0; var nucheck=0; var upcheck=0; var opass=document.getElementById('password').value; var sChars = ["!","@","#","$","%","^","&",".","*","(",")","+","=","-","[","]",";",",",".","/","{","}","|",":","<",">","?","`","~","\\","'"]; var nChars = ["0","1","2","3","4","5","6","7","8","9"]; var pChars = ["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]; var carray=[]; if(opass.length<=8) { document.getElementById('m1').style.backgroundImage = "url(images/weak1.gif)"; for(var i=0;i<opass.length;i++) { carray[i]=opass.charAt(i); } var spcheck=0; var nucheck=0; var upcheck=0; for(var j=0;j<carray.length;j++) { //Check input string for special characters--Start for(var k=0;k<sChars.length;k++) { if (sChars[k]==carray[j]) { spcheck=spcheck+1; //alert(sChars[k]+" = "+carray[j]+" = "+spcheck); } } //Check input string for special characters--Stop //Check input string for numeric characters--Start for(var l=0;l<nChars.length;l++) { if (nChars[l]==carray[j]) { nucheck=nucheck+1; //alert(nChars[l]+" = "+carray[j]+" = "+nucheck); } } //Check input string for numeric characters--Stop //Check input string for uppercase characters--Start for(var m=0;m<pChars.length;m++) { if (pChars[m]==carray[j]) { upcheck=upcheck+1; //alert(pChars[m]+" = "+carray[j]+" = "+upcheck); } }//Check input string for uppercase characters--Stop } //Medium Password Test if (spcheck>=1 || nucheck>=1 ||upcheck>=1) { document.getElementById('m1').style.backgroundImage = ""; document.getElementById('m1').style.backgroundImage = "url(images/weak.gif)"; document.getElementById('m2').style.backgroundImage = "url(images/medium1.gif)"; } //Medium Password Test //Strong Password Test if (spcheck>0 && nucheck>0 && upcheck>0) { document.getElementById('m1').style.backgroundImage = ""; document.getElementById('m2').style.backgroundImage = ""; document.getElementById('m1').style.backgroundImage = "url(images/weak.gif)"; document.getElementById('m2').style.backgroundImage = "url(images/medium.gif)"; document.getElementById('m3').style.backgroundImage = "url(images/strong1.gif)"; } //Strong Password Test } } function valid() { if(document.user.username.value=="" || document.user.username.length==0) { alert("Username should not be left blank"); document.user.username.focus(); return false; } if(document.user.password.value=="" || document.user.password.length==0) { alert("Password should not be left blank"); document.user.password.focus(); return false; } if(document.user.password2.value=="" || document.user.password2.length==0) { alert("Please Re-type your password for confirmation"); document.user.password2.focus(); return false; } if(document.user.password.value!=document.user.password2.value) { alert("The two passwords do not match. Please re-type your password."); document.user.password2.value=""; document.user.password2.focus(); return false; } if(document.user.namefirm.value=="") { alert("Name of firm should not be left blank"); document.user.namefirm.focus(); return false; } if(document.user.bizadd.value=="") { alert("Business Address should not be left blank"); document.user.bizadd.focus(); return false; } if(document.user.address.value=="") { alert("Mailing Address should not be left blank"); document.user.address.focus(); return false; } if(document.user.telephone.value=="") { alert("Telephone should not be left blank"); document.user.telephone.focus(); return false; } if(document.user.email.value=="") { alert("Email should not be left blank"); document.user.email.focus(); return false; } if (echeck(document.user.email.value)==false) { document.user.email.focus(); return false; } if(document.user.yearest.value=="") { alert("Year established should not be left blank"); document.user.yearest.focus(); return false; } if(document.user.license.value=="") { alert("License number should not be left blank"); document.user.license.focus(); return false; } if(document.user.bizreg.value=="") { alert("Business registration number should not be left blank"); document.user.bizreg.focus(); return false; } if(document.user.turnoveryr1.value=="") { alert("You must enter at least 1 year for turnover"); document.user.turnoveryr1.focus(); return false; } if(document.user.turnoveramt1.value=="") { alert("You must enter amount for turnover"); document.user.turnoveramt1.focus(); return false; } if(document.user.certname.value=="" || document.user.certname.length==0) { alert("Please enter Name for certification"); document.user.certname.focus(); return false; } if(document.user.certfun.value=="" || document.user.certfun.length==0) { alert("Please enter Functional Title for certification"); document.user.certfun.focus(); return false; } } function addSrcToDestList() { destList = document.user.dest; srcList = document.user.sourc; var len = destList.length; for(var i = 0; i < srcList.length; i++) { if ((srcList.options[i] != null) && (srcList.options[i].selected)) { var found = false; for(var count = 0; count < len; count++) { if (destList.options[count] != null) { if (srcList.options[i].text == destList.options[count].text) { found = true; break; } } } if (found != true) { destList.options[len] = new Option(srcList.options[i].text, srcList.options[i].value); len++; } } } var srcList = document.user.sourc; var len = srcList.options.length; for(var i = (len-1); i >= 0; i--) { if((srcList.options[i] != null) && (srcList.options[i].selected == true)) { srcList.options[i] = null; } } } // Deletes from the destination list. function deleteFromDestList() { destList = document.user.dest; srcList = document.user.sourc; var len = srcList.length; for(var i = 0; i < destList.length; i++) { if ((destList.options[i] != null) && (destList.options[i].selected)) { //Check if this value already exist in the destList or not //if not then add it otherwise do not add it. //srcList.options[i] = null; var found = false; for(var count = 0; count < len; count++) { if (srcList.options[count] != null) { if (destList.options[i].text == srcList.options[count].text) { found = true; break; } } } if (found != true) { srcList.options[len] = new Option(destList.options[i].text, destList.options[i].value); len++; } } } var destList = document.user.dest; var len = destList.options.length; for(var i = (len-1); i >= 0; i--) { if ((destList.options[i] != null) && (destList.options[i].selected == true)) { destList.options[i] = null; } } } function selectbodies() { document.user.selectedbod.value=""; var leng=document.user.dest.length; for(var i=0; i<leng; i++){ document.user.dest[i].selected= true; var tess=document.user.dest[i].text; document.user.selectedbod.value=document.user.selectedbod.value+" * "+tess; } } </script> <script src="scripts/AC_RunActiveContent.js" type="text/javascript"></script> </head> <body> <form name="user" onSubmit="return valid()" action="myEditUser2.jsp" method="post"> <table width="840" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#999999"> <tr> <td align="center" valign="middle" class="style4 style10"><script type="text/javascript"> AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','900','height','100','src','images/bannerconsul','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','images/bannerconsul' ); //end AC code </script> <noscript> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="900" height="100"> <param name="movie" value="images/bannerconsul.swf" /> <param name="quality" value="high" /> <embed src="images/bannerconsul.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="900" height="100"></embed>
      </object>
      </noscript></td>
  </tr>
  <tr>
    <td>
    <table width="100%" border="0" cellpadding="2" cellspacing="2" class="style4">
      <tr>
        <td height="20" colspan="4" bgcolor="#C0C0C0" class="style1">Login Details</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td colspan="2">&nbsp;</td>
      </tr>
      <tr>
        <td width="2%">&nbsp;</td>
        <td width="26%">Username</td>
        <td width="29%">
		<input name="username" type="text" id="username" size="18" maxlength="15" value="<%=username%>" readonly="readonly"/><span class="style11">&nbsp;*</span></td>
        <td width="43%">Password Strength Meter. <a href="passwordstrength.jsp" target="page" onClick="window.open('forgotpassform.jsp','page','toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=0,width=400,height=500,left=50,top=50,titlebar=no')">Learn more</a></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">Password</td>
        <td>
		<input name="password" type="password" id="password" size="20" maxlength="8" onkeydown="passstrength();" value="<%=password%>"/><span class="style11">&nbsp;*</span></td>
        <td>
        <table border="0" cellspacing="0" cellpadding="0">
          <tr>            
            <td width="75" height="15" id="m1">&nbsp;</td>            
            <td width="75" height="15" id="m2">&nbsp;</td>            
            <td width="75" height="15" id="m3">&nbsp;</td>                       
          </tr>
        </table>        </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">&nbsp;</td>
        <td><span class="style12">Password must contain only 8 characters.</span></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">Confirm Password</td>
        <td>
		<input name="password2" type="password" id="password2" size="20" maxlength="8" value="<%=password2%>" /><span class="style11">&nbsp;*</span></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="4">&nbsp;</td>
        </tr>
    </table>    </td>
  </tr>
  
  <tr>
    <td>
    <table width="100%" border="0" cellpadding="2" cellspacing="2" class="style4">
      <tr>
        <td colspan="5" bgcolor="#C0C0C0" height="20"><span class="style1">Section 1: Company Details and General Information</span></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td colspan="3">&nbsp;</td>
      </tr>
      <tr>
        <td width="8">&nbsp;</td>
        <td width="277" class="style4">Name of Firm</td>
        <td colspan="3">
		<input name="namefirm" type="text" id="namefirm" size="80" maxlength="80" value="<%=namefirm%>" /><span class="style11">&nbsp;*</span></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">Business Address</td>
        <td colspan="3">
		<input name="bizadd" type="text" id="bizadd" size="80" maxlength="80" value="<%=bizadd%>" /><span class="style11">&nbsp;*</span></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">P.O Box &amp; Mailing Address</td>
        <td colspan="3">
		<input name="address" type="text" id="address" size="80" maxlength="80" value="<%=address%>" /><span class="style11">&nbsp;*</span></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">Telephone</td>
        <td colspan="3">
		<input name="telephone" type="text" id="telephone" size="20" maxlength="20" value="<%=telephone%>" /><span class="style11">&nbsp;*</span></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">Fax</td>
        <td colspan="3">
		<input name="fax" type="text" id="fax" size="20" maxlength="20" value="<%=fax%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">Email Address</td>
        <td colspan="3">
		<input name="email" type="text" id="email" size="50" maxlength="50" value="<%=email%>" /><span class="style11">&nbsp;*</span></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="style4">Country</td>
        <td colspan="3">
          <select name="country" id="country">
            <%
			while(resul4.next()){%>
    		<option value="<%=resul4.getString(2)%>"><%=resul4.getString(2)%></option>
   			<% } %>
          </select><span class="style11">&nbsp;*</span></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Website</td>
        <td colspan="3">
		<input name="website" type="text" id="website" size="50" maxlength="50" value="<%=website%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Year Established</td>
        <td colspan="3">
		<input name="yearest" type="text" id="yearest" size="12" maxlength="4" value="<%=yearest%>" /><span class="style11">&nbsp;*</span></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Years of experience in the current business</td>
        <td colspan="3">
		<input name="yearex" type="text" id="yearex" size="20" maxlength="4" value="<%=yearex%>" /></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>License No</td>
        <td colspan="3">
		<input name="license" type="text" id="license" size="20" maxlength="20" value="<%=license%>" /><span class="style11">&nbsp;*</span></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Licensing Authority</td>
        <td colspan="3">
		<input name="autho" type="text" id="autho" size="20" maxlength="20" value="<%=autho%>" /></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Business Reg. No</td>
        <td colspan="3">
		<input name="bizreg" type="text" id="bizreg" size="20" maxlength="20" value="<%=bizreg%>" /><span class="style11">&nbsp;*</span></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>No. of full-time Employees</td>
        <td colspan="3">
		<input name="noemp" type="text" id="noemp" size="20" maxlength="4" value="<%=noemp%>" /></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>VAT No</td>
        <td colspan="3">
		<input name="vat" type="text" id="vat" size="20" maxlength="20" value="<%=vat%>" /></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Tax Account No</td>
        <td colspan="3" valign="middle">
		<input name="tan" type="text" id="tan" size="20" maxlength="4" value="<%=tan%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Type of Business</td>
        <td width="147" valign="middle"><input type="radio" name="biztype" id="biztype3" value="corporate" onclick="checko();"/>          Corporate/Limited</td>
        <td width="182" valign="middle"><input type="radio" name="biztype" id="biztype2" value="partnership" onclick="checko();"/>
          Partnership</td>
        <td width="254" valign="middle"><input type="radio" name="biztype" id="biztype1" value="other" onclick="checko();"/>
          Other 
		<input name="biztypeo" type="text" id="biztypeo" size="20" maxlength="20" disabled="disabled" value="<%=biztypeo%>"/></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Types of consultancy
provided</td>
        <td><input type="radio" name="typecons" id="typecons" value="Firm" onclick="checkoc();"/>          
          Firm</td>
        <td><input type="radio" name="typecons" id="typecons1" value="Individual Consultant" onclick="checkoc();"/>
Individual Consultant</td>
        <td><input type="radio" name="typecons" id="typecons2" value="other" onclick="checkoc();"/>
          Other 
		<input name="typeconso" type="text" id="typeconso" size="20" maxlength="20" disabled="disabled" value="<%=typeconso%>"/></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="4">
        <table  border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td height="5"></td>
          </tr>
          <tr>
            <td>Names and Qualifications of main partners</td>
          </tr>
          <tr>
          <td height="5"></td>
          </tr>
          <tr>
            <td>&nbsp;&nbsp;<textarea name="qualification" id="qualification" cols="80" rows="5"><%=qualification%></textarea></td>
          </tr>
        </table>        </td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Parent Company (If Any)</td>
        <td colspan="3">
		<input name="parent" type="text" id="parent" size="70" maxlength="50" value="<%=parent%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Relation with Parent Co.</td>
        <td colspan="3"><input type="radio" name="relation" id="relation" value="corporate" />          
          Subsidiaries&nbsp;&nbsp;&nbsp;
          <input type="radio" name="relation" id="relation" value="Associates" />
          Associates&nbsp;&nbsp;&nbsp;
          <input type="radio" name="relation" id="relation" value="Joint Venture" /> 
          Joint Venture&nbsp;&nbsp;&nbsp;
          <input type="radio" name="relation" id="relation" value="Overseas Representative" /> 
          Overseas Representative</td>
      </tr>
      <tr>
        <td height="10">&nbsp;</td>
        <td height="10">&nbsp;</td>
        <td colspan="3" height="10">&nbsp;</td>
      </tr>
    </table>    </td>
  </tr>
  <tr>
    <td>
    <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
      <tr>
        <td height="20" colspan="4" bgcolor="#000000" class="style1 style7">Types of consultancy provided: Please select the type of services that you could provide.</td>
        </tr>
      <tr>
        <td height="10" valign="middle" class="style4"></td>
        <td height="10" valign="middle" class="style4"></td>
        <td height="10" valign="middle" class="style4"></td>
        <td height="10" valign="middle" class="style4"></td>
      </tr>
      <tr>
        <td width="12" valign="middle" class="style4">&nbsp;</td>
        <td width="273" valign="middle" class="style4"><input name="consultancy1" type="checkbox" id="consultancy1" value="Architectural Services" /> Architectural Services</td>
        <td width="252" valign="middle" class="style4"><input name="consultancy2" type="checkbox" id="consultancy2" value="Design Services" /> 
          Design Services</td>
        <td width="277" valign="middle" class="style4"><input name="consultancy3" type="checkbox" id="consultancy3" value="Engineering Services" /> Engineering Services</td>
      </tr>
      <tr>
        <td valign="middle" class="style4">&nbsp;</td>
        <td valign="middle" class="style4"><input name="consultancy4" type="checkbox" id="consultancy4" value="Financial Intermediation Services" />
Financial Intermediation Services</td>
        <td valign="middle" class="style4"><input name="consultancy5" type="checkbox" id="consultancy5" value="Financial Services" />
Financial Services</td>
        <td valign="middle" class="style4"><input name="consultancy6" type="checkbox" id="consultancy6" value="Integrated Engineering Services" />
Integrated Engineering Services</td>
      </tr>
      <tr>
        <td valign="middle" class="style4">&nbsp;</td>
        <td valign="middle" class="style4"><input name="consultancy7" type="checkbox" id="consultancy7" value="IT Services" /> 
          IT Services</td>
        <td valign="middle" class="style4"><input name="consultancy8" type="checkbox" id="consultancy8" value="Legal Services" />
Legal Services</td>
        <td valign="middle" class="style4"><input name="consultancy9" type="checkbox" id="consultancy9" value="Natural Resources Services" />
Natural Resources Services</td>
      </tr>
      <tr>
      <td valign="middle" class="style4">&nbsp;</td>
        <td colspan="3" valign="middle" class="style4"><input name="consultancy10" type="checkbox" id="consultancy10" value="Research and Development Services on Natural Sciences" /> 
        Research and Development Services on Natural Sciences</td>
        </tr>
      <tr>
      <td valign="middle" class="style4">&nbsp;</td>
        <td colspan="3" valign="middle" class="style4"><input name="consultancy11" type="checkbox" id="consultancy11" value="Research and Development Services on Social Sciences and Humanities" /> 
        Research and Development Services on Social Sciences and Humanities</td>
        </tr>
      <tr>
      <td valign="middle" class="style4">&nbsp;</td>
        <td colspan="3" valign="middle" class="style4"><input name="consultancy12" type="checkbox" id="consultancy12" value="Urban Planning and Landscape Services" /> 
        Urban Planning and Landscape Services</td>
        </tr>
      <tr>
      <td valign="middle" class="style4">&nbsp;</td>
        <td colspan="3" valign="middle" class="style4"><input name="consultancy13" type="checkbox" id="consultancy13" value="Other" onclick="checkcon();"/>
Other (Specify)&nbsp;&nbsp;&nbsp;&nbsp;
<input name="othercons" type="text" id="othercons" size="70" maxlength="50" disabled="disabled" value="<%=othercons%>"/></td>
        </tr>
      <tr>
        <td height="10" valign="middle" class="style4"></td>
        <td height="10" valign="middle" class="style4"></td>
        <td height="10" valign="middle" class="style4"></td>
        <td height="10" valign="middle" class="style4"></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td class="style1" height="20">
    <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
      <tr>
        <td colspan="3" bgcolor="#C0C0C0" class="style1" height="20">Section 2: Financial Information</td>
        </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td colspan="2" class="style4">&nbsp;</td>
      </tr>
      <tr>
        <td width="12" class="style4">&nbsp;</td>
        <td colspan="2" class="style4">Annual turnover for the last 3 years</td>
        </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td width="359" class="style4">Year&nbsp;&nbsp;<input name="turnoveryr1" type="text" id="turnoveryr1" size="12" maxlength="4" value="<%=turnoveryr1%>" /><span class="style11">&nbsp;*</span></td>
        <td width="449" class="style4">Rs.&nbsp;<input name="turnoveramt1" type="text" id="turnoveramt1" size="20" maxlength="12" value="<%=turnoveramt1%>" />&nbsp;&nbsp;million<span class="style11">&nbsp;*</span></td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">Year&nbsp;&nbsp;<input name="turnoveryr2" type="text" id="turnoveryr2" size="12" maxlength="4" value="<%=turnoveryr2%>" /></td>
        <td class="style4">Rs.&nbsp;<input name="turnoveramt2" type="text" id="turnoveramt2" size="20" maxlength="12" value="<%=turnoveramt2%>" />&nbsp;&nbsp;million</td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">Year&nbsp;&nbsp;<input name="turnoveryr3" type="text" id="turnoveryr3" size="12" maxlength="4" value="<%=turnoveryr3%>" /></td>
        <td class="style4">Rs.&nbsp;<input name="turnoveramt3" type="text" id="turnoveramt3" size="20" maxlength="12" value="<%=turnoveramt3%>" />&nbsp;&nbsp;million</td>
      </tr>

      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">&nbsp;</td>
        <td class="style4">&nbsp;</td>
      </tr>
    </table>    </td>
  </tr>  
  <tr>
    <td>
    <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
      <tr>
        <td height="20" colspan="2" bgcolor="#C0C0C0" class="style1">Section 3: Technical Capabilities and Information on Services Offered</td>
        </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">&nbsp;</td>
      </tr>
      <tr>
        <td class="style4" width="12">&nbsp;</td>
        <td class="style4">Quality Assurance Certification of Company (e.g. ISO 9000 or Equivalent)</td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">
		<input name="qualassu" type="text" id="qualassu" size="100" maxlength="100" value="<%=qualassu%>" /></td>
      </tr>
      <tr>
        <td class="style4" height="10"></td>
        <td class="style4" height="5"></td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">International Offices/Representation (Countries where the company has local/Offices/Representation)</td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">
		<input name="interoffice" type="text" id="interoffice" size="100" maxlength="100" value="<%=interoffice%>" /></td>
      </tr>
      <tr>
        <td class="style4" height="10"></td>
        <td class="style4"></td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">Do the Services provided conform to National/International Quality Standards?</td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4"><input type="radio" name="niqs" value="yes">&nbsp;&nbsp;Yes<br /><input type="radio" name="niqs" value="no">&nbsp;&nbsp;No</td>
      </tr>
      <tr>
        <td class="style4">&nbsp;</td>
        <td class="style4">&nbsp;</td>
      </tr>
    </table>    </td>
  </tr>
  <tr>
    <td>
    <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
      <tr>
        <td colspan="5" bgcolor="#C0C0C0" class="style1" height="20">Section 4: Experience</td>
        </tr>
      <tr>
        <td colspan="5">&nbsp;</td>
        </tr>
      <tr>
        <td width="11">&nbsp;</td>
        <td colspan="4">Recent Contracts with Public Bodies</td>
        </tr>
      <tr>
        <td align="center" valign="middle" width="11">&nbsp;</td>
        <td width="237" align="center" valign="middle">Organisation</td>
        <td width="167" align="center" valign="middle">Contract Value (Rs)</td>
        <td width="106" align="center" valign="middle">Year</td>
        <td width="287" align="center" valign="middle">Consultancy Services Provided</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td align="center" valign="middle">
		<input name="expeorg1" type="text" id="expeorg1" size="39" maxlength="12" value="<%=expeorg1%>" /></td>
        <td align="center" valign="middle">
		<input name="convalue1" type="text" id="convalue1" size="25" maxlength="12" value="<%=convalue1%>" /></td>
        <td align="center" valign="middle">
		<input name="contactyr1" type="text" id="contactyr1" size="15" maxlength="4" value="<%=contactyr1%>" /></td>
        <td align="center" valign="middle">
		<input name="conserv1" type="text" id="conserv1" size="41" maxlength="12" value="<%=conserv1%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td align="center" valign="middle">
		<input name="expeorg2" type="text" id="expeorg2" size="39" maxlength="12" value="<%=expeorg2%>" /></td>
        <td align="center" valign="middle">
		<input name="convalue2" type="text" id="convalue2" size="25" maxlength="12" value="<%=convalue2%>" /></td>
        <td align="center" valign="middle">
		<input name="contactyr2" type="text" id="contactyr2" size="15" maxlength="4" value="<%=contactyr2%>" /></td>
        <td align="center" valign="middle">
		<input name="conserv2" type="text" id="conserv2" size="41" maxlength="12" value="<%=conserv2%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td align="center" valign="middle">
		<input name="expeorg3" type="text" id="expeorg3" size="39" maxlength="12" value="<%=expeorg3%>" /></td>
        <td align="center" valign="middle">
		<input name="convalue3" type="text" id="convalue3" size="25" maxlength="12" value="<%=convalue3%>" /></td>
        <td align="center" valign="middle">
		<input name="contactyr3" type="text" id="contactyr3" size="15" maxlength="4" value="<%=contactyr3%>" /></td>
        <td align="center" valign="middle">
		<input name="conserv3" type="text" id="conserv3" size="41" maxlength="12" value="<%=conserv3%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td align="center" valign="middle">
		<input name="expeorg4" type="text" id="expeorg4" size="39" maxlength="12" value="<%=expeorg4%>" /></td>
        <td align="center" valign="middle">
		<input name="convalue4" type="text" id="convalue4" size="25" maxlength="12" value="<%=convalue4%>" /></td>
        <td align="center" valign="middle">
		<input name="contactyr4" type="text" id="contactyr4" size="15" maxlength="4" value="<%=contactyr4%>" /></td>
        <td align="center" valign="middle">
		<input name="conserv4" type="text" id="conserv4" size="41" maxlength="12" value="<%=conserv4%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td align="center" valign="middle">
		<input name="expeorg5" type="text" id="expeorg5" size="39" maxlength="12" value="<%=expeorg5%>" /></td>
        <td align="center" valign="middle">
		<input name="convalue5" type="text" id="convalue5" size="25" maxlength="12" value="<%=convalue5%>" /></td>
        <td align="center" valign="middle">
		<input name="contactyr5" type="text" id="contactyr5" size="15" maxlength="4" value="<%=contactyr5%>" /></td>
        <td align="center" valign="middle">
		<input name="conserv5" type="text" id="conserv5" size="41" maxlength="12" value="<%=conserv5%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td align="center" valign="middle">
		<input name="expeorg6" type="text" id="expeorg6" size="39" maxlength="12" value="<%=expeorg6%>" /></td>
        <td align="center" valign="middle">
		<input name="convalue6" type="text" id="convalue6" size="25" maxlength="12" value="<%=convalue6%>" /></td>
        <td align="center" valign="middle">
		<input name="contactyr6" type="text" id="contactyr6" size="15" maxlength="4" value="<%=contactyr6%>" /></td>
        <td align="center" valign="middle">
		<input name="conserv6" type="text" id="conserv6" size="41" maxlength="12" value="<%=conserv6%>" /></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td align="center" valign="middle">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td>
    <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
      <tr>
        <td height="20" colspan="3" bgcolor="#C0C0C0" class="style1">Section 5: Others</td>
        </tr>
      <tr>
        <td colspan="3">&nbsp;</td>
        </tr>
      <tr>
        <td width="12">&nbsp;</td>
        <td colspan="2">Please list any current legal disputes in which your company may be involved.</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2"><textarea name="legaldisp" id="legaldisp" cols="90" rows="3"><%=legaldisp%></textarea></td>
        </tr>
      <tr>
        <td height="10"></td>
        <td colspan="2"></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">List any national or international Trade or Professional Organisation of which your Company is a member.</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2"><textarea name="nitorg" id="nitorg" cols="90" rows="3"><%=nitorg%></textarea></td>
        </tr>
      <tr>
        <td height="10"></td>
        <td width="466"></td>
        <td width="342"></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">Any particular Ministry or Departments, Parastatal Body or Local Authority for which you would wish to be registered as Service Provider/Consultant.</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="2%">&nbsp;</td>
            <td width="40%"><div style="width:340px; overflow-x:auto"><select name="sourc" size="6" id="sourc" style="OVERFLOW: auto;width: 340px; margin: 0px 0 5px 0">
       				  <%
							for(int i=0;i<j;i++)
     						{
							String countr=usr[i];
							%>
							<OPTION selected> <%= countr %> </OPTION>
							<%}%>
                            </select>                  </div></td>
            <td width="6%"><input type="button" name="todest" id="todest" value=">>>" onClick="javascript:addSrcToDestList();"/><br /><br /><input type="button" name="tosourc" id="tosourc" value="<<<" onClick="javascript:deleteFromDestList();"/></td>
          <td width="52%"><select name="dest" size="6" multiple="multiple" id="dest" style="width: 340px; margin: 0px 0 5px 0">
                        </select>
              <input type="text" name="selectedbod" id="selectedbod" style="display:none"/></td>
          </tr>
          
        </table></td>
      </tr>
      <tr>
        <td height="10" colspan="3"></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Have you been disqualified by the Procurement Policy Office?</td>
        <td><input type="radio" name="disqual" value="yes">
        &nbsp;&nbsp;Yes&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="disqual" value="no">
        &nbsp;&nbsp;No</td>
      </tr>
      <tr>
        <td height="10" colspan="3"></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Have you been debarred by the Procurement Policy Office?</td>
        <td><input type="radio" name="debarred" value="yes">
        &nbsp;&nbsp;Yes&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="debarred" value="no">
        &nbsp;&nbsp;No</td>
      </tr>
      <tr>
        <td height="10"></td>
        <td height="10"></td>
        <td height="10"></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Have you been suspended by the Procurement Policy Office?</td>
        <td><input type="radio" name="suspend" value="yes">
        &nbsp;&nbsp;Yes&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="suspend" value="no">
        &nbsp;&nbsp;No</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">Certification</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">I, the undersigned, certify that the information provided in this form is correct, and in the event of changes details will be provided as soon as possible.</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2"><table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
          <tr>
            <td width="16%">Name</td>
            <td width="45%">
			<input name="certname" type="text" id="certname" size="40" maxlength="40" value="<%=certname%>" /><span class="style11">&nbsp;*</span></td>
            <td width="10%">&nbsp;</td>
            <td width="29%">&nbsp;</td>
          </tr>
          <tr>
            <td height="10"></td>
            <td height="10"></td>
            <td height="10"></td>
            <td height="10"></td>
          </tr>
          <tr>
            <td>Functional Title</td>
            <td>
			<input name="certfun" type="text" id="certfun" size="40" maxlength="40" value="<%=certfun%>" /><span class="style11">&nbsp;*</span></td>
            <td>Date</td>
            <td>
			<input name="certdate" type="text" id="certdate" size="20" maxlength="20" value="<%=certdate%>" readonly="readonly"/></td>
          </tr>
        </table></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td height="20" colspan="3" bgcolor="#000000"><span class="style7">Note:</span></td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">All procurement dealings will be guided by the Public Procurement Act 2006 and its corresponding Regulations 2008.</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Documents to be submitted upon request:</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td height="10" align="left" valign="top"></td>
        <td colspan="2"></td>
      </tr>
      <tr>
        <td align="left" valign="top"><img src="images/304.gif" width="5" height="12" /></td>
        <td colspan="2">A listing of reference sources for works performed by your firm within the last 12 weeks, Please also indicate fax numbers and contact person for your reference sources.</td>
        </tr>
      <tr>
        <td><img src="images/304.gif" width="5" height="12" /></td>
        <td colspan="2">A copy of the company's Annual Financial Report for the past 3 years.</td>
        </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td>
    <table width="100%" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <td width="50%" align="right"><input type="reset" name="Reset" id="Reset" value="Reset Form" onclick="resetpass();"/></td>
        <td align="left"><input type="submit" name="submit" id="submit" value="Submit Form" onclick="selectbodies();"/></td>
        </tr>
    </table></td>
  </tr>
</table>
</form>
</body>
</html>
You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article