UPDATE 语句的语法异常
日期：2014-05-17 浏览次数：21041 次
UPDATE 语句的语法错误。
updateshow.asp:
<%@LANGUAGE= "VBScript " codepage= "936 "%>
<%if session( "admin ") <> " " then%>
<!--#include file= "conn.asp "-->
<%
set rs=server.createobject( "adodb.recordset ")
id=Request.QueryString( "id ")
sql= "select * from main where id= "&id
rs.open sql,conn,2,3
%>
<html>
<head>
<title> 留言本-填写留言 </title>
<link href= "style.css " rel= "stylesheet " type= "text/css ">
</head>
<body>
<form action= "update.asp " method= "post " name= "add ">
<input type= "hidden " name= "id " value= " <%=Request.QueryString( "id ")%> "/>
<table width= "450 " border= "0 " align= "center " cellpadding= "2 " cellspacing= "0 ">
<tr>
<td height= "40 " colspan= "2 " align= "center "> <span class= "text3 "> <strong> 留言本-填写留言 </strong> </span> </td>
</tr>
<tr>
<td width= "124 "> <P style= "MARGIN-TOP: 2px; MARGIN-LEFT: 80px "> 姓名 </p> </td>
<td width= "318 "> <input name= "user " type= "text " id= "user " value= " <%=rs( "user ")%> "> </td>
</tr>
<tr>
<td> <P style= "MARGIN-TOP: 2px; MARGIN-LEFT: 80px "> QQ号 </p> </td>
<td> <input name= "qq " type= "text " value= " <%=rs( "qq ")%> "> </td>
</tr>
<tr>
<td> <P style= "MARGIN-TOP: 2px; MARGIN-LEFT: 80px "> 邮件 </p> </td>
<td> <input name= "email " type= "text " value= " <%=rs( "email ")%> "> </td>
</tr>
<tr>
<td valign= "top "> <P style= "MARGIN-TOP: 5px; MARGIN-LEFT: 80px "> 内容 </p> </td>
<td> <textarea name= "content " cols= "30 " rows= "5 "> <%=rs( "content ")%>
</textarea> </td>
updateshow.asp:
<%@LANGUAGE= "VBScript " codepage= "936 "%>
<%if session( "admin ") <> " " then%>
<!--#include file= "conn.asp "-->
<%
set rs=server.createobject( "adodb.recordset ")
id=Request.QueryString( "id ")
sql= "select * from main where id= "&id
rs.open sql,conn,2,3
%>
<html>
<head>
<title> 留言本-填写留言 </title>
<link href= "style.css " rel= "stylesheet " type= "text/css ">
</head>
<body>
<form action= "update.asp " method= "post " name= "add ">
<input type= "hidden " name= "id " value= " <%=Request.QueryString( "id ")%> "/>
<table width= "450 " border= "0 " align= "center " cellpadding= "2 " cellspacing= "0 ">
<tr>
<td height= "40 " colspan= "2 " align= "center "> <span class= "text3 "> <strong> 留言本-填写留言 </strong> </span> </td>
</tr>
<tr>
<td width= "124 "> <P style= "MARGIN-TOP: 2px; MARGIN-LEFT: 80px "> 姓名 </p> </td>
<td width= "318 "> <input name= "user " type= "text " id= "user " value= " <%=rs( "user ")%> "> </td>
</tr>
<tr>
<td> <P style= "MARGIN-TOP: 2px; MARGIN-LEFT: 80px "> QQ号 </p> </td>
<td> <input name= "qq " type= "text " value= " <%=rs( "qq ")%> "> </td>
</tr>
<tr>
<td> <P style= "MARGIN-TOP: 2px; MARGIN-LEFT: 80px "> 邮件 </p> </td>
<td> <input name= "email " type= "text " value= " <%=rs( "email ")%> "> </td>
</tr>
<tr>
<td valign= "top "> <P style= "MARGIN-TOP: 5px; MARGIN-LEFT: 80px "> 内容 </p> </td>
<td> <textarea name= "content " cols= "30 " rows= "5 "> <%=rs( "content ")%>
</textarea> </td>
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
