JSP RSS JSP RSS

Retrieve data from database with radio button

Reply

•
•
Join Date: Jul 2009
Posts: 4
Reputation: ppomu is an unknown quantity at this point 
Solved Threads: 0
ppomu ppomu is offline Offline
Newbie Poster

Retrieve data from database with radio button

 
0
  #1
Jul 3rd, 2009
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

html Syntax (Toggle Plain Text) 
  1. <td width="147" valign="middle"><input type="radio" name="biztype" id="biztype3" value="corporate" onclick="checko();"/>          Corporate/Limited</td>
  2.         <td width="182" valign="middle"><input type="radio" name="biztype" id="biztype2" value="partnership" onclick="checko();"/>
  3.           Partnership</td>
  4.         <td width="254" valign="middle"><input type="radio" name="biztype" id="biztype1" value="other" onclick="checko();"/>
  5.           Other 
  6. 		<input name="biztypeo" type="text" id="biztypeo" size="20" maxlength="20" disabled="disabled" value="<%=biztypeo%> "/></td>
Last edited by peter_budo; Jul 3rd, 2009 at 9:00 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.
Reply With Quote Quick reply to this message  
•
•
Join Date: Oct 2008
Posts: 2,428
Reputation: adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of 
Solved Threads: 434
adatapost's Avatar
adatapost adatapost is offline Offline
Nearly a Posting Maven

Re: Retrieve data from database with radio button

 
0
  #2
Jul 3rd, 2009
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.
Failure is not fatal, but failure to change might be. - John Wooden
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2009
Posts: 4
Reputation: ppomu is an unknown quantity at this point 
Solved Threads: 0
ppomu ppomu is offline Offline
Newbie Poster

Re: Retrieve data from database with radio button

 
0
  #3
Jul 6th, 2009
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)

*********************************
JSP Syntax (Toggle Plain Text) 
  1. <%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
  2. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  3. <%@ page import="java.util.*" %>
  4. <%@ page import="oracle.jdbc.pool.*" %>
  5. <%@ include file ="dbcon.jsp"%>
  6. <%
  7. String username = "";
  8. String password = "";
  9. String password2 = "";
  10. String namefirm = "";
  11. String bizadd = "";
  12. String address = "";
  13. String telephone = "";
  14. String fax = "";
  15. String country = "";
  16. String email = "";
  17. String website = "";
  18. String yearest = "";
  19. String license = "";
  20. String bizreg = "";
  21. String vat = "";
  22. String yearex = "";
  23. String autho = "";
  24. String noemp = "";
  25. String tan = "";
  26. String biztype = "";
  27. String biztypeo="";
  28. String typecons = "";
  29. String typeconso = "";
  30. String qualification = "";
  31. String parent = "";
  32. String relation = "";
  33. String consultancy1 = "";
  34. String consultancy2 = "";
  35. String consultancy3 = "";
  36. String consultancy4 = "";
  37. String consultancy5 = "";
  38. String consultancy6 = "";
  39. String consultancy7 = "";
  40. String consultancy8 = "";
  41. String consultancy9 = "";
  42. String consultancy10 = "";
  43. String consultancy11 = "";
  44. String consultancy12 = "";
  45. String consultancy13 = "";
  46. String othercons = "";
  47. String turnoveryr1 = "";
  48. String turnoveramt1 = "";
  49. String turnoveryr2 = "";
  50. String turnoveramt2 = "";
  51. String turnoveryr3 = "";
  52. String turnoveramt3 = "";
  53. String qualassu = "";
  54. String interoffice = "";
  55. String niqs = "";
  56. String expeorg1 = "";
  57. String convalue1 = "";
  58. String contactyr1 = "";
  59. String conserv1 = "";
  60. String expeorg2 = "";
  61. String convalue2 = "";
  62. String contactyr2 = "";
  63. String conserv2 = "";
  64. String expeorg3 = "";
  65. String convalue3 = "";
  66. String contactyr3 = "";
  67. String conserv3 = "";
  68. String expeorg4 = "";
  69. String convalue4 = "";
  70. String contactyr4 = "";
  71. String conserv4 = "";
  72. String expeorg5 = "";
  73. String convalue5 = "";
  74. String contactyr5 = "";
  75. String conserv5 = "";
  76. String expeorg6 = "";
  77. String convalue6 = "";
  78. String contactyr6 = "";
  79. String conserv6 = "";
  80. String legaldisp = "";
  81. String nitorg = "";
  82. String sprovider = "";
  83. String disqual = "";
  84. String debarred = "";
  85. String suspend = "";
  86. String certname = "";
  87. String certfun = "";
  88. String certdate = "";
  89. String regid = "";
  90.  
  91.  
  92. 	username = (String) session.getAttribute("username");
  93. 	String query = "SELECT * FROM TBL_PPO_USERS where USERNAME ='"+ username +"'";
  94. 	ResultSet resultSet = statement.executeQuery(query);
  95. 	if (resultSet.next()){
  96. 	username = resultSet.getString("USERNAME");
  97. 	password = resultSet.getString("PASSWORD");
  98. 	password2 = resultSet.getString("PASSWORD2");
  99. 	namefirm = resultSet.getString("NAMEFIRM");
  100. 	bizadd = resultSet.getString("BIZADD");
  101. 	address = resultSet.getString("ADDRESS");
  102. 	telephone = resultSet.getString("TELEPHONE");
  103. 	fax = resultSet.getString("FAX");
  104. 	email = resultSet.getString("EMAIL");
  105. 	country = resultSet.getString("COUNTRY");
  106. 	website = resultSet.getString("WEBSITE");
  107. 	yearest = resultSet.getString("YEAREST");
  108. 	yearex = resultSet.getString("YEAREX");
  109. 	license = resultSet.getString("LICENSE");
  110. 	autho = resultSet.getString("AUTHO");
  111. 	bizreg = resultSet.getString("BIZREG");
  112. 	noemp = resultSet.getString("NOEMP");
  113. 	vat = resultSet.getString("VAT");
  114. 	tan = resultSet.getString("TAN");
  115. 	biztype = resultSet.getString("BIZTYPE");
  116. 	biztypeo = resultSet.getString("BIZTYPEO");
  117. 	parent = resultSet.getString("PARENT");
  118. 	relation = resultSet.getString("RELATION");
  119. 	consultancy1 = resultSet.getString("CONSULTANCY1");
  120. 	consultancy2 = resultSet.getString("CONSULTANCY2");
  121. 	consultancy3 = resultSet.getString("CONSULTANCY3");
  122. 	consultancy4 = resultSet.getString("CONSULTANCY4");
  123. 	consultancy5 = resultSet.getString("CONSULTANCY5");
  124. 	consultancy6 = resultSet.getString("CONSULTANCY6");
  125. 	consultancy7 = resultSet.getString("CONSULTANCY7");
  126. 	consultancy8 = resultSet.getString("CONSULTANCY8");
  127. 	consultancy9 = resultSet.getString("CONSULTANCY9");
  128. 	consultancy10 = resultSet.getString("CONSULTANCY10");
  129. 	consultancy11 = resultSet.getString("CONSULTANCY11");
  130. 	consultancy12 = resultSet.getString("CONSULTANCY12");
  131. 	consultancy13 = resultSet.getString("CONSULTANCY13");
  132. 	turnoveryr1 = resultSet.getString("TURNOVERYR1");
  133. 	turnoveramt1 = resultSet.getString("TURNOVERAMT1");
  134. 	turnoveryr2 = resultSet.getString("TURNOVERYR2");
  135. 	turnoveramt2 = resultSet.getString("TURNOVERAMT2");
  136. 	turnoveryr3 = resultSet.getString("TURNOVERYR3");
  137. 	turnoveramt3 = resultSet.getString("TURNOVERAMT3");
  138. 	qualassu = resultSet.getString("QUALASSU");
  139. 	interoffice = resultSet.getString("INTEROFFICE");
  140. 		expeorg1=resultSet.getString("expeorg1");
  141. 		convalue1=resultSet.getString("convalue1");
  142. 		contactyr1=resultSet.getString("contactyr1");
  143. 		conserv1=resultSet.getString("conserv1");
  144. 		expeorg2=resultSet.getString("expeorg2");
  145. 		convalue2=resultSet.getString("convalue2");
  146. 		contactyr2=resultSet.getString("contactyr2");
  147. 		conserv2=resultSet.getString("conserv2");
  148. 		expeorg3=resultSet.getString("expeorg3");
  149. 		convalue3=resultSet.getString("convalue3");
  150. 		contactyr3=resultSet.getString("contactyr3");
  151. 		conserv3=resultSet.getString("conserv3");
  152. 		expeorg4=resultSet.getString("expeorg4");
  153. 		convalue4=resultSet.getString("convalue4");
  154. 		contactyr4=resultSet.getString("contactyr4");
  155. 		conserv4=resultSet.getString("conserv4");
  156. 		expeorg5=resultSet.getString("expeorg5");
  157. 		convalue5=resultSet.getString("convalue5");
  158. 		contactyr5=resultSet.getString("contactyr5");
  159. 		conserv5=resultSet.getString("conserv5");
  160. 		expeorg6=resultSet.getString("expeorg6");
  161. 		convalue6=resultSet.getString("convalue6");
  162. 		contactyr6=resultSet.getString("contactyr6");
  163. 		conserv6=resultSet.getString("conserv6");
  164. 		legaldisp=resultSet.getString("legaldisp");
  165. 		nitorg=resultSet.getString("nitorg");
  166. 		sprovider=resultSet.getString("sprovider");
  167. 		disqual=resultSet.getString("disqual");
  168. 		debarred=resultSet.getString("debarred");
  169. 		suspend=resultSet.getString("suspend");
  170. 		certname=resultSet.getString("certname");
  171. 		certfun=resultSet.getString("certfun");
  172. 		certdate=resultSet.getString("certdate");
  173. }
  174. %>
  175. <%									
  176. String SQL_STMT="SELECT * FROM TBL_PPO_DEPTS ORDER BY DEPTS ASC";
  177. ResultSet resul= statement2.executeQuery(SQL_STMT);
  178. ResultSet resul2 = statement3.executeQuery(SQL_STMT);
  179.  
  180. String SQL_STMT1="SELECT * FROM TBL_PPO_COUNTRY ORDER BY COUNTRY_NAME ASC";
  181. ResultSet resul4= statement.executeQuery(SQL_STMT1);
  182.  
  183. int j=0;
  184. while(resul2.next()){	
  185. j++;
  186. }
  187.  
  188. String[] usr= new String[j];
  189.  
  190. int k=0;
  191. while(resul.next()){	
  192. usr[k]=resul.getString(1);
  193. k++;
  194. }
  195. %>   
  196.  
  197. <head>
  198. <html xmlns="http://www.w3.org/1999/xhtml">
  199. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  200. <style type="text/css">
  201. <!--
  202. .style1 {
  203. 	color: #800000;
  204. 	font-family: Arial, Helvetica, sans-serif;
  205. 	font-weight: bold;
  206. 	font-style: italic;
  207. 	font-size: 14px;
  208. }
  209. .style4 {
  210. 	color:#000000;
  211. 	font-size: 12px;
  212. 	font-weight:normal;
  213. 	font-family: Verdana, Arial, Helvetica, sans-serif;
  214. }
  215. .style7 {color: #FFFFFF}
  216. .style10 {
  217. 	font-size: 16
  218. }
  219. .style11 {
  220. 	color: #FF0000;
  221. 	font-size: 12px;
  222. }
  223. .style12 {
  224. 	font-size: 10px;
  225. 	font-style: italic;
  226. 	color: #82AD5A;
  227. }
  228. -->
  229. </style>
  230. <SCRIPT language="javascript">
  231. function echeck(str) {
  232.  
  233. 	var at="@"
  234. 	var dot="."
  235. 	var lat=str.indexOf(at)
  236. 	var lstr=str.length
  237. 	var ldot=str.indexOf(dot)
  238. 	if (str.indexOf(at)==-1){
  239. 	   alert("Please enter a valid Email address")
  240. 	   return false
  241. 	}
  242.  
  243. 	if (str.indexOf(at)==-1 || str.indexOf(at)==0 || str.indexOf(at)==lstr){
  244. 	   alert("Please enter a valid Email address")
  245. 	   return false
  246. 	}
  247.  
  248. 	if (str.indexOf(dot)==-1 || str.indexOf(dot)==0 || str.indexOf(dot)==lstr){
  249. 	    alert("Please enter a valid Email address")
  250. 	    return false
  251. 	}
  252.  
  253. 	 if (str.indexOf(at,(lat+1))!=-1){
  254. 	    alert("Please enter a valid Email address")
  255. 	    return false
  256. 	 }
  257.  
  258. 	 if (str.substring(lat-1,lat)==dot || str.substring(lat+1,lat+2)==dot){
  259. 	    alert("Please enter a valid Email address")
  260. 	    return false
  261. 	 }
  262.  
  263. 	 if (str.indexOf(dot,(lat+2))==-1){
  264. 	    alert("Please enter a valid Email address")
  265. 	    return false
  266. 	 }
  267.  
  268. 	 if (str.indexOf(" ")!=-1){
  269. 	    alert("Please enter a valid Email address")
  270. 	    return false
  271. 	 }
  272.  
  273. 	 return true					
  274. }
  275.  
  276. function checkcon()
  277. {
  278. var conso=document.getElementById('consultancy13');
  279. if(conso.checked==false)
  280. {
  281. document.getElementById('othercons').value="";
  282. document.getElementById('othercons').disabled=true;
  283. }
  284.  
  285. if(conso.checked==true)
  286. {
  287. document.getElementById('othercons').disabled=false;
  288. }
  289. }
  290.  
  291. function checkoc()
  292. {
  293. var typeconsch=document.getElementById('typecons2');
  294. if(typeconsch.checked==false)
  295. {
  296. document.getElementById('typeconso').value="";
  297. document.getElementById('typeconso').disabled=true;
  298. }
  299.  
  300. if(typeconsch.checked==true)
  301. {
  302. document.getElementById('typeconso').disabled=false;
  303. }
  304. }
  305.  
  306. function checko()
  307. {
  308. var biztypech=document.getElementById('biztype1');
  309. if(biztypech.checked==false)
  310. {
  311. document.getElementById('biztypeo').value="";
  312. document.getElementById('biztypeo').disabled=true;
  313. }
  314.  
  315. if(biztypech.checked==true)
  316. {
  317. document.getElementById('biztypeo').disabled=false;
  318. }
  319. }
  320.  
  321. function resetpass()
  322. {
  323. document.getElementById('m1').style.backgroundImage = "";
  324. document.getElementById('m2').style.backgroundImage = "";
  325. document.getElementById('m3').style.backgroundImage = "";
  326. }
  327.  
  328. function passstrength()
  329. {
  330. document.getElementById('m1').style.backgroundImage = "";
  331. document.getElementById('m2').style.backgroundImage = "";
  332. document.getElementById('m3').style.backgroundImage = "";
  333. var spcheck=0;
  334. var nucheck=0;
  335. var upcheck=0;
  336. var opass=document.getElementById('password').value;
  337. var sChars = ["!","@","#","$","%","^","&",".","*","(",")","+","=","-","[","]",";",",",".","/","{","}","|",":","<",">","?","`","~","\\","'"];
  338. var nChars = ["0","1","2","3","4","5","6","7","8","9"];
  339. 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"];
  340. var carray=[];
  341.  
  342. if(opass.length<=8)
  343. {
  344. document.getElementById('m1').style.backgroundImage = "url(images/weak1.gif)";
  345.  
  346. 	for(var i=0;i<opass.length;i++)
  347. 	{
  348. 	carray[i]=opass.charAt(i);
  349. 	}
  350.  
  351. 	var spcheck=0;
  352. 	var nucheck=0;
  353. 	var upcheck=0;
  354.  
  355. 	for(var j=0;j<carray.length;j++)
  356. 	{	
  357. 		//Check input string for special characters--Start
  358. 		for(var k=0;k<sChars.length;k++)
  359. 		{		
  360. 			if (sChars[k]==carray[j])	
  361. 			{
  362. 			spcheck=spcheck+1;
  363. 			//alert(sChars[k]+" = "+carray[j]+" = "+spcheck);		
  364. 			}		
  365. 		}
  366. 		//Check input string for special characters--Stop
  367.  
  368. 		//Check input string for numeric characters--Start
  369. 		for(var l=0;l<nChars.length;l++)
  370. 		{		
  371. 			if (nChars[l]==carray[j])	
  372. 			{
  373. 			nucheck=nucheck+1;
  374. 			//alert(nChars[l]+" = "+carray[j]+" = "+nucheck);				
  375. 			}		
  376. 		}
  377. 		//Check input string for numeric characters--Stop
  378.  
  379. 		//Check input string for uppercase characters--Start
  380. 		for(var m=0;m<pChars.length;m++)
  381. 		{	
  382. 			if (pChars[m]==carray[j])	
  383. 			{
  384. 			upcheck=upcheck+1;
  385. 			//alert(pChars[m]+" = "+carray[j]+" = "+upcheck);				
  386. 			}
  387. 		}//Check input string for uppercase characters--Stop
  388. 	}
  389.  
  390. 	//Medium Password Test
  391. 	if (spcheck>=1 || nucheck>=1 ||upcheck>=1)
  392. 	{	
  393. 	document.getElementById('m1').style.backgroundImage = "";
  394. 	document.getElementById('m1').style.backgroundImage = "url(images/weak.gif)";		
  395. 	document.getElementById('m2').style.backgroundImage = "url(images/medium1.gif)";
  396. 	}
  397. 	//Medium Password Test
  398.  
  399. 	//Strong Password Test
  400. 	if (spcheck>0 && nucheck>0 && upcheck>0)
  401. 	{	
  402. 	document.getElementById('m1').style.backgroundImage = "";
  403. 	document.getElementById('m2').style.backgroundImage = "";
  404. 	document.getElementById('m1').style.backgroundImage = "url(images/weak.gif)";		
  405. 	document.getElementById('m2').style.backgroundImage = "url(images/medium.gif)";
  406. 	document.getElementById('m3').style.backgroundImage = "url(images/strong1.gif)";
  407. 	}
  408. 	//Strong Password Test
  409. }
  410. }
  411.  
  412. function valid()
  413. {
  414. 	if(document.user.username.value=="" || document.user.username.length==0)
  415. 	{
  416. 		alert("Username should not be left blank");
  417. 		document.user.username.focus();
  418. 		return false;
  419.  	}
  420.  
  421.  	if(document.user.password.value=="" || document.user.password.length==0)
  422. 	{
  423. 		alert("Password should not be left blank");
  424. 		document.user.password.focus();
  425. 		return false;
  426.  	}
  427.  
  428.  	if(document.user.password2.value=="" || document.user.password2.length==0)
  429. 	{
  430. 		alert("Please Re-type your password for confirmation");
  431. 		document.user.password2.focus();
  432. 		return false;
  433.  	}
  434.  
  435.  	if(document.user.password.value!=document.user.password2.value)
  436.        {
  437. 		 alert("The two passwords do not match. Please re-type your password.");
  438. 		 document.user.password2.value="";
  439. 		 document.user.password2.focus();
  440. 		 return false;
  441.         }
  442.  
  443.  
  444.  	if(document.user.namefirm.value=="")
  445. 	{
  446. 		alert("Name of firm should not be left blank");
  447. 		document.user.namefirm.focus();
  448. 		return false;
  449.  	}
  450.  
  451.  	if(document.user.bizadd.value=="")
  452. 	{
  453. 		alert("Business Address should not be left blank");
  454. 		document.user.bizadd.focus();
  455. 		return false;
  456.  	}
  457.  
  458.  
  459.   	if(document.user.address.value=="")
  460. 	{
  461. 		alert("Mailing Address should not be left blank");
  462. 		document.user.address.focus();
  463. 		return false;
  464.  	}
  465.  
  466.  	if(document.user.telephone.value=="")
  467. 	{
  468. 		alert("Telephone should not be left blank");
  469. 		document.user.telephone.focus();
  470. 		return false;
  471.  	}
  472.  
  473. 	if(document.user.email.value=="")
  474. 	{
  475. 		alert("Email should not be left blank");
  476. 		document.user.email.focus();
  477. 		return false;
  478.  	} 
  479.  
  480. 	 if (echeck(document.user.email.value)==false)
  481. 	 {				
  482. 		document.user.email.focus();
  483. 		return false;
  484. 	}	
  485.  
  486.  	if(document.user.yearest.value=="")
  487. 	{
  488. 		alert("Year established should not be left blank");
  489. 		document.user.yearest.focus();
  490. 		return false;
  491.  	}
  492.  
  493.  	if(document.user.license.value=="")
  494. 	{
  495. 		alert("License number should not be left blank");
  496. 		document.user.license.focus();
  497. 		return false;
  498.  	}
  499.  
  500.  	if(document.user.bizreg.value=="")
  501. 	{
  502. 		alert("Business registration number should not be left blank");
  503. 		document.user.bizreg.focus();
  504. 		return false;
  505.  	}
  506.  
  507.  	if(document.user.turnoveryr1.value=="")
  508. 	{
  509. 		alert("You must enter at least 1 year for turnover");
  510. 		document.user.turnoveryr1.focus();
  511. 		return false;
  512.  	}
  513.  
  514.  	if(document.user.turnoveramt1.value=="")
  515. 	{
  516. 		alert("You must enter amount for turnover");
  517. 		document.user.turnoveramt1.focus();
  518. 		return false;
  519.  	}
  520.  
  521.  	if(document.user.certname.value=="" || document.user.certname.length==0)
  522. 	{
  523. 		alert("Please enter Name for certification");
  524. 		document.user.certname.focus();
  525. 		return false;
  526.  	}
  527.  
  528.  	if(document.user.certfun.value=="" || document.user.certfun.length==0)
  529. 	{
  530. 		alert("Please enter Functional Title for certification");
  531. 		document.user.certfun.focus();
  532. 		return false;
  533.  	}
  534.  
  535. }
  536.  
  537. function addSrcToDestList()
  538. 			{
  539. 				destList = document.user.dest;
  540. 				srcList = document.user.sourc; 
  541. 				var len = destList.length;
  542. 				for(var i = 0; i < srcList.length; i++)
  543. 				{
  544. 					if ((srcList.options[i] != null) && (srcList.options[i].selected))
  545. 					{						
  546. 						var found = false;
  547. 						for(var count = 0; count < len; count++)
  548. 						{
  549. 							if (destList.options[count] != null)
  550. 							{
  551. 								if (srcList.options[i].text == destList.options[count].text)
  552. 								{
  553. 									found = true;
  554. 									break;
  555. 			      				}
  556. 			 			    }
  557. 						 }
  558. 						if (found != true)
  559. 						{
  560. 							destList.options[len] = new Option(srcList.options[i].text, srcList.options[i].value); 
  561. 							len++;
  562. 			    	    }
  563. 			      }     
  564. 			   }			   
  565. 			   var srcList  = document.user.sourc;
  566. 				var len = srcList.options.length;
  567. 				for(var i = (len-1); i >= 0; i--)
  568. 				{
  569. 			      if((srcList.options[i] != null) && (srcList.options[i].selected == true))
  570. 				  {
  571. 						srcList.options[i] = null;
  572.  			      }
  573. 			    }
  574. 			}
  575.  
  576.  
  577. 			// Deletes from the destination list.
  578. function deleteFromDestList()
  579. 			{
  580.  
  581. 				destList = document.user.dest;
  582. 				srcList = document.user.sourc; 
  583. 				var len = srcList.length;
  584. 				for(var i = 0; i < destList.length; i++)
  585. 				{
  586. 					if ((destList.options[i] != null) && (destList.options[i].selected))
  587. 					{
  588. 						//Check if this value already exist in the destList or not
  589. 						//if not then add it otherwise do not add it.
  590. 						//srcList.options[i] = null;
  591. 						var found = false;
  592. 						for(var count = 0; count < len; count++)
  593. 						{
  594. 							if (srcList.options[count] != null)
  595. 							{
  596. 								if (destList.options[i].text == srcList.options[count].text)
  597. 								{
  598. 									found = true;
  599. 									break;
  600. 			      				}
  601. 			 			    }
  602. 						 }
  603. 						if (found != true)
  604. 						{
  605. 							srcList.options[len] = new Option(destList.options[i].text, destList.options[i].value); 
  606. 							len++;
  607. 			    	    }
  608. 			      }
  609. 			}
  610.  
  611. 				var destList  = document.user.dest;
  612. 				var len = destList.options.length;
  613. 				for(var i = (len-1); i >= 0; i--)
  614. 				{
  615. 					if ((destList.options[i] != null) && (destList.options[i].selected == true))
  616. 					{
  617. 						destList.options[i] = null;
  618. 				    }
  619. 			    }
  620. 			}
  621.  
  622. function selectbodies()
  623. {
  624. document.user.selectedbod.value="";
  625. var leng=document.user.dest.length;
  626. for(var i=0; i<leng; i++){
  627.     document.user.dest[i].selected= true;
  628. 	var tess=document.user.dest[i].text;
  629. 	document.user.selectedbod.value=document.user.selectedbod.value+" * "+tess;
  630. 	}	
  631. }
  632. </script>
  633. <script src="scripts/AC_RunActiveContent.js" type="text/javascript"></script>
  634. </head>
  635. <body>
  636. <form name="user" onSubmit="return valid()" action="myEditUser2.jsp" method="post">
  637.   <table width="840" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#999999">
  638.   <tr>
  639.     <td align="center" valign="middle" class="style4 style10"><script type="text/javascript">
  640. 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
  641.     </script>
  642.       <noscript>
  643.       <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">
  644.         <param name="movie" value="images/bannerconsul.swf" />
  645.         <param name="quality" value="high" />
  646.         <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>
  647.       </object>
  648.       </noscript></td>
  649.   </tr>
  650.   <tr>
  651.     <td>
  652.     <table width="100%" border="0" cellpadding="2" cellspacing="2" class="style4">
  653.       <tr>
  654.         <td height="20" colspan="4" bgcolor="#C0C0C0" class="style1">Login Details</td>
  655.         </tr>
  656.       <tr>
  657.         <td>&nbsp;</td>
  658.         <td>&nbsp;</td>
  659.         <td colspan="2">&nbsp;</td>
  660.       </tr>
  661.       <tr>
  662.         <td width="2%">&nbsp;</td>
  663.         <td width="26%">Username</td>
  664.         <td width="29%">
  665. 		<input name="username" type="text" id="username" size="18" maxlength="15" value="<%=username%>" readonly="readonly"/><span class="style11">&nbsp;*</span></td>
  666.         <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>
  667.       </tr>
  668.       <tr>
  669.         <td>&nbsp;</td>
  670.         <td class="style4">Password</td>
  671.         <td>
  672. 		<input name="password" type="password" id="password" size="20" maxlength="8" onkeydown="passstrength();" value="<%=password%>"/><span class="style11">&nbsp;*</span></td>
  673.         <td>
  674.         <table border="0" cellspacing="0" cellpadding="0">
  675.           <tr>            
  676.             <td width="75" height="15" id="m1">&nbsp;</td>            
  677.             <td width="75" height="15" id="m2">&nbsp;</td>            
  678.             <td width="75" height="15" id="m3">&nbsp;</td>                       
  679.           </tr>
  680.         </table>        </td>
  681.       </tr>
  682.       <tr>
  683.         <td>&nbsp;</td>
  684.         <td class="style4">&nbsp;</td>
  685.         <td><span class="style12">Password must contain only 8 characters.</span></td>
  686.         <td>&nbsp;</td>
  687.       </tr>
  688.       <tr>
  689.         <td>&nbsp;</td>
  690.         <td class="style4">Confirm Password</td>
  691.         <td>
  692. 		<input name="password2" type="password" id="password2" size="20" maxlength="8" value="<%=password2%>" /><span class="style11">&nbsp;*</span></td>
  693.         <td>&nbsp;</td>
  694.       </tr>
  695.       <tr>
  696.         <td colspan="4">&nbsp;</td>
  697.         </tr>
  698.     </table>    </td>
  699.   </tr>
  700.  
  701.   <tr>
  702.     <td>
  703.     <table width="100%" border="0" cellpadding="2" cellspacing="2" class="style4">
  704.       <tr>
  705.         <td colspan="5" bgcolor="#C0C0C0" height="20"><span class="style1">Section 1: Company Details and General Information</span></td>
  706.         </tr>
  707.       <tr>
  708.         <td>&nbsp;</td>
  709.         <td>&nbsp;</td>
  710.         <td colspan="3">&nbsp;</td>
  711.       </tr>
  712.       <tr>
  713.         <td width="8">&nbsp;</td>
  714.         <td width="277" class="style4">Name of Firm</td>
  715.         <td colspan="3">
  716. 		<input name="namefirm" type="text" id="namefirm" size="80" maxlength="80" value="<%=namefirm%>" /><span class="style11">&nbsp;*</span></td>
  717.       </tr>
  718.       <tr>
  719.         <td>&nbsp;</td>
  720.         <td class="style4">Business Address</td>
  721.         <td colspan="3">
  722. 		<input name="bizadd" type="text" id="bizadd" size="80" maxlength="80" value="<%=bizadd%>" /><span class="style11">&nbsp;*</span></td>
  723.       </tr>
  724.       <tr>
  725.         <td>&nbsp;</td>
  726.         <td class="style4">P.O Box &amp; Mailing Address</td>
  727.         <td colspan="3">
  728. 		<input name="address" type="text" id="address" size="80" maxlength="80" value="<%=address%>" /><span class="style11">&nbsp;*</span></td>
  729.       </tr>
  730.       <tr>
  731.         <td>&nbsp;</td>
  732.         <td class="style4">Telephone</td>
  733.         <td colspan="3">
  734. 		<input name="telephone" type="text" id="telephone" size="20" maxlength="20" value="<%=telephone%>" /><span class="style11">&nbsp;*</span></td>
  735.       </tr>
  736.       <tr>
  737.         <td>&nbsp;</td>
  738.         <td class="style4">Fax</td>
  739.         <td colspan="3">
  740. 		<input name="fax" type="text" id="fax" size="20" maxlength="20" value="<%=fax%>" /></td>
  741.       </tr>
  742.       <tr>
  743.         <td>&nbsp;</td>
  744.         <td class="style4">Email Address</td>
  745.         <td colspan="3">
  746. 		<input name="email" type="text" id="email" size="50" maxlength="50" value="<%=email%>" /><span class="style11">&nbsp;*</span></td>
  747.       </tr>
  748.       <tr>
  749.         <td>&nbsp;</td>
  750.         <td class="style4">Country</td>
  751.         <td colspan="3">
  752.           <select name="country" id="country">
  753.             <%
  754. 			while(resul4.next()){%>
  755.     		<option value="<%=resul4.getString(2)%>"><%=resul4.getString(2)%></option>
  756.    			<% } %>
  757.           </select><span class="style11">&nbsp;*</span></td>
  758.       </tr>
  759.       <tr>
  760.         <td>&nbsp;</td>
  761.         <td>Website</td>
  762.         <td colspan="3">
  763. 		<input name="website" type="text" id="website" size="50" maxlength="50" value="<%=website%>" /></td>
  764.       </tr>
  765.       <tr>
  766.         <td>&nbsp;</td>
  767.         <td>Year Established</td>
  768.         <td colspan="3">
  769. 		<input name="yearest" type="text" id="yearest" size="12" maxlength="4" value="<%=yearest%>" /><span class="style11">&nbsp;*</span></td>
  770.         </tr>
  771.       <tr>
  772.         <td>&nbsp;</td>
  773.         <td>Years of experience in the current business</td>
  774.         <td colspan="3">
  775. 		<input name="yearex" type="text" id="yearex" size="20" maxlength="4" value="<%=yearex%>" /></td>
  776.         </tr>
  777.       <tr>
  778.         <td>&nbsp;</td>
  779.         <td>License No</td>
  780.         <td colspan="3">
  781. 		<input name="license" type="text" id="license" size="20" maxlength="20" value="<%=license%>" /><span class="style11">&nbsp;*</span></td>
  782.         </tr>
  783.       <tr>
  784.         <td>&nbsp;</td>
  785.         <td>Licensing Authority</td>
  786.         <td colspan="3">
  787. 		<input name="autho" type="text" id="autho" size="20" maxlength="20" value="<%=autho%>" /></td>
  788.         </tr>
  789.       <tr>
  790.         <td>&nbsp;</td>
  791.         <td>Business Reg. No</td>
  792.         <td colspan="3">
  793. 		<input name="bizreg" type="text" id="bizreg" size="20" maxlength="20" value="<%=bizreg%>" /><span class="style11">&nbsp;*</span></td>
  794.         </tr>
  795.       <tr>
  796.         <td>&nbsp;</td>
  797.         <td>No. of full-time Employees</td>
  798.         <td colspan="3">
  799. 		<input name="noemp" type="text" id="noemp" size="20" maxlength="4" value="<%=noemp%>" /></td>
  800.         </tr>
  801.       <tr>
  802.         <td>&nbsp;</td>
  803.         <td>VAT No</td>
  804.         <td colspan="3">
  805. 		<input name="vat" type="text" id="vat" size="20" maxlength="20" value="<%=vat%>" /></td>
  806.         </tr>
  807.       <tr>
  808.         <td>&nbsp;</td>
  809.         <td>Tax Account No</td>
  810.         <td colspan="3" valign="middle">
  811. 		<input name="tan" type="text" id="tan" size="20" maxlength="4" value="<%=tan%>" /></td>
  812.       </tr>
  813.       <tr>
  814.         <td>&nbsp;</td>
  815.         <td>Type of Business</td>
  816.         <td width="147" valign="middle"><input type="radio" name="biztype" id="biztype3" value="corporate" onclick="checko();"/>          Corporate/Limited</td>
  817.         <td width="182" valign="middle"><input type="radio" name="biztype" id="biztype2" value="partnership" onclick="checko();"/>
  818.           Partnership</td>
  819.         <td width="254" valign="middle"><input type="radio" name="biztype" id="biztype1" value="other" onclick="checko();"/>
  820.           Other 
  821. 		<input name="biztypeo" type="text" id="biztypeo" size="20" maxlength="20" disabled="disabled" value="<%=biztypeo%>"/></td>
  822.       </tr>
  823.       <tr>
  824.         <td>&nbsp;</td>
  825.         <td>Types of consultancy
  826. provided</td>
  827.         <td><input type="radio" name="typecons" id="typecons" value="Firm" onclick="checkoc();"/>          
  828.           Firm</td>
  829.         <td><input type="radio" name="typecons" id="typecons1" value="Individual Consultant" onclick="checkoc();"/>
  830. Individual Consultant</td>
  831.         <td><input type="radio" name="typecons" id="typecons2" value="other" onclick="checkoc();"/>
  832.           Other 
  833. 		<input name="typeconso" type="text" id="typeconso" size="20" maxlength="20" disabled="disabled" value="<%=typeconso%>"/></td>
  834.       </tr>
  835.       <tr>
  836.         <td>&nbsp;</td>
  837.         <td colspan="4">
  838.         <table  border="0" width="100%" cellspacing="0" cellpadding="0">
  839.           <tr>
  840.             <td height="5"></td>
  841.           </tr>
  842.           <tr>
  843.             <td>Names and Qualifications of main partners</td>
  844.           </tr>
  845.           <tr>
  846.           <td height="5"></td>
  847.           </tr>
  848.           <tr>
  849.             <td>&nbsp;&nbsp;<textarea name="qualification" id="qualification" cols="80" rows="5"><%=qualification%></textarea></td>
  850.           </tr>
  851.         </table>        </td>
  852.         </tr>
  853.       <tr>
  854.         <td>&nbsp;</td>
  855.         <td>Parent Company (If Any)</td>
  856.         <td colspan="3">
  857. 		<input name="parent" type="text" id="parent" size="70" maxlength="50" value="<%=parent%>" /></td>
  858.       </tr>
  859.       <tr>
  860.         <td>&nbsp;</td>
  861.         <td>Relation with Parent Co.</td>
  862.         <td colspan="3"><input type="radio" name="relation" id="relation" value="corporate" />          
  863.           Subsidiaries&nbsp;&nbsp;&nbsp;
  864.           <input type="radio" name="relation" id="relation" value="Associates" />
  865.           Associates&nbsp;&nbsp;&nbsp;
  866.           <input type="radio" name="relation" id="relation" value="Joint Venture" /> 
  867.           Joint Venture&nbsp;&nbsp;&nbsp;
  868.           <input type="radio" name="relation" id="relation" value="Overseas Representative" /> 
  869.           Overseas Representative</td>
  870.       </tr>
  871.       <tr>
  872.         <td height="10">&nbsp;</td>
  873.         <td height="10">&nbsp;</td>
  874.         <td colspan="3" height="10">&nbsp;</td>
  875.       </tr>
  876.     </table>    </td>
  877.   </tr>
  878.   <tr>
  879.     <td>
  880.     <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
  881.       <tr>
  882.         <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>
  883.         </tr>
  884.       <tr>
  885.         <td height="10" valign="middle" class="style4"></td>
  886.         <td height="10" valign="middle" class="style4"></td>
  887.         <td height="10" valign="middle" class="style4"></td>
  888.         <td height="10" valign="middle" class="style4"></td>
  889.       </tr>
  890.       <tr>
  891.         <td width="12" valign="middle" class="style4">&nbsp;</td>
  892.         <td width="273" valign="middle" class="style4"><input name="consultancy1" type="checkbox" id="consultancy1" value="Architectural Services" /> Architectural Services</td>
  893.         <td width="252" valign="middle" class="style4"><input name="consultancy2" type="checkbox" id="consultancy2" value="Design Services" /> 
  894.           Design Services</td>
  895.         <td width="277" valign="middle" class="style4"><input name="consultancy3" type="checkbox" id="consultancy3" value="Engineering Services" /> Engineering Services</td>
  896.       </tr>
  897.       <tr>
  898.         <td valign="middle" class="style4">&nbsp;</td>
  899.         <td valign="middle" class="style4"><input name="consultancy4" type="checkbox" id="consultancy4" value="Financial Intermediation Services" />
  900. Financial Intermediation Services</td>
  901.         <td valign="middle" class="style4"><input name="consultancy5" type="checkbox" id="consultancy5" value="Financial Services" />
  902. Financial Services</td>
  903.         <td valign="middle" class="style4"><input name="consultancy6" type="checkbox" id="consultancy6" value="Integrated Engineering Services" />
  904. Integrated Engineering Services</td>
  905.       </tr>
  906.       <tr>
  907.         <td valign="middle" class="style4">&nbsp;</td>
  908.         <td valign="middle" class="style4"><input name="consultancy7" type="checkbox" id="consultancy7" value="IT Services" /> 
  909.           IT Services</td>
  910.         <td valign="middle" class="style4"><input name="consultancy8" type="checkbox" id="consultancy8" value="Legal Services" />
  911. Legal Services</td>
  912.         <td valign="middle" class="style4"><input name="consultancy9" type="checkbox" id="consultancy9" value="Natural Resources Services" />
  913. Natural Resources Services</td>
  914.       </tr>
  915.       <tr>
  916.       <td valign="middle" class="style4">&nbsp;</td>
  917.         <td colspan="3" valign="middle" class="style4"><input name="consultancy10" type="checkbox" id="consultancy10" value="Research and Development Services on Natural Sciences" /> 
  918.         Research and Development Services on Natural Sciences</td>
  919.         </tr>
  920.       <tr>
  921.       <td valign="middle" class="style4">&nbsp;</td>
  922.         <td colspan="3" valign="middle" class="style4"><input name="consultancy11" type="checkbox" id="consultancy11" value="Research and Development Services on Social Sciences and Humanities" /> 
  923.         Research and Development Services on Social Sciences and Humanities</td>
  924.         </tr>
  925.       <tr>
  926.       <td valign="middle" class="style4">&nbsp;</td>
  927.         <td colspan="3" valign="middle" class="style4"><input name="consultancy12" type="checkbox" id="consultancy12" value="Urban Planning and Landscape Services" /> 
  928.         Urban Planning and Landscape Services</td>
  929.         </tr>
  930.       <tr>
  931.       <td valign="middle" class="style4">&nbsp;</td>
  932.         <td colspan="3" valign="middle" class="style4"><input name="consultancy13" type="checkbox" id="consultancy13" value="Other" onclick="checkcon();"/>
  933. Other (Specify)&nbsp;&nbsp;&nbsp;&nbsp;
  934. <input name="othercons" type="text" id="othercons" size="70" maxlength="50" disabled="disabled" value="<%=othercons%>"/></td>
  935.         </tr>
  936.       <tr>
  937.         <td height="10" valign="middle" class="style4"></td>
  938.         <td height="10" valign="middle" class="style4"></td>
  939.         <td height="10" valign="middle" class="style4"></td>
  940.         <td height="10" valign="middle" class="style4"></td>
  941.       </tr>
  942.     </table></td>
  943.   </tr>
  944.   <tr>
  945.     <td class="style1" height="20">
  946.     <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
  947.       <tr>
  948.         <td colspan="3" bgcolor="#C0C0C0" class="style1" height="20">Section 2: Financial Information</td>
  949.         </tr>
  950.       <tr>
  951.         <td class="style4">&nbsp;</td>
  952.         <td colspan="2" class="style4">&nbsp;</td>
  953.       </tr>
  954.       <tr>
  955.         <td width="12" class="style4">&nbsp;</td>
  956.         <td colspan="2" class="style4">Annual turnover for the last 3 years</td>
  957.         </tr>
  958.       <tr>
  959.         <td class="style4">&nbsp;</td>
  960.         <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>
  961.         <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>
  962.       </tr>
  963.       <tr>
  964.         <td class="style4">&nbsp;</td>
  965.         <td class="style4">Year&nbsp;&nbsp;<input name="turnoveryr2" type="text" id="turnoveryr2" size="12" maxlength="4" value="<%=turnoveryr2%>" /></td>
  966.         <td class="style4">Rs.&nbsp;<input name="turnoveramt2" type="text" id="turnoveramt2" size="20" maxlength="12" value="<%=turnoveramt2%>" />&nbsp;&nbsp;million</td>
  967.       </tr>
  968.       <tr>
  969.         <td class="style4">&nbsp;</td>
  970.         <td class="style4">Year&nbsp;&nbsp;<input name="turnoveryr3" type="text" id="turnoveryr3" size="12" maxlength="4" value="<%=turnoveryr3%>" /></td>
  971.         <td class="style4">Rs.&nbsp;<input name="turnoveramt3" type="text" id="turnoveramt3" size="20" maxlength="12" value="<%=turnoveramt3%>" />&nbsp;&nbsp;million</td>
  972.       </tr>
  973.  
  974.       <tr>
  975.         <td class="style4">&nbsp;</td>
  976.         <td class="style4">&nbsp;</td>
  977.         <td class="style4">&nbsp;</td>
  978.       </tr>
  979.     </table>    </td>
  980.   </tr>  
  981.   <tr>
  982.     <td>
  983.     <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
  984.       <tr>
  985.         <td height="20" colspan="2" bgcolor="#C0C0C0" class="style1">Section 3: Technical Capabilities and Information on Services Offered</td>
  986.         </tr>
  987.       <tr>
  988.         <td class="style4">&nbsp;</td>
  989.         <td class="style4">&nbsp;</td>
  990.       </tr>
  991.       <tr>
  992.         <td class="style4" width="12">&nbsp;</td>
  993.         <td class="style4">Quality Assurance Certification of Company (e.g. ISO 9000 or Equivalent)</td>
  994.       </tr>
  995.       <tr>
  996.         <td class="style4">&nbsp;</td>
  997.         <td class="style4">
  998. 		<input name="qualassu" type="text" id="qualassu" size="100" maxlength="100" value="<%=qualassu%>" /></td>
  999.       </tr>
  1000.       <tr>
  1001.         <td class="style4" height="10"></td>
  1002.         <td class="style4" height="5"></td>
  1003.       </tr>
  1004.       <tr>
  1005.         <td class="style4">&nbsp;</td>
  1006.         <td class="style4">International Offices/Representation (Countries where the company has local/Offices/Representation)</td>
  1007.       </tr>
  1008.       <tr>
  1009.         <td class="style4">&nbsp;</td>
  1010.         <td class="style4">
  1011. 		<input name="interoffice" type="text" id="interoffice" size="100" maxlength="100" value="<%=interoffice%>" /></td>
  1012.       </tr>
  1013.       <tr>
  1014.         <td class="style4" height="10"></td>
  1015.         <td class="style4"></td>
  1016.       </tr>
  1017.       <tr>
  1018.         <td class="style4">&nbsp;</td>
  1019.         <td class="style4">Do the Services provided conform to National/International Quality Standards?</td>
  1020.       </tr>
  1021.       <tr>
  1022.         <td class="style4">&nbsp;</td>
  1023.         <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>
  1024.       </tr>
  1025.       <tr>
  1026.         <td class="style4">&nbsp;</td>
  1027.         <td class="style4">&nbsp;</td>
  1028.       </tr>
  1029.     </table>    </td>
  1030.   </tr>
  1031.   <tr>
  1032.     <td>
  1033.     <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
  1034.       <tr>
  1035.         <td colspan="5" bgcolor="#C0C0C0" class="style1" height="20">Section 4: Experience</td>
  1036.         </tr>
  1037.       <tr>
  1038.         <td colspan="5">&nbsp;</td>
  1039.         </tr>
  1040.       <tr>
  1041.         <td width="11">&nbsp;</td>
  1042.         <td colspan="4">Recent Contracts with Public Bodies</td>
  1043.         </tr>
  1044.       <tr>
  1045.         <td align="center" valign="middle" width="11">&nbsp;</td>
  1046.         <td width="237" align="center" valign="middle">Organisation</td>
  1047.         <td width="167" align="center" valign="middle">Contract Value (Rs)</td>
  1048.         <td width="106" align="center" valign="middle">Year</td>
  1049.         <td width="287" align="center" valign="middle">Consultancy Services Provided</td>
  1050.       </tr>
  1051.       <tr>
  1052.         <td>&nbsp;</td>
  1053.         <td align="center" valign="middle">
  1054. 		<input name="expeorg1" type="text" id="expeorg1" size="39" maxlength="12" value="<%=expeorg1%>" /></td>
  1055.         <td align="center" valign="middle">
  1056. 		<input name="convalue1" type="text" id="convalue1" size="25" maxlength="12" value="<%=convalue1%>" /></td>
  1057.         <td align="center" valign="middle">
  1058. 		<input name="contactyr1" type="text" id="contactyr1" size="15" maxlength="4" value="<%=contactyr1%>" /></td>
  1059.         <td align="center" valign="middle">
  1060. 		<input name="conserv1" type="text" id="conserv1" size="41" maxlength="12" value="<%=conserv1%>" /></td>
  1061.       </tr>
  1062.       <tr>
  1063.         <td>&nbsp;</td>
  1064.         <td align="center" valign="middle">
  1065. 		<input name="expeorg2" type="text" id="expeorg2" size="39" maxlength="12" value="<%=expeorg2%>" /></td>
  1066.         <td align="center" valign="middle">
  1067. 		<input name="convalue2" type="text" id="convalue2" size="25" maxlength="12" value="<%=convalue2%>" /></td>
  1068.         <td align="center" valign="middle">
  1069. 		<input name="contactyr2" type="text" id="contactyr2" size="15" maxlength="4" value="<%=contactyr2%>" /></td>
  1070.         <td align="center" valign="middle">
  1071. 		<input name="conserv2" type="text" id="conserv2" size="41" maxlength="12" value="<%=conserv2%>" /></td>
  1072.       </tr>
  1073.       <tr>
  1074.         <td>&nbsp;</td>
  1075.         <td align="center" valign="middle">
  1076. 		<input name="expeorg3" type="text" id="expeorg3" size="39" maxlength="12" value="<%=expeorg3%>" /></td>
  1077.         <td align="center" valign="middle">
  1078. 		<input name="convalue3" type="text" id="convalue3" size="25" maxlength="12" value="<%=convalue3%>" /></td>
  1079.         <td align="center" valign="middle">
  1080. 		<input name="contactyr3" type="text" id="contactyr3" size="15" maxlength="4" value="<%=contactyr3%>" /></td>
  1081.         <td align="center" valign="middle">
  1082. 		<input name="conserv3" type="text" id="conserv3" size="41" maxlength="12" value="<%=conserv3%>" /></td>
  1083.       </tr>
  1084.       <tr>
  1085.         <td>&nbsp;</td>
  1086.         <td align="center" valign="middle">
  1087. 		<input name="expeorg4" type="text" id="expeorg4" size="39" maxlength="12" value="<%=expeorg4%>" /></td>
  1088.         <td align="center" valign="middle">
  1089. 		<input name="convalue4" type="text" id="convalue4" size="25" maxlength="12" value="<%=convalue4%>" /></td>
  1090.         <td align="center" valign="middle">
  1091. 		<input name="contactyr4" type="text" id="contactyr4" size="15" maxlength="4" value="<%=contactyr4%>" /></td>
  1092.         <td align="center" valign="middle">
  1093. 		<input name="conserv4" type="text" id="conserv4" size="41" maxlength="12" value="<%=conserv4%>" /></td>
  1094.       </tr>
  1095.       <tr>
  1096.         <td>&nbsp;</td>
  1097.         <td align="center" valign="middle">
  1098. 		<input name="expeorg5" type="text" id="expeorg5" size="39" maxlength="12" value="<%=expeorg5%>" /></td>
  1099.         <td align="center" valign="middle">
  1100. 		<input name="convalue5" type="text" id="convalue5" size="25" maxlength="12" value="<%=convalue5%>" /></td>
  1101.         <td align="center" valign="middle">
  1102. 		<input name="contactyr5" type="text" id="contactyr5" size="15" maxlength="4" value="<%=contactyr5%>" /></td>
  1103.         <td align="center" valign="middle">
  1104. 		<input name="conserv5" type="text" id="conserv5" size="41" maxlength="12" value="<%=conserv5%>" /></td>
  1105.       </tr>
  1106.       <tr>
  1107.         <td>&nbsp;</td>
  1108.         <td align="center" valign="middle">
  1109. 		<input name="expeorg6" type="text" id="expeorg6" size="39" maxlength="12" value="<%=expeorg6%>" /></td>
  1110.         <td align="center" valign="middle">
  1111. 		<input name="convalue6" type="text" id="convalue6" size="25" maxlength="12" value="<%=convalue6%>" /></td>
  1112.         <td align="center" valign="middle">
  1113. 		<input name="contactyr6" type="text" id="contactyr6" size="15" maxlength="4" value="<%=contactyr6%>" /></td>
  1114.         <td align="center" valign="middle">
  1115. 		<input name="conserv6" type="text" id="conserv6" size="41" maxlength="12" value="<%=conserv6%>" /></td>
  1116.       </tr>
  1117.       <tr>
  1118.         <td>&nbsp;</td>
  1119.         <td>&nbsp;</td>
  1120.         <td>&nbsp;</td>
  1121.         <td>&nbsp;</td>
  1122.         <td align="center" valign="middle">&nbsp;</td>
  1123.       </tr>
  1124.     </table></td>
  1125.   </tr>
  1126.   <tr>
  1127.     <td>
  1128.     <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
  1129.       <tr>
  1130.         <td height="20" colspan="3" bgcolor="#C0C0C0" class="style1">Section 5: Others</td>
  1131.         </tr>
  1132.       <tr>
  1133.         <td colspan="3">&nbsp;</td>
  1134.         </tr>
  1135.       <tr>
  1136.         <td width="12">&nbsp;</td>
  1137.         <td colspan="2">Please list any current legal disputes in which your company may be involved.</td>
  1138.         </tr>
  1139.       <tr>
  1140.         <td>&nbsp;</td>
  1141.         <td colspan="2"><textarea name="legaldisp" id="legaldisp" cols="90" rows="3"><%=legaldisp%></textarea></td>
  1142.         </tr>
  1143.       <tr>
  1144.         <td height="10"></td>
  1145.         <td colspan="2"></td>
  1146.       </tr>
  1147.       <tr>
  1148.         <td>&nbsp;</td>
  1149.         <td colspan="2">List any national or international Trade or Professional Organisation of which your Company is a member.</td>
  1150.         </tr>
  1151.       <tr>
  1152.         <td>&nbsp;</td>
  1153.         <td colspan="2"><textarea name="nitorg" id="nitorg" cols="90" rows="3"><%=nitorg%></textarea></td>
  1154.         </tr>
  1155.       <tr>
  1156.         <td height="10"></td>
  1157.         <td width="466"></td>
  1158.         <td width="342"></td>
  1159.       </tr>
  1160.       <tr>
  1161.         <td>&nbsp;</td>
  1162.         <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>
  1163.         </tr>
  1164.       <tr>
  1165.         <td>&nbsp;</td>
  1166.         <td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
  1167.           <tr>
  1168.             <td width="2%">&nbsp;</td>
  1169.             <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">
  1170.        				  <%
  1171. 							for(int i=0;i<j;i++)
  1172.      						{
  1173. 							String countr=usr[i];
  1174. 							%>
  1175. 							<OPTION selected> <%= countr %> </OPTION>
  1176. 							<%}%>
  1177.                             </select>                  </div></td>
  1178.             <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>
  1179.           <td width="52%"><select name="dest" size="6" multiple="multiple" id="dest" style="width: 340px; margin: 0px 0 5px 0">
  1180.                         </select>
  1181.               <input type="text" name="selectedbod" id="selectedbod" style="display:none"/></td>
  1182.           </tr>
  1183.  
  1184.         </table></td>
  1185.       </tr>
  1186.       <tr>
  1187.         <td height="10" colspan="3"></td>
  1188.         </tr>
  1189.       <tr>
  1190.         <td>&nbsp;</td>
  1191.         <td>Have you been disqualified by the Procurement Policy Office?</td>
  1192.         <td><input type="radio" name="disqual" value="yes">
  1193.         &nbsp;&nbsp;Yes&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="disqual" value="no">
  1194.         &nbsp;&nbsp;No</td>
  1195.       </tr>
  1196.       <tr>
  1197.         <td height="10" colspan="3"></td>
  1198.         </tr>
  1199.       <tr>
  1200.         <td>&nbsp;</td>
  1201.         <td>Have you been debarred by the Procurement Policy Office?</td>
  1202.         <td><input type="radio" name="debarred" value="yes">
  1203.         &nbsp;&nbsp;Yes&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="debarred" value="no">
  1204.         &nbsp;&nbsp;No</td>
  1205.       </tr>
  1206.       <tr>
  1207.         <td height="10"></td>
  1208.         <td height="10"></td>
  1209.         <td height="10"></td>
  1210.       </tr>
  1211.       <tr>
  1212.         <td>&nbsp;</td>
  1213.         <td>Have you been suspended by the Procurement Policy Office?</td>
  1214.         <td><input type="radio" name="suspend" value="yes">
  1215.         &nbsp;&nbsp;Yes&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="suspend" value="no">
  1216.         &nbsp;&nbsp;No</td>
  1217.       </tr>
  1218.       <tr>
  1219.         <td>&nbsp;</td>
  1220.         <td>&nbsp;</td>
  1221.         <td>&nbsp;</td>
  1222.       </tr>
  1223.       <tr>
  1224.         <td>&nbsp;</td>
  1225.         <td colspan="2">Certification</td>
  1226.         </tr>
  1227.       <tr>
  1228.         <td>&nbsp;</td>
  1229.         <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>
  1230.         </tr>
  1231.       <tr>
  1232.         <td>&nbsp;</td>
  1233.         <td colspan="2"><table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
  1234.           <tr>
  1235.             <td width="16%">Name</td>
  1236.             <td width="45%">
  1237. 			<input name="certname" type="text" id="certname" size="40" maxlength="40" value="<%=certname%>" /><span class="style11">&nbsp;*</span></td>
  1238.             <td width="10%">&nbsp;</td>
  1239.             <td width="29%">&nbsp;</td>
  1240.           </tr>
  1241.           <tr>
  1242.             <td height="10"></td>
  1243.             <td height="10"></td>
  1244.             <td height="10"></td>
  1245.             <td height="10"></td>
  1246.           </tr>
  1247.           <tr>
  1248.             <td>Functional Title</td>
  1249.             <td>
  1250. 			<input name="certfun" type="text" id="certfun" size="40" maxlength="40" value="<%=certfun%>" /><span class="style11">&nbsp;*</span></td>
  1251.             <td>Date</td>
  1252.             <td>
  1253. 			<input name="certdate" type="text" id="certdate" size="20" maxlength="20" value="<%=certdate%>" readonly="readonly"/></td>
  1254.           </tr>
  1255.         </table></td>
  1256.         </tr>
  1257.       <tr>
  1258.         <td>&nbsp;</td>
  1259.         <td>&nbsp;</td>
  1260.         <td>&nbsp;</td>
  1261.       </tr>
  1262.       <tr>
  1263.         <td height="20" colspan="3" bgcolor="#000000"><span class="style7">Note:</span></td>
  1264.         </tr>
  1265.       <tr>
  1266.         <td>&nbsp;</td>
  1267.         <td colspan="2">All procurement dealings will be guided by the Public Procurement Act 2006 and its corresponding Regulations 2008.</td>
  1268.         </tr>
  1269.       <tr>
  1270.         <td>&nbsp;</td>
  1271.         <td>&nbsp;</td>
  1272.         <td>&nbsp;</td>
  1273.       </tr>
  1274.       <tr>
  1275.         <td>&nbsp;</td>
  1276.         <td>Documents to be submitted upon request:</td>
  1277.         <td>&nbsp;</td>
  1278.       </tr>
  1279.       <tr>
  1280.         <td height="10" align="left" valign="top"></td>
  1281.         <td colspan="2"></td>
  1282.       </tr>
  1283.       <tr>
  1284.         <td align="left" valign="top"><img src="images/304.gif" width="5" height="12" /></td>
  1285.         <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>
  1286.         </tr>
  1287.       <tr>
  1288.         <td><img src="images/304.gif" width="5" height="12" /></td>
  1289.         <td colspan="2">A copy of the company's Annual Financial Report for the past 3 years.</td>
  1290.         </tr>
  1291.       <tr>
  1292.         <td>&nbsp;</td>
  1293.         <td colspan="2">&nbsp;</td>
  1294.       </tr>
  1295.     </table></td>
  1296.   </tr>
  1297.   <tr>
  1298.     <td>
  1299.     <table width="100%" border="0" cellspacing="2" cellpadding="2">
  1300.       <tr>
  1301.         <td width="50%" align="right"><input type="reset" name="Reset" id="Reset" value="Reset Form" onclick="resetpass();"/></td>
  1302.         <td align="left"><input type="submit" name="submit" id="submit" value="Submit Form" onclick="selectbodies();"/></td>
  1303.         </tr>
  1304.     </table></td>
  1305.   </tr>
  1306. </table>
  1307. </form>
  1308. </body>
  1309. </html>
  1310.  
Last edited by peter_budo; Jul 6th, 2009 at 5:17 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.
Reply With Quote Quick reply to this message  
•
•
Join Date: Oct 2008
Posts: 2,428
Reputation: adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of 
Solved Threads: 434
adatapost's Avatar
adatapost adatapost is offline Offline
Nearly a Posting Maven

Re: Retrieve data from database with radio button

 
0
  #4
Jul 6th, 2009
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?.
Failure is not fatal, but failure to change might be. - John Wooden
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2009
Posts: 4
Reputation: ppomu is an unknown quantity at this point 
Solved Threads: 0
ppomu ppomu is offline Offline
Newbie Poster

Re: Retrieve data from database with radio button

 
0
  #5
Jul 6th, 2009
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

JSP Syntax (Toggle Plain Text) 
  1.  
  2. <%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  4. <%@ page import="java.util.*" %>
  5. <%@ page import="oracle.jdbc.pool.*" %>
  6. <%@ include file ="dbcon.jsp"%>
  7. <%
  8. String username = "";
  9. String password = "";
  10. String password2 = "";
  11. String namefirm = "";
  12. String bizadd = "";
  13. String address = "";
  14. String telephone = "";
  15. String fax = "";
  16. String country = "";
  17. String email = "";
  18. String website = "";
  19. String yearest = "";
  20. String license = "";
  21. String bizreg = "";
  22. String vat = "";
  23. String yearex = "";
  24. String autho = "";
  25. String noemp = "";
  26. String tan = "";
  27. String biztype = "";
  28. String biztypeo="";
  29. String typecons = "";
  30. String typeconso = "";
  31. String qualification = "";
  32. String parent = "";
  33. String relation = "";
  34. String consultancy1 = "";
  35. String consultancy2 = "";
  36. String consultancy3 = "";
  37. String consultancy4 = "";
  38. String consultancy5 = "";
  39. String consultancy6 = "";
  40. String consultancy7 = "";
  41. String consultancy8 = "";
  42. String consultancy9 = "";
  43. String consultancy10 = "";
  44. String consultancy11 = "";
  45. String consultancy12 = "";
  46. String consultancy13 = "";
  47. String othercons = "";
  48. String turnoveryr1 = "";
  49. String turnoveramt1 = "";
  50. String turnoveryr2 = "";
  51. String turnoveramt2 = "";
  52. String turnoveryr3 = "";
  53. String turnoveramt3 = "";
  54. String qualassu = "";
  55. String interoffice = "";
  56. String niqs = "";
  57. String expeorg1 = "";
  58. String convalue1 = "";
  59. String contactyr1 = "";
  60. String conserv1 = "";
  61. String expeorg2 = "";
  62. String convalue2 = "";
  63. String contactyr2 = "";
  64. String conserv2 = "";
  65. String expeorg3 = "";
  66. String convalue3 = "";
  67. String contactyr3 = "";
  68. String conserv3 = "";
  69. String expeorg4 = "";
  70. String convalue4 = "";
  71. String contactyr4 = "";
  72. String conserv4 = "";
  73. String expeorg5 = "";
  74. String convalue5 = "";
  75. String contactyr5 = "";
  76. String conserv5 = "";
  77. String expeorg6 = "";
  78. String convalue6 = "";
  79. String contactyr6 = "";
  80. String conserv6 = "";
  81. String legaldisp = "";
  82. String nitorg = "";
  83. String sprovider = "";
  84. String disqual = "";
  85. String debarred = "";
  86. String suspend = "";
  87. String certname = "";
  88. String certfun = "";
  89. String certdate = "";
  90. String regid = "";
  91.  
  92.  
  93. 	username = (String) session.getAttribute("username");
  94. 	String query = "SELECT * FROM TBL_PPO_USERS where USERNAME ='"+ username +"'";
  95. 	ResultSet resultSet = statement.executeQuery(query);
  96. 	if (resultSet.next()){
  97. 	username = resultSet.getString("USERNAME");
  98. 	password = resultSet.getString("PASSWORD");
  99. 	password2 = resultSet.getString("PASSWORD2");
  100. 	namefirm = resultSet.getString("NAMEFIRM");
  101. 	bizadd = resultSet.getString("BIZADD");
  102. 	address = resultSet.getString("ADDRESS");
  103. 	telephone = resultSet.getString("TELEPHONE");
  104. 	fax = resultSet.getString("FAX");
  105. 	email = resultSet.getString("EMAIL");
  106. 	country = resultSet.getString("COUNTRY");
  107. 	website = resultSet.getString("WEBSITE");
  108. 	yearest = resultSet.getString("YEAREST");
  109. 	yearex = resultSet.getString("YEAREX");
  110. 	license = resultSet.getString("LICENSE");
  111. 	autho = resultSet.getString("AUTHO");
  112. 	bizreg = resultSet.getString("BIZREG");
  113. 	noemp = resultSet.getString("NOEMP");
  114. 	vat = resultSet.getString("VAT");
  115. 	tan = resultSet.getString("TAN");
  116. 	biztype = resultSet.getString("BIZTYPE");
  117. 	biztypeo = resultSet.getString("BIZTYPEO");
  118. 	parent = resultSet.getString("PARENT");
  119. 	relation = resultSet.getString("RELATION");
  120. 	consultancy1 = resultSet.getString("CONSULTANCY1");
  121. 	consultancy2 = resultSet.getString("CONSULTANCY2");
  122. 	consultancy3 = resultSet.getString("CONSULTANCY3");
  123. 	consultancy4 = resultSet.getString("CONSULTANCY4");
  124. 	consultancy5 = resultSet.getString("CONSULTANCY5");
  125. 	consultancy6 = resultSet.getString("CONSULTANCY6");
  126. 	consultancy7 = resultSet.getString("CONSULTANCY7");
  127. 	consultancy8 = resultSet.getString("CONSULTANCY8");
  128. 	consultancy9 = resultSet.getString("CONSULTANCY9");
  129. 	consultancy10 = resultSet.getString("CONSULTANCY10");
  130. 	consultancy11 = resultSet.getString("CONSULTANCY11");
  131. 	consultancy12 = resultSet.getString("CONSULTANCY12");
  132. 	consultancy13 = resultSet.getString("CONSULTANCY13");
  133. 	turnoveryr1 = resultSet.getString("TURNOVERYR1");
  134. 	turnoveramt1 = resultSet.getString("TURNOVERAMT1");
  135. 	turnoveryr2 = resultSet.getString("TURNOVERYR2");
  136. 	turnoveramt2 = resultSet.getString("TURNOVERAMT2");
  137. 	turnoveryr3 = resultSet.getString("TURNOVERYR3");
  138. 	turnoveramt3 = resultSet.getString("TURNOVERAMT3");
  139. 	qualassu = resultSet.getString("QUALASSU");
  140. 	interoffice = resultSet.getString("INTEROFFICE");
  141. 		expeorg1=resultSet.getString("expeorg1");
  142. 		convalue1=resultSet.getString("convalue1");
  143. 		contactyr1=resultSet.getString("contactyr1");
  144. 		conserv1=resultSet.getString("conserv1");
  145. 		expeorg2=resultSet.getString("expeorg2");
  146. 		convalue2=resultSet.getString("convalue2");
  147. 		contactyr2=resultSet.getString("contactyr2");
  148. 		conserv2=resultSet.getString("conserv2");
  149. 		expeorg3=resultSet.getString("expeorg3");
  150. 		convalue3=resultSet.getString("convalue3");
  151. 		contactyr3=resultSet.getString("contactyr3");
  152. 		conserv3=resultSet.getString("conserv3");
  153. 		expeorg4=resultSet.getString("expeorg4");
  154. 		convalue4=resultSet.getString("convalue4");
  155. 		contactyr4=resultSet.getString("contactyr4");
  156. 		conserv4=resultSet.getString("conserv4");
  157. 		expeorg5=resultSet.getString("expeorg5");
  158. 		convalue5=resultSet.getString("convalue5");
  159. 		contactyr5=resultSet.getString("contactyr5");
  160. 		conserv5=resultSet.getString("conserv5");
  161. 		expeorg6=resultSet.getString("expeorg6");
  162. 		convalue6=resultSet.getString("convalue6");
  163. 		contactyr6=resultSet.getString("contactyr6");
  164. 		conserv6=resultSet.getString("conserv6");
  165. 		legaldisp=resultSet.getString("legaldisp");
  166. 		nitorg=resultSet.getString("nitorg");
  167. 		sprovider=resultSet.getString("sprovider");
  168. 		disqual=resultSet.getString("disqual");
  169. 		debarred=resultSet.getString("debarred");
  170. 		suspend=resultSet.getString("suspend");
  171. 		certname=resultSet.getString("certname");
  172. 		certfun=resultSet.getString("certfun");
  173. 		certdate=resultSet.getString("certdate");
  174. }
  175. %>
  176. <%									
  177. String SQL_STMT="SELECT * FROM TBL_PPO_DEPTS ORDER BY DEPTS ASC";
  178. ResultSet resul= statement2.executeQuery(SQL_STMT);
  179. ResultSet resul2 = statement3.executeQuery(SQL_STMT);
  180.  
  181. String SQL_STMT1="SELECT * FROM TBL_PPO_COUNTRY ORDER BY COUNTRY_NAME ASC";
  182. ResultSet resul4= statement.executeQuery(SQL_STMT1);
  183.  
  184. int j=0;
  185. while(resul2.next()){	
  186. j++;
  187. }
  188.  
  189. String[] usr= new String[j];
  190.  
  191. int k=0;
  192. while(resul.next()){	
  193. usr[k]=resul.getString(1);
  194. k++;
  195. }
  196. %>   
  197.  
  198. <head>
  199. <html xmlns="http://www.w3.org/1999/xhtml">
  200. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  201. <style type="text/css">
  202. <!--
  203. .style1 {
  204. 	color: #800000;
  205. 	font-family: Arial, Helvetica, sans-serif;
  206. 	font-weight: bold;
  207. 	font-style: italic;
  208. 	font-size: 14px;
  209. }
  210. .style4 {
  211. 	color:#000000;
  212. 	font-size: 12px;
  213. 	font-weight:normal;
  214. 	font-family: Verdana, Arial, Helvetica, sans-serif;
  215. }
  216. .style7 {color: #FFFFFF}
  217. .style10 {
  218. 	font-size: 16
  219. }
  220. .style11 {
  221. 	color: #FF0000;
  222. 	font-size: 12px;
  223. }
  224. .style12 {
  225. 	font-size: 10px;
  226. 	font-style: italic;
  227. 	color: #82AD5A;
  228. }
  229. -->
  230. </style>
  231. <SCRIPT language="javascript">
  232. function echeck(str) {
  233.  
  234. 	var at="@"
  235. 	var dot="."
  236. 	var lat=str.indexOf(at)
  237. 	var lstr=str.length
  238. 	var ldot=str.indexOf(dot)
  239. 	if (str.indexOf(at)==-1){
  240. 	   alert("Please enter a valid Email address")
  241. 	   return false
  242. 	}
  243.  
  244. 	if (str.indexOf(at)==-1 || str.indexOf(at)==0 || str.indexOf(at)==lstr){
  245. 	   alert("Please enter a valid Email address")
  246. 	   return false
  247. 	}
  248.  
  249. 	if (str.indexOf(dot)==-1 || str.indexOf(dot)==0 || str.indexOf(dot)==lstr){
  250. 	    alert("Please enter a valid Email address")
  251. 	    return false
  252. 	}
  253.  
  254. 	 if (str.indexOf(at,(lat+1))!=-1){
  255. 	    alert("Please enter a valid Email address")
  256. 	    return false
  257. 	 }
  258.  
  259. 	 if (str.substring(lat-1,lat)==dot || str.substring(lat+1,lat+2)==dot){
  260. 	    alert("Please enter a valid Email address")
  261. 	    return false
  262. 	 }
  263.  
  264. 	 if (str.indexOf(dot,(lat+2))==-1){
  265. 	    alert("Please enter a valid Email address")
  266. 	    return false
  267. 	 }
  268.  
  269. 	 if (str.indexOf(" ")!=-1){
  270. 	    alert("Please enter a valid Email address")
  271. 	    return false
  272. 	 }
  273.  
  274. 	 return true					
  275. }
  276.  
  277. function checkcon()
  278. {
  279. var conso=document.getElementById('consultancy13');
  280. if(conso.checked==false)
  281. {
  282. document.getElementById('othercons').value="";
  283. document.getElementById('othercons').disabled=true;
  284. }
  285.  
  286. if(conso.checked==true)
  287. {
  288. document.getElementById('othercons').disabled=false;
  289. }
  290. }
  291.  
  292. function checkoc()
  293. {
  294. var typeconsch=document.getElementById('typecons2');
  295. if(typeconsch.checked==false)
  296. {
  297. document.getElementById('typeconso').value="";
  298. document.getElementById('typeconso').disabled=true;
  299. }
  300.  
  301. if(typeconsch.checked==true)
  302. {
  303. document.getElementById('typeconso').disabled=false;
  304. }
  305. }
  306.  
  307. function checko()
  308. {
  309. var biztypech=document.getElementById('biztype1');
  310. if(biztypech.checked==false)
  311. {
  312. document.getElementById('biztypeo').value="";
  313. document.getElementById('biztypeo').disabled=true;
  314. }
  315.  
  316. if(biztypech.checked==true)
  317. {
  318. document.getElementById('biztypeo').disabled=false;
  319. }
  320. }
  321.  
  322. function resetpass()
  323. {
  324. document.getElementById('m1').style.backgroundImage = "";
  325. document.getElementById('m2').style.backgroundImage = "";
  326. document.getElementById('m3').style.backgroundImage = "";
  327. }
  328.  
  329. function passstrength()
  330. {
  331. document.getElementById('m1').style.backgroundImage = "";
  332. document.getElementById('m2').style.backgroundImage = "";
  333. document.getElementById('m3').style.backgroundImage = "";
  334. var spcheck=0;
  335. var nucheck=0;
  336. var upcheck=0;
  337. var opass=document.getElementById('password').value;
  338. var sChars = ["!","@","#","$","%","^","&",".","*","(",")","+","=","-","[","]",";",",",".","/","{","}","|",":","<",">","?","`","~","\\","'"];
  339. var nChars = ["0","1","2","3","4","5","6","7","8","9"];
  340. 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"];
  341. var carray=[];
  342.  
  343. if(opass.length<=8)
  344. {
  345. document.getElementById('m1').style.backgroundImage = "url(images/weak1.gif)";
  346.  
  347. 	for(var i=0;i<opass.length;i++)
  348. 	{
  349. 	carray[i]=opass.charAt(i);
  350. 	}
  351.  
  352. 	var spcheck=0;
  353. 	var nucheck=0;
  354. 	var upcheck=0;
  355.  
  356. 	for(var j=0;j<carray.length;j++)
  357. 	{	
  358. 		//Check input string for special characters--Start
  359. 		for(var k=0;k<sChars.length;k++)
  360. 		{		
  361. 			if (sChars[k]==carray[j])	
  362. 			{
  363. 			spcheck=spcheck+1;
  364. 			//alert(sChars[k]+" = "+carray[j]+" = "+spcheck);		
  365. 			}		
  366. 		}
  367. 		//Check input string for special characters--Stop
  368.  
  369. 		//Check input string for numeric characters--Start
  370. 		for(var l=0;l<nChars.length;l++)
  371. 		{		
  372. 			if (nChars[l]==carray[j])	
  373. 			{
  374. 			nucheck=nucheck+1;
  375. 			//alert(nChars[l]+" = "+carray[j]+" = "+nucheck);				
  376. 			}		
  377. 		}
  378. 		//Check input string for numeric characters--Stop
  379.  
  380. 		//Check input string for uppercase characters--Start
  381. 		for(var m=0;m<pChars.length;m++)
  382. 		{	
  383. 			if (pChars[m]==carray[j])	
  384. 			{
  385. 			upcheck=upcheck+1;
  386. 			//alert(pChars[m]+" = "+carray[j]+" = "+upcheck);				
  387. 			}
  388. 		}//Check input string for uppercase characters--Stop
  389. 	}
  390.  
  391. 	//Medium Password Test
  392. 	if (spcheck>=1 || nucheck>=1 ||upcheck>=1)
  393. 	{	
  394. 	document.getElementById('m1').style.backgroundImage = "";
  395. 	document.getElementById('m1').style.backgroundImage = "url(images/weak.gif)";		
  396. 	document.getElementById('m2').style.backgroundImage = "url(images/medium1.gif)";
  397. 	}
  398. 	//Medium Password Test
  399.  
  400. 	//Strong Password Test
  401. 	if (spcheck>0 && nucheck>0 && upcheck>0)
  402. 	{	
  403. 	document.getElementById('m1').style.backgroundImage = "";
  404. 	document.getElementById('m2').style.backgroundImage = "";
  405. 	document.getElementById('m1').style.backgroundImage = "url(images/weak.gif)";		
  406. 	document.getElementById('m2').style.backgroundImage = "url(images/medium.gif)";
  407. 	document.getElementById('m3').style.backgroundImage = "url(images/strong1.gif)";
  408. 	}
  409. 	//Strong Password Test
  410. }
  411. }
  412.  
  413. function valid()
  414. {
  415. 	if(document.user.username.value=="" || document.user.username.length==0)
  416. 	{
  417. 		alert("Username should not be left blank");
  418. 		document.user.username.focus();
  419. 		return false;
  420.  	}
  421.  
  422.  	if(document.user.password.value=="" || document.user.password.length==0)
  423. 	{
  424. 		alert("Password should not be left blank");
  425. 		document.user.password.focus();
  426. 		return false;
  427.  	}
  428.  
  429.  	if(document.user.password2.value=="" || document.user.password2.length==0)
  430. 	{
  431. 		alert("Please Re-type your password for confirmation");
  432. 		document.user.password2.focus();
  433. 		return false;
  434.  	}
  435.  
  436.  	if(document.user.password.value!=document.user.password2.value)
  437.        {
  438. 		 alert("The two passwords do not match. Please re-type your password.");
  439. 		 document.user.password2.value="";
  440. 		 document.user.password2.focus();
  441. 		 return false;
  442.         }
  443.  
  444.  
  445.  	if(document.user.namefirm.value=="")
  446. 	{
  447. 		alert("Name of firm should not be left blank");
  448. 		document.user.namefirm.focus();
  449. 		return false;
  450.  	}
  451.  
  452.  	if(document.user.bizadd.value=="")
  453. 	{
  454. 		alert("Business Address should not be left blank");
  455. 		document.user.bizadd.focus();
  456. 		return false;
  457.  	}
  458.  
  459.  
  460.   	if(document.user.address.value=="")
  461. 	{
  462. 		alert("Mailing Address should not be left blank");
  463. 		document.user.address.focus();
  464. 		return false;
  465.  	}
  466.  
  467.  	if(document.user.telephone.value=="")
  468. 	{
  469. 		alert("Telephone should not be left blank");
  470. 		document.user.telephone.focus();
  471. 		return false;
  472.  	}
  473.  
  474. 	if(document.user.email.value=="")
  475. 	{
  476. 		alert("Email should not be left blank");
  477. 		document.user.email.focus();
  478. 		return false;
  479.  	} 
  480.  
  481. 	 if (echeck(document.user.email.value)==false)
  482. 	 {				
  483. 		document.user.email.focus();
  484. 		return false;
  485. 	}	
  486.  
  487.  	if(document.user.yearest.value=="")
  488. 	{
  489. 		alert("Year established should not be left blank");
  490. 		document.user.yearest.focus();
  491. 		return false;
  492.  	}
  493.  
  494.  	if(document.user.license.value=="")
  495. 	{
  496. 		alert("License number should not be left blank");
  497. 		document.user.license.focus();
  498. 		return false;
  499.  	}
  500.  
  501.  	if(document.user.bizreg.value=="")
  502. 	{
  503. 		alert("Business registration number should not be left blank");
  504. 		document.user.bizreg.focus();
  505. 		return false;
  506.  	}
  507.  
  508.  	if(document.user.turnoveryr1.value=="")
  509. 	{
  510. 		alert("You must enter at least 1 year for turnover");
  511. 		document.user.turnoveryr1.focus();
  512. 		return false;
  513.  	}
  514.  
  515.  	if(document.user.turnoveramt1.value=="")
  516. 	{
  517. 		alert("You must enter amount for turnover");
  518. 		document.user.turnoveramt1.focus();
  519. 		return false;
  520.  	}
  521.  
  522.  	if(document.user.certname.value=="" || document.user.certname.length==0)
  523. 	{
  524. 		alert("Please enter Name for certification");
  525. 		document.user.certname.focus();
  526. 		return false;
  527.  	}
  528.  
  529.  	if(document.user.certfun.value=="" || document.user.certfun.length==0)
  530. 	{
  531. 		alert("Please enter Functional Title for certification");
  532. 		document.user.certfun.focus();
  533. 		return false;
  534.  	}
  535.  
  536. }
  537.  
  538. function addSrcToDestList()
  539. 			{
  540. 				destList = document.user.dest;
  541. 				srcList = document.user.sourc; 
  542. 				var len = destList.length;
  543. 				for(var i = 0; i < srcList.length; i++)
  544. 				{
  545. 					if ((srcList.options[i] != null) && (srcList.options[i].selected))
  546. 					{						
  547. 						var found = false;
  548. 						for(var count = 0; count < len; count++)
  549. 						{
  550. 							if (destList.options[count] != null)
  551. 							{
  552. 								if (srcList.options[i].text == destList.options[count].text)
  553. 								{
  554. 									found = true;
  555. 									break;
  556. 			      				}
  557. 			 			    }
  558. 						 }
  559. 						if (found != true)
  560. 						{
  561. 							destList.options[len] = new Option(srcList.options[i].text, srcList.options[i].value); 
  562. 							len++;
  563. 			    	    }
  564. 			      }     
  565. 			   }			   
  566. 			   var srcList  = document.user.sourc;
  567. 				var len = srcList.options.length;
  568. 				for(var i = (len-1); i >= 0; i--)
  569. 				{
  570. 			      if((srcList.options[i] != null) && (srcList.options[i].selected == true))
  571. 				  {
  572. 						srcList.options[i] = null;
  573.  			      }
  574. 			    }
  575. 			}
  576.  
  577.  
  578. 			// Deletes from the destination list.
  579. function deleteFromDestList()
  580. 			{
  581.  
  582. 				destList = document.user.dest;
  583. 				srcList = document.user.sourc; 
  584. 				var len = srcList.length;
  585. 				for(var i = 0; i < destList.length; i++)
  586. 				{
  587. 					if ((destList.options[i] != null) && (destList.options[i].selected))
  588. 					{
  589. 						//Check if this value already exist in the destList or not
  590. 						//if not then add it otherwise do not add it.
  591. 						//srcList.options[i] = null;
  592. 						var found = false;
  593. 						for(var count = 0; count < len; count++)
  594. 						{
  595. 							if (srcList.options[count] != null)
  596. 							{
  597. 								if (destList.options[i].text == srcList.options[count].text)
  598. 								{
  599. 									found = true;
  600. 									break;
  601. 			      				}
  602. 			 			    }
  603. 						 }
  604. 						if (found != true)
  605. 						{
  606. 							srcList.options[len] = new Option(destList.options[i].text, destList.options[i].value); 
  607. 							len++;
  608. 			    	    }
  609. 			      }
  610. 			}
  611.  
  612. 				var destList  = document.user.dest;
  613. 				var len = destList.options.length;
  614. 				for(var i = (len-1); i >= 0; i--)
  615. 				{
  616. 					if ((destList.options[i] != null) && (destList.options[i].selected == true))
  617. 					{
  618. 						destList.options[i] = null;
  619. 				    }
  620. 			    }
  621. 			}
  622.  
  623. function selectbodies()
  624. {
  625. document.user.selectedbod.value="";
  626. var leng=document.user.dest.length;
  627. for(var i=0; i<leng; i++){
  628.     document.user.dest[i].selected= true;
  629. 	var tess=document.user.dest[i].text;
  630. 	document.user.selectedbod.value=document.user.selectedbod.value+" * "+tess;
  631. 	}	
  632. }
  633. </script>
  634. <script src="scripts/AC_RunActiveContent.js" type="text/javascript"></script>
  635. </head>
  636. <body>
  637. <form name="user" onSubmit="return valid()" action="myEditUser2.jsp" method="post">
  638.   <table width="840" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#999999">
  639.   <tr>
  640.     <td align="center" valign="middle" class="style4 style10"><script type="text/javascript">
  641. 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
  642.     </script>
  643.       <noscript>
  644.       <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">
  645.         <param name="movie" value="images/bannerconsul.swf" />
  646.         <param name="quality" value="high" />
  647.         <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>
  648.       </object>
  649.       </noscript></td>
  650.   </tr>
  651.   <tr>
  652.     <td>
  653.     <table width="100%" border="0" cellpadding="2" cellspacing="2" class="style4">
  654.       <tr>
  655.         <td height="20" colspan="4" bgcolor="#C0C0C0" class="style1">Login Details</td>
  656.         </tr>
  657.       <tr>
  658.         <td>&nbsp;</td>
  659.         <td>&nbsp;</td>
  660.         <td colspan="2">&nbsp;</td>
  661.       </tr>
  662.       <tr>
  663.         <td width="2%">&nbsp;</td>
  664.         <td width="26%">Username</td>
  665.         <td width="29%">
  666. 		<input name="username" type="text" id="username" size="18" maxlength="15" value="<%=username%>" readonly="readonly"/><span class="style11">&nbsp;*</span></td>
  667.         <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>
  668.       </tr>
  669.       <tr>
  670.         <td>&nbsp;</td>
  671.         <td class="style4">Password</td>
  672.         <td>
  673. 		<input name="password" type="password" id="password" size="20" maxlength="8" onkeydown="passstrength();" value="<%=password%>"/><span class="style11">&nbsp;*</span></td>
  674.         <td>
  675.         <table border="0" cellspacing="0" cellpadding="0">
  676.           <tr>            
  677.             <td width="75" height="15" id="m1">&nbsp;</td>            
  678.             <td width="75" height="15" id="m2">&nbsp;</td>            
  679.             <td width="75" height="15" id="m3">&nbsp;</td>                       
  680.           </tr>
  681.         </table>        </td>
  682.       </tr>
  683.       <tr>
  684.         <td>&nbsp;</td>
  685.         <td class="style4">&nbsp;</td>
  686.         <td><span class="style12">Password must contain only 8 characters.</span></td>
  687.         <td>&nbsp;</td>
  688.       </tr>
  689.       <tr>
  690.         <td>&nbsp;</td>
  691.         <td class="style4">Confirm Password</td>
  692.         <td>
  693. 		<input name="password2" type="password" id="password2" size="20" maxlength="8" value="<%=password2%>" /><span class="style11">&nbsp;*</span></td>
  694.         <td>&nbsp;</td>
  695.       </tr>
  696.       <tr>
  697.         <td colspan="4">&nbsp;</td>
  698.         </tr>
  699.     </table>    </td>
  700.   </tr>
  701.  
  702.   <tr>
  703.     <td>
  704.     <table width="100%" border="0" cellpadding="2" cellspacing="2" class="style4">
  705.       <tr>
  706.         <td colspan="5" bgcolor="#C0C0C0" height="20"><span class="style1">Section 1: Company Details and General Information</span></td>
  707.         </tr>
  708.       <tr>
  709.         <td>&nbsp;</td>
  710.         <td>&nbsp;</td>
  711.         <td colspan="3">&nbsp;</td>
  712.       </tr>
  713.       <tr>
  714.         <td width="8">&nbsp;</td>
  715.         <td width="277" class="style4">Name of Firm</td>
  716.         <td colspan="3">
  717. 		<input name="namefirm" type="text" id="namefirm" size="80" maxlength="80" value="<%=namefirm%>" /><span class="style11">&nbsp;*</span></td>
  718.       </tr>
  719.       <tr>
  720.         <td>&nbsp;</td>
  721.         <td class="style4">Business Address</td>
  722.         <td colspan="3">
  723. 		<input name="bizadd" type="text" id="bizadd" size="80" maxlength="80" value="<%=bizadd%>" /><span class="style11">&nbsp;*</span></td>
  724.       </tr>
  725.       <tr>
  726.         <td>&nbsp;</td>
  727.         <td class="style4">P.O Box &amp; Mailing Address</td>
  728.         <td colspan="3">
  729. 		<input name="address" type="text" id="address" size="80" maxlength="80" value="<%=address%>" /><span class="style11">&nbsp;*</span></td>
  730.       </tr>
  731.       <tr>
  732.         <td>&nbsp;</td>
  733.         <td class="style4">Telephone</td>
  734.         <td colspan="3">
  735. 		<input name="telephone" type="text" id="telephone" size="20" maxlength="20" value="<%=telephone%>" /><span class="style11">&nbsp;*</span></td>
  736.       </tr>
  737.       <tr>
  738.         <td>&nbsp;</td>
  739.         <td class="style4">Fax</td>
  740.         <td colspan="3">
  741. 		<input name="fax" type="text" id="fax" size="20" maxlength="20" value="<%=fax%>" /></td>
  742.       </tr>
  743.       <tr>
  744.         <td>&nbsp;</td>
  745.         <td class="style4">Email Address</td>
  746.         <td colspan="3">
  747. 		<input name="email" type="text" id="email" size="50" maxlength="50" value="<%=email%>" /><span class="style11">&nbsp;*</span></td>
  748.       </tr>
  749.       <tr>
  750.         <td>&nbsp;</td>
  751.         <td class="style4">Country</td>
  752.         <td colspan="3">
  753.           <select name="country" id="country">
  754.             <%
  755. 			while(resul4.next()){%>
  756.     		<option value="<%=resul4.getString(2)%>"><%=resul4.getString(2)%></option>
  757.    			<% } %>
  758.           </select><span class="style11">&nbsp;*</span></td>
  759.       </tr>
  760.       <tr>
  761.         <td>&nbsp;</td>
  762.         <td>Website</td>
  763.         <td colspan="3">
  764. 		<input name="website" type="text" id="website" size="50" maxlength="50" value="<%=website%>" /></td>
  765.       </tr>
  766.       <tr>
  767.         <td>&nbsp;</td>
  768.         <td>Year Established</td>
  769.         <td colspan="3">
  770. 		<input name="yearest" type="text" id="yearest" size="12" maxlength="4" value="<%=yearest%>" /><span class="style11">&nbsp;*</span></td>
  771.         </tr>
  772.       <tr>
  773.         <td>&nbsp;</td>
  774.         <td>Years of experience in the current business</td>
  775.         <td colspan="3">
  776. 		<input name="yearex" type="text" id="yearex" size="20" maxlength="4" value="<%=yearex%>" /></td>
  777.         </tr>
  778.       <tr>
  779.         <td>&nbsp;</td>
  780.         <td>License No</td>
  781.         <td colspan="3">
  782. 		<input name="license" type="text" id="license" size="20" maxlength="20" value="<%=license%>" /><span class="style11">&nbsp;*</span></td>
  783.         </tr>
  784.       <tr>
  785.         <td>&nbsp;</td>
  786.         <td>Licensing Authority</td>
  787.         <td colspan="3">
  788. 		<input name="autho" type="text" id="autho" size="20" maxlength="20" value="<%=autho%>" /></td>
  789.         </tr>
  790.       <tr>
  791.         <td>&nbsp;</td>
  792.         <td>Business Reg. No</td>
  793.         <td colspan="3">
  794. 		<input name="bizreg" type="text" id="bizreg" size="20" maxlength="20" value="<%=bizreg%>" /><span class="style11">&nbsp;*</span></td>
  795.         </tr>
  796.       <tr>
  797.         <td>&nbsp;</td>
  798.         <td>No. of full-time Employees</td>
  799.         <td colspan="3">
  800. 		<input name="noemp" type="text" id="noemp" size="20" maxlength="4" value="<%=noemp%>" /></td>
  801.         </tr>
  802.       <tr>
  803.         <td>&nbsp;</td>
  804.         <td>VAT No</td>
  805.         <td colspan="3">
  806. 		<input name="vat" type="text" id="vat" size="20" maxlength="20" value="<%=vat%>" /></td>
  807.         </tr>
  808.       <tr>
  809.         <td>&nbsp;</td>
  810.         <td>Tax Account No</td>
  811.         <td colspan="3" valign="middle">
  812. 		<input name="tan" type="text" id="tan" size="20" maxlength="4" value="<%=tan%>" /></td>
  813.       </tr>
  814.       <tr>
  815.         <td>&nbsp;</td>
  816.         <td>Type of Business</td>
  817.         <td width="147" valign="middle"><input type="radio" name="biztype" id="biztype3" value="corporate" onclick="checko();"/>          Corporate/Limited</td>
  818.         <td width="182" valign="middle"><input type="radio" name="biztype" id="biztype2" value="partnership" onclick="checko();"/>
  819.           Partnership</td>
  820.         <td width="254" valign="middle"><input type="radio" name="biztype" id="biztype1" value="other" onclick="checko();"/>
  821.           Other 
  822. 		<input name="biztypeo" type="text" id="biztypeo" size="20" maxlength="20" disabled="disabled" value="<%=biztypeo%>"/></td>
  823.       </tr>
  824.       <tr>
  825.         <td>&nbsp;</td>
  826.         <td>Types of consultancy
  827. provided</td>
  828.         <td><input type="radio" name="typecons" id="typecons" value="Firm" onclick="checkoc();"/>          
  829.           Firm</td>
  830.         <td><input type="radio" name="typecons" id="typecons1" value="Individual Consultant" onclick="checkoc();"/>
  831. Individual Consultant</td>
  832.         <td><input type="radio" name="typecons" id="typecons2" value="other" onclick="checkoc();"/>
  833.           Other 
  834. 		<input name="typeconso" type="text" id="typeconso" size="20" maxlength="20" disabled="disabled" value="<%=typeconso%>"/></td>
  835.       </tr>
  836.       <tr>
  837.         <td>&nbsp;</td>
  838.         <td colspan="4">
  839.         <table  border="0" width="100%" cellspacing="0" cellpadding="0">
  840.           <tr>
  841.             <td height="5"></td>
  842.           </tr>
  843.           <tr>
  844.             <td>Names and Qualifications of main partners</td>
  845.           </tr>
  846.           <tr>
  847.           <td height="5"></td>
  848.           </tr>
  849.           <tr>
  850.             <td>&nbsp;&nbsp;<textarea name="qualification" id="qualification" cols="80" rows="5"><%=qualification%></textarea></td>
  851.           </tr>
  852.         </table>        </td>
  853.         </tr>
  854.       <tr>
  855.         <td>&nbsp;</td>
  856.         <td>Parent Company (If Any)</td>
  857.         <td colspan="3">
  858. 		<input name="parent" type="text" id="parent" size="70" maxlength="50" value="<%=parent%>" /></td>
  859.       </tr>
  860.       <tr>
  861.         <td>&nbsp;</td>
  862.         <td>Relation with Parent Co.</td>
  863.         <td colspan="3"><input type="radio" name="relation" id="relation" value="corporate" />          
  864.           Subsidiaries&nbsp;&nbsp;&nbsp;
  865.           <input type="radio" name="relation" id="relation" value="Associates" />
  866.           Associates&nbsp;&nbsp;&nbsp;
  867.           <input type="radio" name="relation" id="relation" value="Joint Venture" /> 
  868.           Joint Venture&nbsp;&nbsp;&nbsp;
  869.           <input type="radio" name="relation" id="relation" value="Overseas Representative" /> 
  870.           Overseas Representative</td>
  871.       </tr>
  872.       <tr>
  873.         <td height="10">&nbsp;</td>
  874.         <td height="10">&nbsp;</td>
  875.         <td colspan="3" height="10">&nbsp;</td>
  876.       </tr>
  877.     </table>    </td>
  878.   </tr>
  879.   <tr>
  880.     <td>
  881.     <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
  882.       <tr>
  883.         <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>
  884.         </tr>
  885.       <tr>
  886.         <td height="10" valign="middle" class="style4"></td>
  887.         <td height="10" valign="middle" class="style4"></td>
  888.         <td height="10" valign="middle" class="style4"></td>
  889.         <td height="10" valign="middle" class="style4"></td>
  890.       </tr>
  891.       <tr>
  892.         <td width="12" valign="middle" class="style4">&nbsp;</td>
  893.         <td width="273" valign="middle" class="style4"><input name="consultancy1" type="checkbox" id="consultancy1" value="Architectural Services" /> Architectural Services</td>
  894.         <td width="252" valign="middle" class="style4"><input name="consultancy2" type="checkbox" id="consultancy2" value="Design Services" /> 
  895.           Design Services</td>
  896.         <td width="277" valign="middle" class="style4"><input name="consultancy3" type="checkbox" id="consultancy3" value="Engineering Services" /> Engineering Services</td>
  897.       </tr>
  898.       <tr>
  899.         <td valign="middle" class="style4">&nbsp;</td>
  900.         <td valign="middle" class="style4"><input name="consultancy4" type="checkbox" id="consultancy4" value="Financial Intermediation Services" />
  901. Financial Intermediation Services</td>
  902.         <td valign="middle" class="style4"><input name="consultancy5" type="checkbox" id="consultancy5" value="Financial Services" />
  903. Financial Services</td>
  904.         <td valign="middle" class="style4"><input name="consultancy6" type="checkbox" id="consultancy6" value="Integrated Engineering Services" />
  905. Integrated Engineering Services</td>
  906.       </tr>
  907.       <tr>
  908.         <td valign="middle" class="style4">&nbsp;</td>
  909.         <td valign="middle" class="style4"><input name="consultancy7" type="checkbox" id="consultancy7" value="IT Services" /> 
  910.           IT Services</td>
  911.         <td valign="middle" class="style4"><input name="consultancy8" type="checkbox" id="consultancy8" value="Legal Services" />
  912. Legal Services</td>
  913.         <td valign="middle" class="style4"><input name="consultancy9" type="checkbox" id="consultancy9" value="Natural Resources Services" />
  914. Natural Resources Services</td>
  915.       </tr>
  916.       <tr>
  917.       <td valign="middle" class="style4">&nbsp;</td>
  918.         <td colspan="3" valign="middle" class="style4"><input name="consultancy10" type="checkbox" id="consultancy10" value="Research and Development Services on Natural Sciences" /> 
  919.         Research and Development Services on Natural Sciences</td>
  920.         </tr>
  921.       <tr>
  922.       <td valign="middle" class="style4">&nbsp;</td>
  923.         <td colspan="3" valign="middle" class="style4"><input name="consultancy11" type="checkbox" id="consultancy11" value="Research and Development Services on Social Sciences and Humanities" /> 
  924.         Research and Development Services on Social Sciences and Humanities</td>
  925.         </tr>
  926.       <tr>
  927.       <td valign="middle" class="style4">&nbsp;</td>
  928.         <td colspan="3" valign="middle" class="style4"><input name="consultancy12" type="checkbox" id="consultancy12" value="Urban Planning and Landscape Services" /> 
  929.         Urban Planning and Landscape Services</td>
  930.         </tr>
  931.       <tr>
  932.       <td valign="middle" class="style4">&nbsp;</td>
  933.         <td colspan="3" valign="middle" class="style4"><input name="consultancy13" type="checkbox" id="consultancy13" value="Other" onclick="checkcon();"/>
  934. Other (Specify)&nbsp;&nbsp;&nbsp;&nbsp;
  935. <input name="othercons" type="text" id="othercons" size="70" maxlength="50" disabled="disabled" value="<%=othercons%>"/></td>
  936.         </tr>
  937.       <tr>
  938.         <td height="10" valign="middle" class="style4"></td>
  939.         <td height="10" valign="middle" class="style4"></td>
  940.         <td height="10" valign="middle" class="style4"></td>
  941.         <td height="10" valign="middle" class="style4"></td>
  942.       </tr>
  943.     </table></td>
  944.   </tr>
  945.   <tr>
  946.     <td class="style1" height="20">
  947.     <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
  948.       <tr>
  949.         <td colspan="3" bgcolor="#C0C0C0" class="style1" height="20">Section 2: Financial Information</td>
  950.         </tr>
  951.       <tr>
  952.         <td class="style4">&nbsp;</td>
  953.         <td colspan="2" class="style4">&nbsp;</td>
  954.       </tr>
  955.       <tr>
  956.         <td width="12" class="style4">&nbsp;</td>
  957.         <td colspan="2" class="style4">Annual turnover for the last 3 years</td>
  958.         </tr>
  959.       <tr>
  960.         <td class="style4">&nbsp;</td>
  961.         <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>
  962.         <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>
  963.       </tr>
  964.       <tr>
  965.         <td class="style4">&nbsp;</td>
  966.         <td class="style4">Year&nbsp;&nbsp;<input name="turnoveryr2" type="text" id="turnoveryr2" size="12" maxlength="4" value="<%=turnoveryr2%>" /></td>
  967.         <td class="style4">Rs.&nbsp;<input name="turnoveramt2" type="text" id="turnoveramt2" size="20" maxlength="12" value="<%=turnoveramt2%>" />&nbsp;&nbsp;million</td>
  968.       </tr>
  969.       <tr>
  970.         <td class="style4">&nbsp;</td>
  971.         <td class="style4">Year&nbsp;&nbsp;<input name="turnoveryr3" type="text" id="turnoveryr3" size="12" maxlength="4" value="<%=turnoveryr3%>" /></td>
  972.         <td class="style4">Rs.&nbsp;<input name="turnoveramt3" type="text" id="turnoveramt3" size="20" maxlength="12" value="<%=turnoveramt3%>" />&nbsp;&nbsp;million</td>
  973.       </tr>
  974.  
  975.       <tr>
  976.         <td class="style4">&nbsp;</td>
  977.         <td class="style4">&nbsp;</td>
  978.         <td class="style4">&nbsp;</td>
  979.       </tr>
  980.     </table>    </td>
  981.   </tr>  
  982.   <tr>
  983.     <td>
  984.     <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
  985.       <tr>
  986.         <td height="20" colspan="2" bgcolor="#C0C0C0" class="style1">Section 3: Technical Capabilities and Information on Services Offered</td>
  987.         </tr>
  988.       <tr>
  989.         <td class="style4">&nbsp;</td>
  990.         <td class="style4">&nbsp;</td>
  991.       </tr>
  992.       <tr>
  993.         <td class="style4" width="12">&nbsp;</td>
  994.         <td class="style4">Quality Assurance Certification of Company (e.g. ISO 9000 or Equivalent)</td>
  995.       </tr>
  996.       <tr>
  997.         <td class="style4">&nbsp;</td>
  998.         <td class="style4">
  999. 		<input name="qualassu" type="text" id="qualassu" size="100" maxlength="100" value="<%=qualassu%>" /></td>
  1000.       </tr>
  1001.       <tr>
  1002.         <td class="style4" height="10"></td>
  1003.         <td class="style4" height="5"></td>
  1004.       </tr>
  1005.       <tr>
  1006.         <td class="style4">&nbsp;</td>
  1007.         <td class="style4">International Offices/Representation (Countries where the company has local/Offices/Representation)</td>
  1008.       </tr>
  1009.       <tr>
  1010.         <td class="style4">&nbsp;</td>
  1011.         <td class="style4">
  1012. 		<input name="interoffice" type="text" id="interoffice" size="100" maxlength="100" value="<%=interoffice%>" /></td>
  1013.       </tr>
  1014.       <tr>
  1015.         <td class="style4" height="10"></td>
  1016.         <td class="style4"></td>
  1017.       </tr>
  1018.       <tr>
  1019.         <td class="style4">&nbsp;</td>
  1020.         <td class="style4">Do the Services provided conform to National/International Quality Standards?</td>
  1021.       </tr>
  1022.       <tr>
  1023.         <td class="style4">&nbsp;</td>
  1024.         <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>
  1025.       </tr>
  1026.       <tr>
  1027.         <td class="style4">&nbsp;</td>
  1028.         <td class="style4">&nbsp;</td>
  1029.       </tr>
  1030.     </table>    </td>
  1031.   </tr>
  1032.   <tr>
  1033.     <td>
  1034.     <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
  1035.       <tr>
  1036.         <td colspan="5" bgcolor="#C0C0C0" class="style1" height="20">Section 4: Experience</td>
  1037.         </tr>
  1038.       <tr>
  1039.         <td colspan="5">&nbsp;</td>
  1040.         </tr>
  1041.       <tr>
  1042.         <td width="11">&nbsp;</td>
  1043.         <td colspan="4">Recent Contracts with Public Bodies</td>
  1044.         </tr>
  1045.       <tr>
  1046.         <td align="center" valign="middle" width="11">&nbsp;</td>
  1047.         <td width="237" align="center" valign="middle">Organisation</td>
  1048.         <td width="167" align="center" valign="middle">Contract Value (Rs)</td>
  1049.         <td width="106" align="center" valign="middle">Year</td>
  1050.         <td width="287" align="center" valign="middle">Consultancy Services Provided</td>
  1051.       </tr>
  1052.       <tr>
  1053.         <td>&nbsp;</td>
  1054.         <td align="center" valign="middle">
  1055. 		<input name="expeorg1" type="text" id="expeorg1" size="39" maxlength="12" value="<%=expeorg1%>" /></td>
  1056.         <td align="center" valign="middle">
  1057. 		<input name="convalue1" type="text" id="convalue1" size="25" maxlength="12" value="<%=convalue1%>" /></td>
  1058.         <td align="center" valign="middle">
  1059. 		<input name="contactyr1" type="text" id="contactyr1" size="15" maxlength="4" value="<%=contactyr1%>" /></td>
  1060.         <td align="center" valign="middle">
  1061. 		<input name="conserv1" type="text" id="conserv1" size="41" maxlength="12" value="<%=conserv1%>" /></td>
  1062.       </tr>
  1063.       <tr>
  1064.         <td>&nbsp;</td>
  1065.         <td align="center" valign="middle">
  1066. 		<input name="expeorg2" type="text" id="expeorg2" size="39" maxlength="12" value="<%=expeorg2%>" /></td>
  1067.         <td align="center" valign="middle">
  1068. 		<input name="convalue2" type="text" id="convalue2" size="25" maxlength="12" value="<%=convalue2%>" /></td>
  1069.         <td align="center" valign="middle">
  1070. 		<input name="contactyr2" type="text" id="contactyr2" size="15" maxlength="4" value="<%=contactyr2%>" /></td>
  1071.         <td align="center" valign="middle">
  1072. 		<input name="conserv2" type="text" id="conserv2" size="41" maxlength="12" value="<%=conserv2%>" /></td>
  1073.       </tr>
  1074.       <tr>
  1075.         <td>&nbsp;</td>
  1076.         <td align="center" valign="middle">
  1077. 		<input name="expeorg3" type="text" id="expeorg3" size="39" maxlength="12" value="<%=expeorg3%>" /></td>
  1078.         <td align="center" valign="middle">
  1079. 		<input name="convalue3" type="text" id="convalue3" size="25" maxlength="12" value="<%=convalue3%>" /></td>
  1080.         <td align="center" valign="middle">
  1081. 		<input name="contactyr3" type="text" id="contactyr3" size="15" maxlength="4" value="<%=contactyr3%>" /></td>
  1082.         <td align="center" valign="middle">
  1083. 		<input name="conserv3" type="text" id="conserv3" size="41" maxlength="12" value="<%=conserv3%>" /></td>
  1084.       </tr>
  1085.       <tr>
  1086.         <td>&nbsp;</td>
  1087.         <td align="center" valign="middle">
  1088. 		<input name="expeorg4" type="text" id="expeorg4" size="39" maxlength="12" value="<%=expeorg4%>" /></td>
  1089.         <td align="center" valign="middle">
  1090. 		<input name="convalue4" type="text" id="convalue4" size="25" maxlength="12" value="<%=convalue4%>" /></td>
  1091.         <td align="center" valign="middle">
  1092. 		<input name="contactyr4" type="text" id="contactyr4" size="15" maxlength="4" value="<%=contactyr4%>" /></td>
  1093.         <td align="center" valign="middle">
  1094. 		<input name="conserv4" type="text" id="conserv4" size="41" maxlength="12" value="<%=conserv4%>" /></td>
  1095.       </tr>
  1096.       <tr>
  1097.         <td>&nbsp;</td>
  1098.         <td align="center" valign="middle">
  1099. 		<input name="expeorg5" type="text" id="expeorg5" size="39" maxlength="12" value="<%=expeorg5%>" /></td>
  1100.         <td align="center" valign="middle">
  1101. 		<input name="convalue5" type="text" id="convalue5" size="25" maxlength="12" value="<%=convalue5%>" /></td>
  1102.         <td align="center" valign="middle">
  1103. 		<input name="contactyr5" type="text" id="contactyr5" size="15" maxlength="4" value="<%=contactyr5%>" /></td>
  1104.         <td align="center" valign="middle">
  1105. 		<input name="conserv5" type="text" id="conserv5" size="41" maxlength="12" value="<%=conserv5%>" /></td>
  1106.       </tr>
  1107.       <tr>
  1108.         <td>&nbsp;</td>
  1109.         <td align="center" valign="middle">
  1110. 		<input name="expeorg6" type="text" id="expeorg6" size="39" maxlength="12" value="<%=expeorg6%>" /></td>
  1111.         <td align="center" valign="middle">
  1112. 		<input name="convalue6" type="text" id="convalue6" size="25" maxlength="12" value="<%=convalue6%>" /></td>
  1113.         <td align="center" valign="middle">
  1114. 		<input name="contactyr6" type="text" id="contactyr6" size="15" maxlength="4" value="<%=contactyr6%>" /></td>
  1115.         <td align="center" valign="middle">
  1116. 		<input name="conserv6" type="text" id="conserv6" size="41" maxlength="12" value="<%=conserv6%>" /></td>
  1117.       </tr>
  1118.       <tr>
  1119.         <td>&nbsp;</td>
  1120.         <td>&nbsp;</td>
  1121.         <td>&nbsp;</td>
  1122.         <td>&nbsp;</td>
  1123.         <td align="center" valign="middle">&nbsp;</td>
  1124.       </tr>
  1125.     </table></td>
  1126.   </tr>
  1127.   <tr>
  1128.     <td>
  1129.     <table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
  1130.       <tr>
  1131.         <td height="20" colspan="3" bgcolor="#C0C0C0" class="style1">Section 5: Others</td>
  1132.         </tr>
  1133.       <tr>
  1134.         <td colspan="3">&nbsp;</td>
  1135.         </tr>
  1136.       <tr>
  1137.         <td width="12">&nbsp;</td>
  1138.         <td colspan="2">Please list any current legal disputes in which your company may be involved.</td>
  1139.         </tr>
  1140.       <tr>
  1141.         <td>&nbsp;</td>
  1142.         <td colspan="2"><textarea name="legaldisp" id="legaldisp" cols="90" rows="3"><%=legaldisp%></textarea></td>
  1143.         </tr>
  1144.       <tr>
  1145.         <td height="10"></td>
  1146.         <td colspan="2"></td>
  1147.       </tr>
  1148.       <tr>
  1149.         <td>&nbsp;</td>
  1150.         <td colspan="2">List any national or international Trade or Professional Organisation of which your Company is a member.</td>
  1151.         </tr>
  1152.       <tr>
  1153.         <td>&nbsp;</td>
  1154.         <td colspan="2"><textarea name="nitorg" id="nitorg" cols="90" rows="3"><%=nitorg%></textarea></td>
  1155.         </tr>
  1156.       <tr>
  1157.         <td height="10"></td>
  1158.         <td width="466"></td>
  1159.         <td width="342"></td>
  1160.       </tr>
  1161.       <tr>
  1162.         <td>&nbsp;</td>
  1163.         <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>
  1164.         </tr>
  1165.       <tr>
  1166.         <td>&nbsp;</td>
  1167.         <td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
  1168.           <tr>
  1169.             <td width="2%">&nbsp;</td>
  1170.             <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">
  1171.        				  <%
  1172. 							for(int i=0;i<j;i++)
  1173.      						{
  1174. 							String countr=usr[i];
  1175. 							%>
  1176. 							<OPTION selected> <%= countr %> </OPTION>
  1177. 							<%}%>
  1178.                             </select>                  </div></td>
  1179.             <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>
  1180.           <td width="52%"><select name="dest" size="6" multiple="multiple" id="dest" style="width: 340px; margin: 0px 0 5px 0">
  1181.                         </select>
  1182.               <input type="text" name="selectedbod" id="selectedbod" style="display:none"/></td>
  1183.           </tr>
  1184.  
  1185.         </table></td>
  1186.       </tr>
  1187.       <tr>
  1188.         <td height="10" colspan="3"></td>
  1189.         </tr>
  1190.       <tr>
  1191.         <td>&nbsp;</td>
  1192.         <td>Have you been disqualified by the Procurement Policy Office?</td>
  1193.         <td><input type="radio" name="disqual" value="yes">
  1194.         &nbsp;&nbsp;Yes&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="disqual" value="no">
  1195.         &nbsp;&nbsp;No</td>
  1196.       </tr>
  1197.       <tr>
  1198.         <td height="10" colspan="3"></td>
  1199.         </tr>
  1200.       <tr>
  1201.         <td>&nbsp;</td>
  1202.         <td>Have you been debarred by the Procurement Policy Office?</td>
  1203.         <td><input type="radio" name="debarred" value="yes">
  1204.         &nbsp;&nbsp;Yes&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="debarred" value="no">
  1205.         &nbsp;&nbsp;No</td>
  1206.       </tr>
  1207.       <tr>
  1208.         <td height="10"></td>
  1209.         <td height="10"></td>
  1210.         <td height="10"></td>
  1211.       </tr>
  1212.       <tr>
  1213.         <td>&nbsp;</td>
  1214.         <td>Have you been suspended by the Procurement Policy Office?</td>
  1215.         <td><input type="radio" name="suspend" value="yes">
  1216.         &nbsp;&nbsp;Yes&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="suspend" value="no">
  1217.         &nbsp;&nbsp;No</td>
  1218.       </tr>
  1219.       <tr>
  1220.         <td>&nbsp;</td>
  1221.         <td>&nbsp;</td>
  1222.         <td>&nbsp;</td>
  1223.       </tr>
  1224.       <tr>
  1225.         <td>&nbsp;</td>
  1226.         <td colspan="2">Certification</td>
  1227.         </tr>
  1228.       <tr>
  1229.         <td>&nbsp;</td>
  1230.         <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>
  1231.         </tr>
  1232.       <tr>
  1233.         <td>&nbsp;</td>
  1234.         <td colspan="2"><table width="100%" border="0" cellspacing="2" cellpadding="2" class="style4">
  1235.           <tr>
  1236.             <td width="16%">Name</td>
  1237.             <td width="45%">
  1238. 			<input name="certname" type="text" id="certname" size="40" maxlength="40" value="<%=certname%>" /><span class="style11">&nbsp;*</span></td>
  1239.             <td width="10%">&nbsp;</td>
  1240.             <td width="29%">&nbsp;</td>
  1241.           </tr>
  1242.           <tr>
  1243.             <td height="10"></td>
  1244.             <td height="10"></td>
  1245.             <td height="10"></td>
  1246.             <td height="10"></td>
  1247.           </tr>
  1248.           <tr>
  1249.             <td>Functional Title</td>
  1250.             <td>
  1251. 			<input name="certfun" type="text" id="certfun" size="40" maxlength="40" value="<%=certfun%>" /><span class="style11">&nbsp;*</span></td>
  1252.             <td>Date</td>
  1253.             <td>
  1254. 			<input name="certdate" type="text" id="certdate" size="20" maxlength="20" value="<%=certdate%>" readonly="readonly"/></td>
  1255.           </tr>
  1256.         </table></td>
  1257.         </tr>
  1258.       <tr>
  1259.         <td>&nbsp;</td>
  1260.         <td>&nbsp;</td>
  1261.         <td>&nbsp;</td>
  1262.       </tr>
  1263.       <tr>
  1264.         <td height="20" colspan="3" bgcolor="#000000"><span class="style7">Note:</span></td>
  1265.         </tr>
  1266.       <tr>
  1267.         <td>&nbsp;</td>
  1268.         <td colspan="2">All procurement dealings will be guided by the Public Procurement Act 2006 and its corresponding Regulations 2008.</td>
  1269.         </tr>
  1270.       <tr>
  1271.         <td>&nbsp;</td>
  1272.         <td>&nbsp;</td>
  1273.         <td>&nbsp;</td>
  1274.       </tr>
  1275.       <tr>
  1276.         <td>&nbsp;</td>
  1277.         <td>Documents to be submitted upon request:</td>
  1278.         <td>&nbsp;</td>
  1279.       </tr>
  1280.       <tr>
  1281.         <td height="10" align="left" valign="top"></td>
  1282.         <td colspan="2"></td>
  1283.       </tr>
  1284.       <tr>
  1285.         <td align="left" valign="top"><img src="images/304.gif" width="5" height="12" /></td>
  1286.         <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>
  1287.         </tr>
  1288.       <tr>
  1289.         <td><img src="images/304.gif" width="5" height="12" /></td>
  1290.         <td colspan="2">A copy of the company's Annual Financial Report for the past 3 years.</td>
  1291.         </tr>
  1292.       <tr>
  1293.         <td>&nbsp;</td>
  1294.         <td colspan="2">&nbsp;</td>
  1295.       </tr>
  1296.     </table></td>
  1297.   </tr>
  1298.   <tr>
  1299.     <td>
  1300.     <table width="100%" border="0" cellspacing="2" cellpadding="2">
  1301.       <tr>
  1302.         <td width="50%" align="right"><input type="reset" name="Reset" id="Reset" value="Reset Form" onclick="resetpass();"/></td>
  1303.         <td align="left"><input type="submit" name="submit" id="submit" value="Submit Form" onclick="selectbodies();"/></td>
  1304.         </tr>
  1305.     </table></td>
  1306.   </tr>
  1307. </table>
  1308. </form>
  1309. </body>
  1310. </html>
  1311.