Re: SQL Placeholder oddity

[JavaFan]

You cannot use a place holder in the selection list. What may work for you is (untested):

my $sth = $dbh->prepare("SELECT *, DATE_FORMAT(...) as something from 
+cases where caseid = ?");
$sth->execute($x);
while (my $hash = $sth->fetchrow_hashref()) {
    my @row = @$hash{$col, "status", "something"};
    ...
}