UC知道ASP修改数据内容问题
来源：百度知道 编辑：UC知道 时间：2024/09/24 14:22:27
//修改处理
<%
if request("action")="edit" then
conn.execute "update wrtxcnshop_pinpai set pinpai_name=request"&pinpai_name&",pinpai_logo=request"&pinpai_logo&",pinpai_content=request"&pinpai_content&",pinpai_xu=request"&pinpai_xu&" where pinpai_id="&pinpai_id&""
conn.close
set conn=nothing
call editok(editt,"ad_pinpai.asp")
%>
//提交处理
<form method="post" action="ad_pinpai.asp?action=edit&pinpai_id=<%=rs("pinpai_id")%>">
<tr><td bgcolor="#FFFFFF" valign="top" class="s1"><%=rs("pinpai_id")%></td>
<td bgcolor="#FFFFFF" valign="top" class="s1">
<input name="pinpai_name" type="text" size="10" value="<%=trim(rs("pinpai_name"))%>"></td>
<%
if request("action")="edit" then
conn.execute "update wrtxcnshop_pinpai set pinpai_name=request"&pinpai_name&",pinpai_logo=request"&pinpai_logo&",pinpai_content=request"&pinpai_content&",pinpai_xu=request"&pinpai_xu&" where pinpai_id="&pinpai_id&""
conn.close
set conn=nothing
call editok(editt,"ad_pinpai.asp")
%>
//提交处理
<form method="post" action="ad_pinpai.asp?action=edit&pinpai_id=<%=rs("pinpai_id")%>">
<tr><td bgcolor="#FFFFFF" valign="top" class="s1"><%=rs("pinpai_id")%></td>
<td bgcolor="#FFFFFF" valign="top" class="s1">
<input name="pinpai_name" type="text" size="10" value="<%=trim(rs("pinpai_name"))%>"></td>
出了什么错误？
conn.execute "update wrtxcnshop_pinpai set pinpai_name=request"&pinpai_name&",pinpai_logo=request"&pinpai_logo&",pinpai_content=request"&pinpai_content&",pinpai_xu=request"&pinpai_xu&" where pinpai_id="&pinpai_id&""
看一下这句更新语句
如果数据库的字段是文本型的话,要加单引号
是不是没获取pinpai_id