
<!--#include file="conn.asp"-->

<%
tclass=request("txtclass")
tname=request("txtnamecn")

ttname=request("txtnameen")
%>

<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Test Results </title>
<link rel="stylesheet" href="style/t.css" type="text/css">
</head>
<body bgcolor="#D6D3CE">
<p align="center" class=header	><b><font size="3">CIC Students' </font></b>Information</p>

  <center>
 
  <%
  course=split("BusinessStudies,Chemistry,Economics,English,Maths,FurtherMaths,Physics,student",",")
  for i=0 to ubound(course)  
set rs=server.createobject("ADODB.Recordset") 
   sql="select * from "&course(i)&" where  name_CN='"&tname&"'  and  class='"&tclass&"'"

     rs.open sql,conntmp,3,3
  if rs.eof and rs.bof then 
  response.Write "ERROR"
  response.End()
  else
  
  rs("name_en")=ttname
  rs.update
  
  'response.Write ttname
  'response.End()
  
  end if
  
  rs.close
  set rs=nothing
 next 
  
  
  
  response.Redirect "student.asp?txtclass="&tclass&""
  %>

  </center>

 

</body>

</html>