X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fui%2Fui_lists.inc;h=910ad6534a853c40ed4cc0d10b5f4b3465385ca6;hb=9661cffeeab646dfbd51cf93eb042bb43e9bd061;hp=d62b84361993f676f4cd013efd7b8ce73bcb5c36;hpb=60e09e691b05da2634dc9e640cfa1f28ae36151e;p=fa-stable.git diff --git a/includes/ui/ui_lists.inc b/includes/ui/ui_lists.inc index d62b8436..910ad653 100644 --- a/includes/ui/ui_lists.inc +++ b/includes/ui/ui_lists.inc @@ -1653,7 +1653,10 @@ function stock_categories_list_row($label, $name, $selected_id=null, $spec_opt=f //----------------------------------------------------------------------------------------------- function fixed_asset_classes_list($name, $selected_id=null, $spec_opt=false, $submit_on_change=false) { - $sql = "SELECT c.fa_class_id, CONCAT(c.fa_class_id,' - ',c.description) `desc`, CONCAT(p.fa_class_id,' - ',p.description), c.inactive FROM ".TB_PREF."stock_fa_class c, ".TB_PREF."stock_fa_class p WHERE c.parent_id=p.fa_class_id"; + $sql = "SELECT c.fa_class_id, CONCAT(c.fa_class_id,' - ',c.description) `desc`, CONCAT(p.fa_class_id,' - ',p.description), c.inactive FROM " + .TB_PREF."stock_fa_class c, " + .TB_PREF."stock_fa_class p + WHERE c.parent_id=p.fa_class_id"; return combo_input($name, $selected_id, $sql, 'c.fa_class_id', 'desc', array('order'=>'c.fa_class_id',