SQL = "SELECT * from " & subject & " WHERE ID = " & id
Trådstart#1
hur ska denna kod se ut:
<%
subject = request.querystring("sub")
id =request.querystring("id")
set mincon =Server.CreateObject("ADODB.Connection")
set rs = server.createobject("ADODB.Recordset")
mincon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\kalasmannen\db\db_guider.mdb")
SQL = "SELECT * from & subject & WHERE ID = " & id
rs.Open SQL, mincon
%>
för att fungera?
får nu detta fel meddelande:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
/kalasmannen/guiden.asp, line 9
?