Re: max string length / textarea form
Re: max string length / textarea form
- Subject: Re: max string length / textarea form
- From: Chuck Hill <email@hidden>
- Date: Fri, 26 Aug 2005 08:32:33 -0700
On Aug 25, 2005, at 6:40 PM, Dev WO wrote:
Hi,
As I was trying to get rid of a couple bugs in my application, I
have found a very strange behavior:
In a textarea (WOForm, using form-data as the type as there's also
a WOUpload for an image), it seems that the content gets truncated
when send to the database?!
What do you mean by truncated? Not sent at all? Long strings lose
their end? An exception? The maximum amount of text in an text area
varies with each browser. Usually around 40 - 60K I think.
The database is MySQL and the type is MEDIUMTEXT.
If I add content directly to the database, the application is able
to get it and display the entire content, but if I try to update is
crashes with:
[2005-08-26 03:36:18 CEST] <WorkerThread3>
<com.webobjects.appserver._private.WOComponentRequestHandler>:
Exception occurred while handling request:
com.webobjects.eoaccess.EOGeneralAdaptorException:
updateValuesInRowDescribedByQualifier --
com.webobjects.jdbcadaptor.JDBCChannel method failed to update row
in database
Anyone experience problem with long strings? Do I have to set
something to handle the long string correctly?
That error does not look like it has anything to do with the form.
Can you save changes made only in code? This error is saying that
the snapshot of the row that EOF holds does not match the values as
seen by the database. This could mean that something else has
changed the database, but probably indicates that one of the value
types in the model or the internal types are incorrect. Log out the
SQL Update statement and see what the Where clause is. One or more
columns are not matching. You might also get this if you are locking
on a timestamp or floating point number column.
Chuck
--
Practical WebObjects - a book for intermediate WebObjects developers
who want to increase their overall knowledge of WebObjects, or those
who are trying to solve specific application development problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden