into aTable (Y,X) values (?,?)
my $tuples = $sth-execute_array( { ArrayTupleStatus = \my
@tuple_status }, \...@y_values, \...@x_values );
In your case below you want to bind a single parameter to an array.
You might have to use |bind_param_array| #___top for that
cheers
Denis BUCHER
= @row;
$sth_pgsql-execute(@array_data)...
}
} while ($sth_as400-{odbc_more_results});
This code is working !!!
I had only to change 3 times the '@' character : @array_data = @row; and
$sth_pgsql-execute(@array_data)...
Denis
Denis BUCHER a écrit :
Hello,
If I
Hello everyone,
Martin Evans a écrit :
I'm trying to simply do a SELECT from an ODBC source.
It works perfectly in PHP but not in perl !
Therefore there is no problem at source or at ODBC level, it seems to
reside at perl/DBI level...
What I do :
use DBI;
$dbh =
I'm using postgresql (Pg)
Denis
John Scoles a écrit :
Depends on the DBD driver.
Which one are you using?
cheers
Denis BUCHER wrote:
Hello,
Does someone knows if it's possible to specify an array when executing a
prepared statement ?
$sth-execute(%array_data)
instead
Hello,
I'm trying to simply do a SELECT from an ODBC source.
It works perfectly in PHP but not in perl !
Therefore there is no problem at source or at ODBC level, it seems to
reside at perl/DBI level...
What I do :
use DBI;
$dbh = DBI-connect('dbi:ODBC:' . $dsnname, $dbuser, $dbpwd) or...
Hello Martin,
Martin Evans a écrit :
Denis BUCHER wrote:
Hello everyone,
Some precisions to my previous email...
I'm trying to simply do a SELECT from an ODBC source.
It works perfectly in PHP but not in perl !
Therefore there is no problem at source or at ODBC level, it seems to
reside