<% ##required # 'table' => 'table_name', # 'name_col' => 'name_column', # ##strongly recommended (you want your forms to be "sticky" on errors, right?) # 'value' => 'current_value', # ##opt # 'empty_label' => '', #better specify it though, the default might change # 'hashref' => {}, # 'records' => \@records, #instead of hashref # 'pre_options' => [ 'value' => 'option' ], #before normal options my( %opt ) = @_; #warn "***** select-table: \n". Dumper(%opt); my $key = dbdef->table($opt{'table'})->primary_key; #? $opt{'primary_key'} || my $name_col = $opt{'name_col'}; my @records = (); if ( $opt{'records'} ) { @records = @{ $opt{'records'} }; } else { @records = qsearch( $opt{'table'}, ( $opt{'hashref'} || {} ) ); } my @pre_options = $opt{'pre_options'} ? @{ $opt{'pre_options'} } : (); %> <% while ( @pre_options ) { %> <%= shift(@pre_options) %> <% } %> <%= $opt{'empty_label'} || 'all' %> <% foreach my $record ( sort { $a->$name_col() cmp $b->$name_col() } @records ) { %> $key() ? ' SELECTED' : '' %>><%= $record->$name_col() %> <% } %>