Re: fetchrow_arrayref, fetchrow_arrayref columns won't parse.

"Garry T. Williams" <[email protected]> Thu, 21 Mar 2013 22:55:51 -0400

Newsgroups	gmane.comp.lang.perl.modules.dbi.general
Message-ID	<4740020.8Qef8jEUeG@vfr>

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