linking to a record 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 that 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 /><br />

<i><b>Originally posted by : Mage (mage@baltnet.ru)</b></i><br />That's probably because you're suppose to write your SQL string like this:<br /><br />sql="select * from models where id=" & id2<br /><br />And you don't need "& and &"in your last line:<br /><br /><%response.write(fotolarge)%><br /><br />Regards,<br />Mage<br /><br />------------<br />andrew at 4/2/2001 3:16:02 AM<br /><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 that 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 />