Set Recordset1_cmd = Server.CreateObject ("ADODB.Command") Recordset1 cmd.ActiveConnection = MM Connbook STRING Recordset1_cmd.CommandText = "SELECT * FROM lyb ORDER BY(11)一 DESC" Recordset1_cmd.Prepared =true <body> <% While((Repeat1_numRows<>0)AND(NOT Recordet1.EOF)) %> <p> </p> <table width=″500″border=″1″> <tr> <td widfth=″108″>留言;<%=(Recordset1.Fields.Item(″ID″).Value)%></td> <td widfth=″196″>留言;<%=(Recordset1.Fields.Item(″(12)″).Value)%></td> <td widfth=″174″>IP;<%=(Recordset1.Fields.Item(″(13)″).Value)%></td> </tr> <tr> <td rowspan=″2″>留言内容</tb> <td colspan=″2″><label for ″textdield″></label> <textarea name="textfield" cols="45" rows="5" id="textfield"><%=(Recordset1.Fields .Item("ly").Value)%><Itextarea></td〉 </tr> <tr> <td colspan="2"> 留言时间: <%=(Recordset1.Fields.Item("(14) ").Value)%></td> </tr> <tr> <td>回复内容</td> <td colspan="2"><label for="textfield2"></label> <textarea name="textfield2" cols="45" rows="3" id="textfield2"><%=(Recordset1.Fields .Item ("(15) ").Value)%></textarea></td> </tr> </table>备选答案
Set MM_editCmd = Serve.CreateObject ("ADODB.Command") MM_editCmd.ActiveConnection = MM_Connbook STRING MM_editCmd.CommandText =”INSERT INTO lyb (name,( 1 ) ,ipadd,lytime) VALUES (?,?,?,?)" MM_editCmd.Prepared =true MM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param1", 202, 1,255, Request.Form("name"))' adVarWChar MM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param2", 203, 1, 536870910,Request.From("ly"))' adlongvarwchar MM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param3", 202, 1,255, ( 2 ).Form("ipadd"))' adVarWChar MM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param4", 135, 1,-1, MM_IIF(Request.Form(〝lytime〞),Request.Form〝lytime〞),null))′adDBTimeStamp MM_editCmd.Execute MM_editCmd.AditCmd,ActiveConnection.Close <body> <%IP=Ruquest(〝REMOTE_ADDR〞)%> <P><strong>撰写语言 </strong></p> </hr> <form ACTION=″<%=MM_editAction%>″METHOD=″( 3 )″id=″form1″name=″form1″> <table width=″500″borde=″1″align=″center″ <tr> <td width=″94″align=″right″>您的姓名</td> <td width=″390″align=″left″><label for =″name″></label> <input type=″test″name″id=″name″/></td> </tr> <tr> <td align=″right″>您的留言</td> <td align=″left″><label for =″ly″></label> <( 4 )name=″ly″cols =″50″rows=″5″id=″ly″></textarea></td> </tr> <tr> <td align=″center″><a herf =″( 5 ).asp″>返回首页</a></td> <td align=″center″><input name=″( 6 )″type=″hidden″id=″ipadd″value =″<%=ip%>″/> <input name=″lytime″type=″( 7 )id=″lytime″value=″<%=( 8 )0%>″/> <input type=″( 9 )″name=″button″id=″button″value=″提交″/><label for=″radio″ <input type=″( 10)″name=″button2″id=″button″value=″重置″/> </label></td> <tr> </table>备选答案