Bug #5009: odbc fields are not updated correctly
| From: | gordonl at tts-sf dot com | Date: | Tue, 13 Jun 2000 18:48:22 +0000 |
| Subject: | Bug #5009: odbc fields are not updated correctly | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-21234@lists.php.net to get a copy of this message | ||
From: gordonl@tts-sf.com
Operating system: Linux mandrake 7.0
PHP version: 3.0.16
PHP Bug Type: ODBC related
Bug description: odbc fields are not updated correctly
we ran the odbc_exec function with the string
"INSERT into web_call_results
(wcr_script,wcr_notes,wcr_phone,wcr_result,wcr_input_oper,wcr_date_input,wcr_date_modify,wcr_grade,wcr_activity)
VALUES (1010,'testA',2171866,563,10085,'2000-06-13 11:28:29','2000-06-13
11:28:29',0.0,5)" and it runs okay.
If we run it (the only difference being the placement of the wcr_notes field) as
"INSERT into web_call_results
(wcr_script,wcr_phone,wcr_result,wcr_input_oper,wcr_date_input,wcr_date_modify,wcr_grade,wcr_activity,wcr_notes)
VALUES (1010,2171866,563,10085,'2000-06-13 11:28:29','2000-06-13
11:28:29',0.0,5,'testA')"
It does not run correctly. Specifically, an internal buffer is used for certain fields and it is not
cleared some of the time. In the database (informix) the wcr_notes field has the value
"testA06-13 11:28:29" instead of "testA".
We are using the informix odbc driver. The statements run okay from the informix sql editor.
wcr_notes is a blob type field.