I currently have a selection list which is generated with the following code:

<%Dbsql::Relation::HTML::generate_full_down('intpositions',
'hrtransfer')%>

intpositions builds the selection list with positions as the name of each field and ID as the value

I also have a column in intpositions called active. I would like to require each records value for active that equals no to NOT display is the selection list. I would also like to sort this list alphabetically.

Can anyone help me with this? I emailed Stone a few days ago , but haven't heard back.

Thank you