DB2 - wrong number of parameters
| From: | Pablo Garay | Date: | Mon, 17 Jul 2006 18:01:49 +0000 |
| Subject: | DB2 - wrong number of parameters | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42219@lists.php.net to get a copy of this message | ||
Hi!
I´m working with PHP 5 and using the DB2 database.
I´m trying to update a jpg file, that´s save on the database.
here´s the code:
$fp = @fopen("$caminho/$nome_arquivo", 'r');
$content = fread($fp, filesize("$caminho/$nome_arquivo"));
$content = bin2hex($content);
fclose($fp);
$conn = $this->DB2->getConn(); //get the connection id
$q = "update dbsm.FUNCIONARIOS set FOTO=? where ID_FUNCIONARIO=?";
$res = odbc_prepare ($conn, $q);
$array = array();
$array[0] = $content; //file
$array[1] = $idFuncionario;
$exc = odbc_execute($res, $array);
but when I run it, the folow warning appears:
Warning: odbc_execute() [function.odbc-execute]: SQL error: [IBM][CLI Driver] CLI0100E Wrong number
of parameters. SQLSTATE=07001, SQL state 07001 in SQLExecute in C:\Arquivos de programas\Apache
Group\Apache2\htdocs\principal\Portal\Repositorio\Funcionarios.class.php on line 170
what´s the problem???
thanks
Pablo Garay
Ijuí - UNIJUI
RS - Brasil