Do until rs.EOF OR rowCount = rs.PageSize
rowCount = rowCount + 1
Set rs3= Server.CreateObject("ADODB.Recordset")
Addera = "SELECT * FROM anv where id = " &rs("namnid") & " order by id desc "
rs3.Open Addera, Connect, 3, 3
Frågan#1
får felet
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query expression 'id = 2' order by id desc'.
/domandra/gastbok.asp, line 110
kod:
<%
Do until rs.EOF OR rowCount = rs.PageSize
rowCount = rowCount + 1
Set rs3= Server.CreateObject("ADODB.Recordset")
Addera = "SELECT * FROM anv where id = " &rs("namnid") & "' order by id desc " <-- felet
rs3.Open Addera, Connect, 3, 3
%>
namnid är "text" i databasen..