日期:2014-05-17  浏览次数:20939 次

帮忙更改
if   request( "action ")= "edit "   then   sort_id=request.QueryString( "sort_id ")   set   rs=server.createobject( "adodb.recordset ")   sql= "select   *   from   venshop_sort   where   sort_id= "&sort_id& " "   rs.open   sql,conn,1,3   for   i=1   to   10   rs( "ziduan "&i)=request( "ziduan "&i)   next   rs.update   rs.close   set   rs=nothing   Response.Redirect   "ad_ziduan.asp?sort_id= "&sort_id& " "   response.end   elseif   request( "action ")= "fuzhi "   then   Response.Redirect   "ad_ven.asp "   response.end   end   if   sort_id=request( "sort_id ")   set   rs=server.createobject( "adodb.recordset ")   sql= "select   *   from   venshop_sort   where   sort_id= "&sort_id& " "   rs.open   sql,conn,1,1   if   rs.eof   then   response.write   errmes1   Response.End   end   if   sort_id=rs( "sort_id ")   sort_name=rs( "sort_name ")

格式都是错的,请帮忙更改

------解决方案--------------------
if request( "action ")= "edit " then sort_id=request.QueryString( "sort_id ")
set rs=server.createobject( "adodb.recordset ")
sql= "select * from venshop_sort where sort_id= "&sort_id& " "
rs.open sql,conn,1,3
for i=1 to 10
rs( "ziduan "&i)=request( "ziduan "&i)
next
rs.update
rs.close
set rs=nothing
Response.Redirect "ad_ziduan.asp?sort_id= "&sort_id& " "
response.end
elseif request( "action ")= "fuzhi " then
Response.Redirect "ad_ven.asp "
response.end
end if
sort_id=request( "sort_id ")
set rs=server.createobject( "adodb.recordset ")
sql= "select * from venshop_sort where sort_id= "&sort_id& " "
rs.open sql,conn,1,1
if rs.eof then response.write errmes1
Response.End
end if
sort_id=rs( "sort_id ")
sort_name=rs( "sort_name ")

------解决方案--------------------
if request( "action ")= "edit " then
sort_id=request.QueryString( "sort_id ")
set rs=server.createobject( "adodb.recordset ")
sql= "select * from venshop_sort where sort_id= "&sort_id& " "
rs.open sql,conn,1,3
for i=1 to 10
rs( "ziduan "&i)=request( "ziduan "&i)
next
rs.update
rs.close
set rs=nothing
Response.Redirect "ad_ziduan.asp?sort_id= "&sort_id& " "
response.end
elseif request( "action ")= "fuzhi " Then
Response.Redirect "ad_ven.asp "
response.end
end if
sort_id=request( "sort_id ")
set rs=server.createobject( "adodb.recordset ")
sql= "select * from venshop_sort where sort_id= "&sort_id& " "
rs.open sql,conn,1,1
if rs.eof then
response.write errmes1
Response.End
end if
sort_id=rs( "sort_id ") sort_name=rs( "sort_name ")