linking to a second page using 'ID'

<i><b>Originally posted by : andrew (harrison@tiscalinet.it)</b></i><br /><br />i want to link from one page to another in which i'll find more info from the same record so i've used an ID to keep to thet record.It doesn't work.<br /><br />Why?<br /><br /><br />LINK<br />__________________________<br /><a href="moto.asp?ID=<%=id%>">click here</a><br /><br /><br />Second page<br />_______________________________________<br /><br /><%id2=request.querystring ("id")<br />sql="select * from models where id='id2'"<br /><br />Set OBJdbConnection = Server.CreateObject("ADODB.Connection")<br />OBJdbConnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq=e:userszonalingzonalingue.com
acingbike2sitomoto.mdb"<br />Set RS=OBJdbConnection.Execute(sql)%> <br /><%fotolarge=rs("fotolarge")%><br /><br /><%response.write("&fotolarge&")%><br /><%RS.Close<br />OBJdbConnection.Close%><br />

<i><b>Originally posted by : Wen Chan (chenwen@yysoft.com)</b></i><br />Change: <br /><br />sql="select * from models where id='id2'"<br /><br />To:<br /><br />sql="select * from models where id='"&id2&"'"<br />