# get Discontinued
my $sql = qq!SELECT DISTINCT("Discontinued") AS disc 
             FROM "Products" ORDER BY 1 DESC !;
my $dr = $dbh->selectall_arrayref($sql);

# Make up a pulldown menu for Discontinued 
my $discs = qq!<option value="">Select option</option>!;
for my $row (@$dr) {
  $discs .= qq!<option value="$row->[0]">$row->[0]</option>\n!;
}

##</code><code>##


Discontinued :<select name="discontinued"> $discs </select><br/>

##</code><code>##

DBD::Pg::db do failed: ERROR:  invalid input syntax for type boolean: "" at /usr/share/perlproj/cgi-bin/editprod.pl line 44