lookcom2.asp

本学期要实讯

<!--#include file="odbc_connection.asp"-->
<style type="text/css">
<!--
.style1 {
	font-size: 12px;
	color: #000000;
}
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
-->
</style>

<table width="522" height="275" border="0" align="left" cellpadding="0" cellspacing="0">
  <tr>
    <td width="522" align="center" valign="middle">
<%dim user
user=session("user")%>
<%dim rsa,sqla
sqlb="select name from userinfo where user='"&user&"'" 
set rsb=db.execute(sqlb)
username=rsb("name")
comid=Request("comid")
comname=Request("comname")
usermessage=Request("usermessage")
dim rs,sql
sql="insert into message(userid,comid,username,comname,usermessage,user_date) values('"&user&"','"&comid&"','"&username&"','"&comname&"','"&usermessage&"',#"&date()&"#) "
db.execute(sql) %>

<%if Request("usermessage")<>""  then %>
	<table width="267" height="38" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td width="267" height="38" align="center"><span class="style1">你的信息已经发送成功！谢谢你的参与！</span></td>
      </tr>
    </table>
	  <%end if%>
</td>
  </tr>
</table>