Retrieve data from database with radio button

Question

ppomu 0 Newbie Poster

15 Years Ago

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>

java-jsp

2 Contributors
4 Replies
2K Views
3 Days Discussion Span
Latest Post 15 Years Ago Latest Post by ppomu

kvprajapati 1,826 Posting Genius

15 Years Ago

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.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

ppomu 0 Newbie Poster · Answer 1 · 2009-07-06T12:42:45+00:00

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>

kvprajapati 1,826 Posting Genius Team Colleague · Answer 2 · 2009-07-06T12:49:11+00:00

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?.

ppomu 0 Newbie Poster · Answer 3 · 2009-07-06T12:59:44+00:00

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>