Vad är det för fel på den här koden?? Jag har en databas som heter forum, en tabell: forum, och 4 kolumner i tabellen, Namn, email, rubrik, meddelande..
Snälla hjälp nån...
<HTML>
<!-- #include virtual="/forum/adovbs.inc" -->
<HEAD>
<TITLE>Nytt meddelande</TITLE>
</HEAD>
\<%
Set RecSet = Server.CreateObject("ADODB.Recordset")
Addera = "SELECT * FROM Forum ORDER BY namn"
RecSet.Open Addera, Connect, adOpenStatic, adLockOptimistic %>
<Center>
<table border="0" width="796" height="35" cellspacing="0" cellpadding="2">
<tr>
<td width="25%" height="8"></td>
<td width="25%" height="8"></td>
<td width="25%" height="8"></td>
<td width="25%" height="8"></td>
</tr>
<% Do Until RecSet.EOF %>
<tr>
<td width="25%" height="8"><% =RecSet("Namn") %></td>
<td width="25%" height="8"><% =RecSet("Email") %></td>
<td width="25%" height="8"><% =RecSet("Rubrik") %></td>
<td width="25%" height="8"><% =RecSet("Meddelande") %></td>
</tr>
<% RecSet.MoveNext
Loop
RecSet.Close
%>
</table>
<Center>
<P>
<font face="arial" size="5" color="RED"><b>*</b></font><font face="arial" size="5" color="#004080"><b>Nytt meddelande:</b></font><p>
<FORM ACTION="add.asp" METHOD="POST">
<table width="550">
<tr>
<td colspan="2"><hr size="1" color="navy"><p></td>
</tr>
<tr>
<td><font face="arial" size="2" color="#FF0000">*</font><font face="arial" size="2" color="#004080"><b>Namn:</b></font></td>
<td><INPUT TYPE="TEXT" NAME="Namn" SIZE="50" MAXLENGTH="100"></td>
</tr>
<tr>
<td><font face="arial" size="2" color="#004080"><b>Email:</b></font></td>
<td><INPUT TYPE="TEXT" NAME="Email" SIZE="50" MAXLENGTH = "100"></td>
</tr>
<tr>
<td><font face="arial" size="2" color="#FF0000">*</font> <font face="arial" size="2" color="#004080"><b>Rubrik:</b></font></td>
<td><INPUT TYPE = TEXT SIZE=50 MAXLENGTH="100" NAME="Rubrik"></INPUT></td>
</tr>
<tr>
<td valign="top"><font face="arial" size="2" color="#FF0000">*</font> <font face="arial" size="2" color="#004080"><b>Meddelande:</b></font></td>
<td><TEXTAREA ROWS = 8 COLS = 50 NAME="Meddelande"></TEXTAREA></td>
</tr>
</table>
<Br>
<font face="arial" size="2" color="#004080">Alla med en </font><font face="arial" size="2" color="#FF0000">*</font><font face="arial" size="2" color="#004080"> måste vara med.</font><Br>
<CENTER><INPUT TYPE="SUBMIT" VALUE="Skicka meddelande"></FORM>
</body>
</html>
Mvh .. Damion
------------------
»John