Retrieve data from database with radio button

Please support our JSP advertiser: 50% off 6 Months Dedicated Server Hosting from 1&1!
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 8: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: 3,890
Reputation: adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future 
Solved Threads: 696
Moderator
adatapost adatapost is offline Offline
Senior Poster

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.
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 4: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: 3,890
Reputation: adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future adatapost has a brilliant future 
Solved Threads: 696
Moderator
adatapost adatapost is offline Offline
Senior Poster

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