forum ting igen.....
------Koden (en del af den):
------
<%
Function CreateSubject(parForumID, parSubject)
Dim strSQL
Dim objRS
Dim strDate
strDate = Now
strSQL = \"SELECT * From Subject_table WHERE SubjectID_field = 0\"
set objRS = Server.CreateObject(\"ADODB.Recordset\")
objRS.Open strSQL, strConnect, adOpenKeyset, adLockOptimistic
objRS.Addnew
objRS(\"SubjectName_field\") = parSubject
objRS(\"ForumID_field\") = parForumID
objRS.Update
CreateSubject = objRS(\"SubjectID_field\")
objRS.Close
Set objRS = Nothing
End Function
Sub CreateMessage(parSubjectID, parAuthor, parText)
Dim strSQL
Dim objComm
Dim strDate
strDate = Now
strSQL = \"INSERT INTO Message_table SET MessageAuthor_field = \'\" & parAuthor & \"\', MessageDate_field = \'\" & strDate & \"\', MessageText_field = \'\" & parText & \"\', SubjectID_field = \" & parSubjectID
set objComm = Server.CreateObject(\"ADODB.Command\")
objComm.ActiveConnection = strConnect
objComm.CommandText = strSQL
objComm.CommandType = 1
objComm.Execute
Set objComm = Nothing
End Sub
.
.
.
.
Response.write \"<br>\"
Response.write \"<table border=\'1\' bordercolor=\'black\' bordercolorlight=\'black\' bordercolordark=\'black\' align=\'center\' cellpadding=\'0\' cellspacing=\'0\' width=\'600\'>\"
Response.write \"<tr>\"
Response.write \"<td bgcolor=\'#1F487F\' ALIGN=center>\"
Response.write \"<FORM ACTION=\'Forum.asp?Forum=\" & strForum & \"\' METHOD=\'POST\' NAME=\'ReplySubject_form\'>\"
Response.write \"<p class=\'silveronblue\'>Name:</p>\"
Response.write \"<INPUT TYPE=TEXT NAME=\'Originator_input\'></INPUT><BR>\"
Response.write \"<p class=\'silveronblue\'>Subject:</p>\"
Response.write \"<INPUT TYPE=TEXT NAME=\'Subject_input\'></INPUT><BR>\"
Response.write \"<p class=\'silveronblue\'>Message:</p>\"
Response.write \"<TEXTAREA NAME=\'Text_input\' cols=\'70\' rows=\'8\'></TEXTAREA><BR><BR>\"
Response.write \"<INPUT TYPE=SUBMIT VALUE=\'Reply\'><br>\"
Response.write \"</FORM>\"
Response.write \"</td>\"
Response.write \"</tr>\"
Response.write \"</table>\"
If Request.ServerVariables(\"REQUEST_METHOD\") = \"POST\" Then
Dim strTest
strTest = CreateSubject(strForum, Request.form(\"Subject_input\"))
Call CreateMessage(strTest, Request.form(\"Originator_input\"), Request.form(\"Text_input\"))
Response.redirect \"Forum.asp\"
End If
------
Fejlen:
------
Der er flere fejl, og de 100 point går til dem som hjælper med at løse dem :)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Invalid string or buffer length
/LL/Forum.asp, line 23
line 23 er objRS(\"SubjectName_field\") = parSubject
når den udkommenteres:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[TCX][MyODBC]You have an error in your SQL syntax near \'\' at line 1
/LL/Forum.asp, line 47
line 47 er: strSQL = \"INSERT INTO Message_table SET MessageAuthor_field = \'\" & parAuthor & \"\', MessageDate_field = \'\" & strDate & \"\', MessageText_field = \'\" & parText & \"\', SubjectID_field = \" & parSubjectID
og af hvad jeg kan forstå på den fejl betyder det at min function har returneret værdien \'\' og ikke det unike ID for Subject.
Alt pejer altså i retning af at der er en fejl ved Addnew og update (eller der imellem)
------
Databasen:
------
Subject_table
SubjectID_field (auto)
SubjectName_field
ForumID_field (f.key)
------
Misc.:
------
Åhh og proceduren CreateMessage(parSubjectID, parAuthor, parText) virker fint sa jeg også bruger den til at lave replys til et subject som er lavet.
