Hello Tom,
why don't you convert the fields to "text" fields in SQL server? I think text fields might be better, even from a performance point of view. Text fields are not limited in size, and you can still perform searches on them (searches are costly, though).
Peter
----- Original Message ----- From: "Tom Ferguson" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, January 31, 2005 11:50 PM
Subject: Witango-Talk: Eliminating the SQL error message on large fields
There's probably some simple way to do this, but it escapes me at the moment.
I have a form with several large fields (8000 chars). They are defined as
Textarea fields so there is no way to limit their size via HTML (that I know
of). So if someone types 8010 chars, SQL throws an overflow error
([Microsoft][ODBC SQL Server Driver]String data, right truncation 22001)
How can I avoid this situation? I'd like to either limit the number of characters in the input, or bypass the error.
Any suggestions?
TIA
Tom Ferguson
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
