syntax error in id query HELP!!!!!!

i have 1 page which gives the results of a data base search. the title of each result is hypertext so clicking on it will open a second page which will contain the other fields of the same database record.I have used the ?id? field for this purpose but it dosent work: I get this error message:<br>Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <br><br>[Microsoft][ODBC Microsoft Access Driver] Errore di sintassi (operatore mancante) nell'espressione della query 'id ='. <br>-------------------------------------------------------------------<br>i couldn't upload the script her it wouldn't let me so the page can be found at this address:<br>http://web.zonalingue.com/asp.htm

may you should change<br>sql="select * from ads where id = "&id2<br>to<br>sql="select * from ads where id = '"&id2&"'"<br><br>sometimes it cause error but sometimes not