List:General Discussion« Previous MessageNext Message »
From:Steve Brown Date:May 24 2000 9:08pm
Subject:Re: type "text","mediumtext","longtext"
View as plain text  
Looks to me like you're passing 'SQLException: " + E.getMessage());<br>
' into the dbDo function and then asking MySQL to parse it. Which it won't
ever, no matter how big you make the field :) Check what $sql is, and check
where its getting called from, you're trying send it rubbish at present.

Incidentally, this line;
die "Do Failed : $db_handle->errstr\n";

needs to be changed to
die "Do Failed : " . $db_handle->errstr . "\n";

in order to do what you want as well...

Regards,
Steve.

----- Original Message -----
From: "amy" <amy@stripped>
To: <mysql@stripped>
Sent: Wednesday, May 24, 2000 9:58 PM
Subject: type "text","mediumtext","longtext"


>
> I have a data field of column type 'text' in which I
> expect to hold 65535 chars, the field has around 3000
> chars of data, when I try to save the field I got an
> error message :
>
> DBD::mysql::db do failed: You have an error in your SQL syntax
> near 'SQLException: " + E.getMessage());<br>       ' at line 1
> at /usr/local/bin/apache/cgi-bin/lib.pl line 48.
> Do Failed : DBI::db=HASH(0xcff20)->errstr
>
> and lib.pl line 48 is
>
> sub dbDo {
>         my ($sql) = @_;
>         my $command = $db_handle->do($sql)
>                 or die "Do Failed : $db_handle->errstr\n";
>         $command;
> }
>
> I deleted some data up to under 2550 chars, and everything
> is fine, so I tried changing the type to 'mediumtext' and
> 'longtext', but the same thing happens
>
> Any idea ?


Thread
type "text","mediumtext","longtext"amy25 May
  • Re: type "text","mediumtext","longtext"Steve Brown25 May