I'm using the following code but I need to loop over each record and select the one that is in the db. however, it needs to display all the records too. how would I do that?
<CFQUERY NAME="getlinks" DATASOURCE="dns">
order by sortorder asc
<form method="post" action="page.cfm" name="sortorder">
Sort Order:<br />
<select name="getorder" id="getorder">