00001
00002 public class PolicySelect extends SelectBox
00003 {
00004 public PolicySelect(String prefix, Form form)
00005 {
00006 super(false, 5, prefix, form);
00007 }
00008
00009 public void display(boolean hidden)
00010 {
00011 super.display(hidden, "\n"+
00012 " SELECT p.insurance_policy_id, c.name || ': ' || p.description\n"+
00013 " FROM insurance_policies AS p\n"+
00014 " NATURAL JOIN insurance_companies AS c\n"+
00015 " ORDER BY c.name, c.insurance_company_id, p.description\n"+
00016 " ");
00017 }
00018 };
