#19061 [Opn]: Insert Statment Fail bcoz of Lenght too long
| From: | c_aluthge at hotmai dot com | Date: | Fri, 23 Aug 2002 12:21:22 +0000 |
| Subject: | #19061 [Opn]: Insert Statment Fail bcoz of Lenght too long | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-17643@lists.php.net to get a copy of this message | ||
ID: 19061
User updated by: c_aluthge@hotmai.com
Reported By: c_aluthge@hotmai.com
Status: Open
Bug Type: Informix related
Operating System: HP UX 11.00
PHP Version: 4.1.2
New Comment:
Any luck on this ???
Previous Comments:
------------------------------------------------------------------------
[2002-08-23 02:45:27] georg@php.net
category changed
------------------------------------------------------------------------
[2002-08-23 01:59:43] c_aluthge@hotmai.com
It's a Informix DATABASE 7.31
------------------------------------------------------------------------
[2002-08-23 01:42:11] derick@php.net
Which database is this?
------------------------------------------------------------------------
[2002-08-22 22:15:39] c_aluthge@hotmai.com
I'm trying to insert a record to one of my talble.
The column "comments" is a Char (1250) , but i cant insert any values
thru my PHP Program with a lenth more than 256 Char.
this is the SQL Statment
$insert_record = "insert into msm_account".
"(account_num,comments,activity_type,due_activity_type,record_stat,due_date,entry_date,update_date,update_user)".
"values
'$account_num','$comments','$activity_type','$due_activity_type',"."'$record_stat','$due_date','today','today','$user_name')";
Output of the statment ....
Lenght : 259
Insert : insert into <TABLE NAME>
account_num,comments,activity_type,due_activity_type,record_stat,due_date,entry_date,update_date,update_user)values
('510000075','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','NONE','NONE','N','23/08/2002','today','today','xxxx')
Warning: Prepare fails (E [SQLSTATE=IX 000 SQLCODE=-280]) in
/www/htdocs/MSm/docs/xxx_rec.php on line 57
Failed to Insert record
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=19061&edit=1