Select Box BO Array or SQL Query?

[tarantir]

Hello all,

With respect to Select Box options is there a rule of thumb on when to use an Array defined in the BO class or whether to use a SQL Query List?

I realize the overhead for a SQL Query for a Select Box list of 5 values is probably greater than if the options are just defined in the BO Class. Are there significant performance reasons to use one method over another or is it simply a tradeoff between maintainability the number of options and how often the options may change.

Thank you,

[ngegw]

Mostly changeability. If you define a static list in the BO class, there
is no option for change without programmer intervention.
If you want to let the user/admin change it from the UI, you need to use
the database. You can find several examples of this in the various
applications (timesheet status, tracker, etc.)

Nathan