帮忙更改
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 ")