Question

ASP增加多条记录的问题，急解呀！

User_Id=Request("User_Id") '这是接收到的字符串（如“22，23，24”）
Works_Title=Trim(Request("Works_Title")) ‘这是增加标题的
Works_Content = "" ’这是内容
For i = 1 To Request("Works_Content").Count
Works_Content = Works_Content & Request("Works_Content")(i)
Next
strName = Split(User_Id,", ")
Dim j
For j = 0 To UBound(strName)
Sql="Select * From Works_Info where (Works_Id is null)"
Rs.Open Sql,Conn,1,3
Rs.Addnew
Rs("User_Id")=strName(j)
Rs("Works_Title")=Works_Title
Rs("Works_Content")=Works_Content
Rs.Update
Rs.Close
Set Rs = nothing
Next

为什么只增加到一条22的！
加一句 response.write strName(j) 又能显示22 23 24

Answer 1

Sql="Select * From Works_Info where (Works_Id is null)"
改成
sql="Select * From Works_Info"
试试。

Answer 2

UBound()这个方法不对吧