Help for this page

Select Code to Download


  1. or download this
    #open connection to the database
    my $db = DBI->connect("dbi:Oracle:host=$host;sid=$sid;port=$port", $ui
    +d, $pwd) or die "Error while connecting to database!!!\nIncorrect Con
    +nection information\n";
    ...
     
     print "$pdisplay_order, $parent_name, $child_name\n";
     }
    
  2. or download this
    However, when I use the following, I can fetch the values from the tab
    +le / view
     #$SQL_query = qq {SELECT display_order, name, id_parent_category from
    + CATEGORY ORDER BY DISPLAY_ORDER };
    ...
        #$SQL_query = qq {SELECT * from VW_CATEGORIES};