adding records

<i><b>Originally posted by : Arno (flash@start4all.com)</b></i><br />Hi,<br />I have a asp vote booth with categories and I want that the visitors are able<br />to add new items in the categories where they can vote on.<br />So I made a html form in the asp result page and that one writes the data<br />into the database, that works well except for the categorieID (the ID for the current categorie)<br />How can I do this? In the asp result page I already closed the current recordset before the html form starts<br />I'm new to this so maybe I'm talking nonsence now :-)<br /><br />Thanks in advance,<br />Arno<br />

<i><b>Originally posted by : steve</b></i><br />if the catID field is in the same table then you can just use an autonumber or identity column that autoincrements. Then the statement you can capture this variable if you need to write out to the asp page.<br /><br />http://www.aspfree.com/asp/startpage.asp?id=20 has example code how to do this.<br /><br />steve<br /><br /><br />------------<br />Arno at 3/29/2000 5:25:29 AM<br /><br />Hi,<br />I have a asp vote booth with categories and I want that the visitors are able<br />to add new items in the categories where they can vote on.<br />So I made a html form in the asp result page and that one writes the data<br />into the database, that works well except for the categorieID (the ID for the current categorie)<br />How can I do this? In the asp result page I already closed the current recordset before the html form starts<br />I'm new to this so maybe I'm talking nonsence now :-)<br /><br />Thanks in advance,<br />Arno<br />