this is the global i need to use and is not working

i got this error: Error: Variable 'build_select' is not a code reference

i sent this to gossamer support but thet did not sent me reply about

sub {
my $table = shift;
my $results = $DB->table($table)->select()->fetchall_hashref;
return { loop_select => $results };
}


i got this error when including in my form this

<%build_select('table_name')%>
<select name="select_name">
<%loop loop_select%>
<option value="<%column_id%>"><%column_description%></option>
<%endloop%>
</select>

i dont know what i am doing worng if so, you send me how to make a select field and works but i need to use this global because my fields in this tables are in relation with others that content the information and make the dropdown from those tables contents in this.

for examples i have the table that user will use for adding records modify etc... these contents

and every field are dropdown from another table content field. i cant get the global work! do you know can you give some sample with the phonec_id for example?

thanx

prate_id

phonec_id - taken from another table

contryf_id - taken from another table

contryt_id - taken from another table

cityt_id - taken from another table

value_id - taken from another table

phone_minutes
KevinW ANDRE
webmaster@cyberbrickell.com