On 3-21-13 21:44:46 dome stuff wrote:
> my $sth = $dbh->prepare('SELECT (formid, fid, forder, ftype, fsize,
> fmaxlength, fdesc, flink) FROM fdesc WHERE (formid = ?) ORDER BY forder') ;
my $sth = $dbh->prepare(<<SQL);
SELECT formid, fid, forder, ftype, fsize,
fmaxlength, fdesc, flink
FROM fdesc
WHERE formid = ?
ORDER BY forder
SQL
In other words, lose the parentheses in the SELECT clause.
--
Garry T. Williams
