![]() |
#2
cnfarer2010-05-04 19:08
|
下面这段代码,我想提取出来中间红色部分,单独放在一个过程里,然后调用他.但是却无法正常保存.

sub SaveAdd()
set rs=server.createobject("adodb.recordset")
sql="select * from MenuClass"
rs.open sql,conn,1,3
call rsup(newRootID)
rs.addnew
rs("ClassName")=newClassName
rs("Readme")=newReadme
rs("LinkUrl")=newLinkUrl
rs("LinkUrlasp")=newLinkUrlasp
rs("RootID")=cint(newRootID)
rs("Child")=0
rs("NextID")=0
rs("Depth")=0
if newShowONtop="yes" then
rs("ShowONtop")=True
else
rs("ShowONtop")=False
end if
rs.update
rs.close
set rs=nothing
response.redirect "Admin_Class_Menu.asp"
end sub
set rs=server.createobject("adodb.recordset")
sql="select * from MenuClass"
rs.open sql,conn,1,3
call rsup(newRootID)
rs.addnew
rs("ClassName")=newClassName
rs("Readme")=newReadme
rs("LinkUrl")=newLinkUrl
rs("LinkUrlasp")=newLinkUrlasp
rs("RootID")=cint(newRootID)
rs("Child")=0
rs("NextID")=0
rs("Depth")=0
if newShowONtop="yes" then
rs("ShowONtop")=True
else
rs("ShowONtop")=False
end if
rs.update
rs.close
set rs=nothing
response.redirect "Admin_Class_Menu.asp"
end sub
改成这个样子

sub SaveAdd()
set rs=server.createobject("adodb.recordset")
sql="select * from MenuClass"
rs.open sql,conn,1,3
call rsup(newRootID)
rs.addnew
call aa()
rs.close
set rs=nothing
response.redirect "Admin_Class_Menu.asp"
end sub
sub aa()
rs("ClassName")=newClassName
rs("Readme")=newReadme
rs("LinkUrl")=newLinkUrl
rs("LinkUrlasp")=newLinkUrlasp
rs("RootID")=cint(newRootID)
rs("Child")=0
rs("NextID")=0
rs("Depth")=0
if newShowONtop="yes" then
rs("ShowONtop")=True
else
rs("ShowONtop")=False
end if
rs.update
end sub
set rs=server.createobject("adodb.recordset")
sql="select * from MenuClass"
rs.open sql,conn,1,3
call rsup(newRootID)
rs.addnew
call aa()
rs.close
set rs=nothing
response.redirect "Admin_Class_Menu.asp"
end sub
sub aa()
rs("ClassName")=newClassName
rs("Readme")=newReadme
rs("LinkUrl")=newLinkUrl
rs("LinkUrlasp")=newLinkUrlasp
rs("RootID")=cint(newRootID)
rs("Child")=0
rs("NextID")=0
rs("Depth")=0
if newShowONtop="yes" then
rs("ShowONtop")=True
else
rs("ShowONtop")=False
end if
rs.update
end sub
[ 本帖最后由 zfc123 于 2010-5-4 18:34 编辑 ]