Re^4: dbi placeholders

Sorry, my bad. bind_columns doesn't work on inserts :(

# Delete the bind_columns line for sth2
while ($sth1->fetch) {
    $sth2->execute (@rec{@fields});
    }
[download]

Enjoy, Have FUN! H.Merijn

Comment on Re^4: dbi placeholders Select or Download Code

Replies are listed 'Best First'.
Re^5: dbi placeholders by fionbarr (Friar) on Aug 06, 2014 at 14:38 UTC
deleted the bind but another error: fetch failed: Function sequence error (SQL-HY010)	[reply]
Re^6: dbi placeholders by poj (Abbot) on Aug 06, 2014 at 17:48 UTC
Try executing `$sth1` `my $sth1 = $dbh_0->prepare ("select * from log"); my @fields = @{$sth1->{NAME_lc}}; $sth1->execute(); $sth1->bind_columns (\@rec{@{$sth1->{NAME_lc}}});` [download] poj	[reply] [d/l] [select]
Re^6: dbi placeholders by marto (Cardinal) on Aug 06, 2014 at 14:43 UTC
Did you research this error code?	[reply]
Re^7: dbi placeholders by fionbarr (Friar) on Aug 06, 2014 at 15:00 UTC
yes, but didn't make any sense out of it. There is a 'sequence' of function calls; something is called out of order....	[reply]
Re^6: dbi placeholders by Tux (Canon) on Aug 06, 2014 at 14:47 UTC
Is this related? I don't have MS-SQL. Enjoy, Have FUN! H.Merijn	[reply]