编写网站的N个错误(vbscript脚本)

1；误：rs.open(sql,conn,1,3)     'JS形式

     正：rs.open sql,conn,1,3

2；误：sql="select * from [user] where id=" & id

     正：sql="select * from [user] where id='" & id & "'"

3；误：sql="select * from user where id='" & id & "'"

     正：sql="select * from [user] where id='" & id & "'"

4；误：for i=1 to ***

          ***

          next i      (VB6.0里写惯了)

     正：for i=1 to ***

           ***

          next

5；误：conn=server.createobject("adodb.connection")

     正：set conn=server.createobject("adodb.connection")