note 89319 added to book.pdo

From: Date: Tue, 03 Mar 2009 15:06:00 +0000
Subject: note 89319 added to book.pdo
Groups: php.notes 
Request: Send a blank email to php-notes+get-151395@lists.php.net to get a copy of this message
Hello, i'm trying to insert a text from a file into a informix database. When im execute $stmt = $db->prepare( 'INSERT INTO meldung ( problem_kurz, hist_aktion ) VALUES ( :problem_kurz, :hist_aktion )' ); $stmt->bindParam( 'problem_kurz', $sProblemtitel,PDO::PARAM_STR ); $fp = fopen("temp.tmp", 'rb'); $stmt->bindParam( 'hist_aktion', $fp, PDO::PARAM_LOB ); $stmt->execute(); i get the following error: SQLSTATE[HY000]: General error: -608 [Informix][Informix ODBC Driver][Informix]Illegal attempt to convert Text/Byte blob type. (SQLParamData[-608] at ..\pecl\pdo_informix\informix_statement.c:788) What is the reason for this error? ---- Server IP: 212.124.37.9 Probable Submitter: 195.50.175.67 ---- Manual Page -- http://www.php.net/manual/en/book.pdo.php Edit -- https://master.php.net/note/edit/89319 Del: integrated -- https://master.php.net/note/delete/89319/integrated Del: useless -- https://master.php.net/note/delete/89319/useless Del: bad code -- https://master.php.net/note/delete/89319/bad+code Del: spam -- https://master.php.net/note/delete/89319/spam Del: non-english -- https://master.php.net/note/delete/89319/non-english Del: in docs -- https://master.php.net/note/delete/89319/in+docs Del: other reasons-- https://master.php.net/note/delete/89319 Reject -- https://master.php.net/note/reject/89319 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#151395) next »