RS.Addnew & Unik ID
------koden (en del af den):
------
strOriginator = Request.form(\"Originator_form\")
strPosted = Now
strMessage = Request.form(\"Text_form\")
Dim Line203
strSQL9 = \"SELECT Subject_table.SubjectID_field, Subject_table.SubjectName_field, Subject_table.ForumID_field From Subject_table WHERE Subject_table.SubjectID_field LIKE 0\"
set objRS9 = Server.CreateObject(\"ADODB.Recordset\")
objRS9.Open strSQL9, strConnect, adOpenKeyset, adLockOptimistic
objRS9.Addnew
objRS9(\"Subject_table.SubjectName_field\") = Request.form(\"Headline_form\")
objRS9(\"Subject_table.ForumID_field\") = strForum
objRS9.Update
strSubjectID = objRS9(\"SubjectID_field\")
strSQL5 = \"INSERT INTO Message_table SET Message_table.MessageAuthor_field = \'\" & strOriginator & \"\', Message_table.MessageDate_field = \'\" & strPosted & \"\', Message_table.MessageText_field = \'\" & strMessage & \"\', Message_table.SubjectID_field = \'\" & strSubjectID & \"\'\"
objComm9.ActiveConnection = strConnect
objComm9.CommandText = strSQL5
objComm9.CommandType = 1
objComm9.Execute
objRS9.Close
Set objRS9 = Nothing
Set objComm9 = Nothing
Response.redirect \"Forum.asp\"
------
fejlen:
------
Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/LL/Forum.asp, line 210
linje 210 er objRS9(\"Subject_table.SubjectName_field\") = Request.form(\"Headline_form\")
Hvad har jeg gjort galt?
Som i kan se er det fordi jeg skal vide det unike ID (som er auto nummer) på det Subject jeg sætter ind, så jeg kan sætte link attr. til det i Message.
