SQL Update
<form name=\"form1\" method=\"post\" action=\"nyheder.asp?mode=opdaternyhed\"><p>
<input type=\"text\" class=\"inputSubmit\" size=\"40\" name=\"overskrift\" value=\"<%=rs(\"Overskrift\")%>\">
</p>
<p>
<textarea name=\"tekst\" class=\"inputSubmit\" cols=\"45\" rows=\"10\"><%=rs(\"tekst\")%></textarea>
</p>
<select name=\"harlink\">
<option value=\"Ja\">Ja</option>
<option value=\"Nej\">nej</option>
</select>
<p><input type=\"hidden\" name=\"linkid\" value=\"<%=request(\"linkid\")%>\">
<input type=\"submit\" class=\"inputBut\" name=\"Submit\" value=\"Opdater\">
</p>
</form>
<a href=\"java script:history.go(-1);\">Tilbage</a>
<%
case \"opdaternyhed\"
SQL = \"Update news set Overskrift= \'\" & request.form(\"overskrift\") & \"\', \"
SQL = SQL & \"tekst= \'\"& request.form(\"tekst\") & \"\', \"
SQL = SQL & \"harlink= \'\"& request.form(\"harlink\") & \"\' \"
SQL = SQL & \" WHERE ID = \"& request.form(\"linkid\")
response.write (SQL)
Connect.Execute(SQL)
når jeg kører dette får jeg fejlen
Microsoft VBScript runtime error \'800a01a8\'
Object required: \'\'
/admin/nyheder.asp, line 154
Linie 154 er Connect.Execute(SQL)
