I need it to limit the category that user can submit a link.
It needs to be something like this
<select name="CatLinks.CategoryID" size="1" id="CatLinks.CategoryID">
<option selected value="">select category</option>
<option value="1"> cat name 1 </option>
<option value="2"> cat name 2 </option>
<option value="3"> cat name 3 </option>
<option value="4"> cat name 4 </option>
</select>
so actually all it need is to insert in a loop the line
<option value="<%catid%>"> <%catname%></option>
It needs to be something like this
<select name="CatLinks.CategoryID" size="1" id="CatLinks.CategoryID">
<option selected value="">select category</option>
<option value="1"> cat name 1 </option>
<option value="2"> cat name 2 </option>
<option value="3"> cat name 3 </option>
<option value="4"> cat name 4 </option>
</select>
so actually all it need is to insert in a loop the line
<option value="<%catid%>"> <%catname%></option>