主题:新手问asp代码格式???
'获取会员编号
dim rs,sql
set rs=server.CreateObject("adodb.recordset")
sql="select * from Muser where username='"&session("username")&"'"
rs.open sql,db,1,3
memberid=rs("id")
rs.close
set rs = nothing
'更新用户信息
Set rs = Server.CreateObject("adodb.recordset")
sql = "update Muser set connector='"&Replace(connector,"'",",")&"',tel='"&Replace(tel,"'",",")&"',zipcode='"&Replace(zipcode,"'","")&"',addr='"&Replace(addr,"'",",")&"',email='"&Replace(email,"'",",")&"' where id='"&memberid&"'"
rs.open sql,db,3,3
rs.close
set rs = nothing
这里面的两个rs同名,请问对执行效率有没有影响,谢谢各位!!
dim rs,sql
set rs=server.CreateObject("adodb.recordset")
sql="select * from Muser where username='"&session("username")&"'"
rs.open sql,db,1,3
memberid=rs("id")
rs.close
set rs = nothing
'更新用户信息
Set rs = Server.CreateObject("adodb.recordset")
sql = "update Muser set connector='"&Replace(connector,"'",",")&"',tel='"&Replace(tel,"'",",")&"',zipcode='"&Replace(zipcode,"'","")&"',addr='"&Replace(addr,"'",",")&"',email='"&Replace(email,"'",",")&"' where id='"&memberid&"'"
rs.open sql,db,3,3
rs.close
set rs = nothing
这里面的两个rs同名,请问对执行效率有没有影响,谢谢各位!!