Retrieve data from database with radio button

Question

ppomu 0 Newbie Poster

14 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>

jsp

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

All 4 Replies

kvprajapati 1,826 Posting Genius

14 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>

Retrieve data from database with radio button

Recommended Answers Collapse Answers

All 4 Replies

Recommended Answers