#180: change all DBI-containing scripts :D -------------------------+-------------------------------------------------- Reporter: brhel | Owner: liste Type: enhancement | Status: new Priority: major | Milestone: Component: Website | Version: Keywords: | -------------------------+-------------------------------------------------- at the moment, most BOGAS update / maintenance scripts are built like this: #============================== my @row = $sth->fetchrow_array; my $gene = $row[0]; my $structure = $row[2]; #============================== Problem: as soon as a new column is inserted in the table, the entire script fails, as the column order is important. That's why all my DBI-related scripts are built like this: #============================== my $row = $sth->fetchrow_hashref; my $structure = $row->{structure}; #============================== Independent of column order -> always correct even when the table undergoes major surgery :D So basically: change all scripts to be column order independent :) -- Ticket URL: <http://psbsvn01/trac/BOGAS/ticket/180> BOGAS <http://bioinformatics.psb.ugent.be/webtools/bogas> Bioinformatics Online Genome Annotation Service