Edit fra form
Hej, jeg har et problem med at hente en post fra databasen ind i en form så jeg kan rette den :(---Koden---
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)};"
DSN = DSN & "DBQ=" & Server.MapPath("freeware.mdb")
Conn.Open DSN
strSQL = "SELECT * FORM news WHERE newsID=" & newsID & ";"
Set rs = Conn.Execute(strSQL)
%>
<Form action="updatenews.asp" method="post">
<input type='hidden' name='id' value="<%=RS("newsID")%>">
<div align="center"><br>
<strong><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Skriv
en nyhed (husk at udfylde alle felter!)</font></strong>
<table>
<tr><td><font size="2" face="Arial, Helvetica, sans-serif"><strong>Overskrift:</strong></font></td></tr>
<tr><td><font size="2" face="Arial, Helvetica, sans-serif"><strong>
<input name="Overskrift" value="<%=RS("Oversfkift")%>" type="text" size="50">
</strong></font></td></tr>
<tr><td><font size="2" face="Arial, Helvetica, sans-serif"><strong>Teaser:</strong></font></td></tr>
<tr><td><font size="2" face="Arial, Helvetica, sans-serif"><strong>
<textarea name="Teaser" value="<%=RS("Teaster")%>" cols="50" rows="4" wrap="VIRTUAL"></textarea>
</strong></font></td></tr>
<tr><td><font size="2" face="Arial, Helvetica, sans-serif"><strong>Forfatter:</strong></font></td></tr>
<tr><td><font size="2" face="Arial, Helvetica, sans-serif"><strong>
<input name="Forfatter" value="<%=RS("Forfatter")%>" type="text" size="40">
</strong></font></td></tr>
<tr><td><font size="2" face="Arial, Helvetica, sans-serif"><strong>Tekst:</strong></font></td></tr>
<tr><td><font size="2" face="Arial, Helvetica, sans-serif"><strong>
<textarea name="Tekst" value="<%=RS("Tekst")%> cols="50" rows="10" wrap="VIRTUAL"></textarea>
</strong></font></td></tr>
<tr><td><font size="2" face="Arial, Helvetica, sans-serif"><strong>Kilde:</strong></font></td></tr>
<tr><td><input name="Kilde" type="text" size="40"></td></tr>
<tr><td><input type="submit" value="Opdater"></td></tr>
</table>
</div>
</Form>
---Fejlen---
Fejltype:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access-driver] Der er en syntaksfejl, fordi der mangler en operator. i forespørgselsudtrykket "* FORM news WHERE newsID=".
/iissamples/Rater/Admin/showeditnews.asp, line 45
Håber i kan hjælp...
