<TITLE>select center</TITLE>
<link rel="stylesheet" type="text/css" href="style.css">
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<head>
<SCRIPT LANGUAGE="vbScript">
<!--
function keypress()
tname=mainform.tname.value
'alert(mainform.tname.value)
for each tn in mainform.tablename
allvalue=tn.value
if left(allvalue,len(tname))=tname then
'alert(allvalue)
mainform.tablename.value=allvalue
exit for
end if
next
end function
//-->
</SCRIPT>
<style>
body{text-align:left;font:12px #000080 ;}
#main{float:left;width:750px;border:#dddddd 1px solid;margin:5px 10px;padding:10px 5px;}
#maintable{width:700; padding:1px; border:1px solid #dddddd;font:12px;color:#000080; }
#maintable td{ border: 0px solid #008000; padding-left: 4px; padding-right: 4px;
padding-top: 1px; padding-bottom: 1px;background:#dddddd }
#search{float:left;width:600px;border-bottom:#0000ff 1px solid;margin:0px;padding:2px 10px;}
#result{float:left;width:600px;border:#dddddd 0px solid;margin:2px 1px;padding:2px 10px;}
#test{float:left;width:750px;border:#dddddd 1px solid;margin:5px 10px;padding:10px 100px;}
#main p{}
</style>
<BODY>
<div id="test">
<A HREF="classtrn.asp" target="blank">classtrn</A>
</div>
<div id="main">
<table id=maintable>select top 10 * from adjust <TR><TD>ad_emno</TD>
<TD>ad_seqno</TD>
<TD>ad_date</TD>
<TD>ad_date1</TD>
<TD>ad_csno1</TD>
<TD>ad_dpno1</TD>
<TD>ad_date2</TD>
<TD>ad_csno2</TD>
<TD>ad_dpno2</TD>
<TD>ad_type</TD>
<TD>ad_type2</TD>
<TD>updid</TD>
<TD>upddate</TD>
</tr></table><FORM METHOD=POST id=mainform ACTION=mtable.asp>
select the table:<select name=tableName><option value=a_prwork >a_prwork</option>
<option value=account >account</option>
<option value=adjust selected>adjust</option>
<option value=applica1 >applica1</option>
<option value=aprwork >aprwork</option>
<option value=backb >backb</option>
<option value=clothes >clothes</option>
<option value=meal >meal</option>
<option value=mealdept >mealdept</option>
<option value=nosh >nosh</option>
<option value=ostockb >ostockb</option>
<option value=ostockh >ostockh</option>
<option value=palletc >palletc</option>
<option value=worktoholb >worktoholb</option>
<option value=worktoholh >worktoholh</option>
<option value=xcard >xcard</option>
<option value=zv01 >zv01</option>
<option value=zv02 >zv02</option>
</select>
tableame:<input type=text name=tname onkeyup='vbscript:keypress()'> topnum:<input type=text name=topnum size=5><INPUT TYPE=submit name=action value=submit> <INPUT TYPE=reset value=reset></FORM>the time used 0.203125
</div>
</body>
</html>
