Nemt hent fra database problem
Jeg har en access database.. med en root "database" .. med 4 koloner.. ID(auto), Dato(auto), links og news..min lille asp kode ser således ud:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("news.mdb")
'SQLstmt = "INSERT INTO database (ID,news,links,dato)"
'SQLstmt = SQLstmt & " VALUES (" & request.form("ID") & "','" & request.form("news") & "','"& request.form("links") & "','"& request.form("dato") & "')"
SQLstmt = "Select Top 3 * from database order by ID DESC"
'
'response.write SQLstmt
Conn.Execute (SQLstmt)
Set rs = conn.Execute(SQLstmt)
%>
<%
DO WHILE NOT rs.EOF
ID = rs("ID")
news = rs("news")
links = rs("links")
date = rs("date")
%>
<tr>
<td width="210" valign="top"><div align="right"><font color="#666666"><%=dato%></font></div></td>
<td width="10" valign="top"><img src="gfx/spacer.gif" width="10" height="10"></td>
<td width="290" valign="top"><font color="#666666"><%=news%></font></td>
<td width="10" valign="top"><img src="gfx/spacer.gif" width="10" height="10"></td>
<td width="210" valign="top"><a href="#"><%=links%></a></td>
</tr>
<tr><td>image</td></tr>
<%
rs.MoveNext
LOOP
RS.Close
Response.Write ""
conn.Close
Set conn = nothing
Set SQLstmt = nothing
%>
MEN det virker ikke.. får denne fejL:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
/new/Default.asp, line 47
?!
