On Mon, May 03, 2004 at 05:10:56PM +0200, [EMAIL PROTECTED] wrote:
>
> $prtsql= $dbh->prepare(
> "insert into mth_nft
> (select
> and accountid = 1406240)");
>
> $pigmonkey = $prtsql->execute or die "Error";
> print "WOW, $pigmonkey\n";
> $prtsql->bind_columns(undef, \$acct, \$transc, \$price, \$startt);
> while ( $prtsql->fetch() ) {
> print "$acct $transc $price $startt\n";
> }
>
> when i try to run it there are sometimes no data returned from the select
> statement so i get this error
> Statement has no result columns to bind (perhaps you need to successfully
> call execute first) at ./partfind line 134.
Sometimes? I doubt it ever has.
That's not a select statement, it's an insert statement that happens
to contain a select statement. Insert statements don't return rows.
Tim.
