Haster

Her er et stykke fra min kode, det er lidt [MEGET] rodet meeen.....

<% Response.Buffer = True %>
<% mode = request(\"mode\") %>
<% if mode = \"\" then
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"db.mdb\")

Set rs = conn.Execute(\"SELECT * FROM codes WHERE id = \" & Request(\"id\"))

titel = rs(\"titel\")
beskrivelse = rs(\"beskrivelse\")
id = rs(\"id\")
clicks = rs(\"clicks\")
download_sti = rs(\"download_sti\")
eksempel_sti = rs(\"eksempel_sti\")
made_by = rs(\"madeby\")
conn.Close
Set conn = nothing
Set SQLstmt = nothing


Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"db.mdb\")

Set rs = conn.Execute(\"SELECT * FROM users WHERE id = \" & Request(\"made_by\"))

lavet_af = rs(\"brugernavn\")

conn.Close
Set conn = nothing
Set SQLstmt = nothing
%>

Jeg får fejlen

Microsoft OLE DB Provider for ODBC Drivers fejl \'80040e14\'

[Microsoft][ODBC Microsoft Access-driver] Der er en syntaksfejl, fordi der mangler en operator. i forespørgselsudtrykket \"id =\".

/beta/source_info.asp, linje 26

Og linie 26 er:

Set rs = conn.Execute(\"SELECT * FROM users WHERE id = \" & Request(\"made_by\"))

What the ? Er der galt.........