Click link and return one record

<i><b>Originally posted by : Pettal (pettal@pettal.com)</b></i><br />Hi,<br /><br />I've been playing around with some code but I can't for the life of me get it to work. <br /><br />Basically I wish to be able to return rows from a recordset which has an expiry period. In turn the expiry period is href linked to an edit page to update the expiry for that one record.<br /><br />However I can't get it to return the expiry I selected, it just returns the EOF or the BOF.<br /><br />Any ideas ??

<i><b>Originally posted by : Wouter (info@forumsmadeasy.com)</b></i><br />Hi,<br /><br />What you do is you sent the ID of the record you want to change with your link to the asp page that allows you to edit that record.<br /><br />example:<br />.... <br />intID = rs("MyRecordID")<br /><br />then you use that info in your like like:<br /><br /><A href="EditRecordPage.asp?ID=<%= intID%>"><br /><br />in the page 'EditRecordPage.asp' you read the querystring for ID.<br />You then select that record with an SQL statement.. display the info in form field.<br />press the submit button, open a new page to save the info back to the database and you are done...<br /><br />see, easy...<br /><br />Wouter<br />from www.forumsmadeasy.com<br /><br /><br />------------<br />Pettal at 7/12/2000 8:45:55 AM<br /><br />Hi,<br /><br />I've been playing around with some code but I can't for the life of me get it to work. <br /><br />Basically I wish to be able to return rows from a recordset which has an expiry period. In turn the expiry period is href linked to an edit page to update the expiry for that one record.<br /><br />However I can't get it to return the expiry I selected, it just returns the EOF or the BOF.<br /><br />Any ideas ??