% Dim conn Dim connstr Dim db '¸ü¸ÄÊý¾Ý¿âÃû×Ö db="access-db\db1.mdb" set conn = Server.CreateObject("ADODB.Connection") connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"") conn.Open connstr sub connclose() conn.close set conn=nothing End sub Sub rsclose() rs.close set rs=nothing End Sub %> <% Producttitle=request("producttitle") If Request( "Submit" )<>"" Then date1=date set rs=server.createobject("adodb.recordset") SQL="select * from message where ID is Null" rs.open SQL,conn,1,3 rs.Addnew rs("title")=Trim( Request("title") ) rs("msg")=Trim( Request("content") ) rs("email")=Trim( Request("email") ) rs("tel")=Trim( Request("tel") ) rs("address")=Trim( Request("address") ) rs("msg_date")=date1 rs("answer")="NoRe" rs.Update rs.close Response.Redirect ("message.asp") end if %>
![]() |
|
Product | Payment/warranty Policy | Order | About US | Contact US | News | Shipping |
|
|
|||||||||||||||||||||||||||||||