Thank you all for your responses... a big help, as always. What I ended up doing was add javascript to count the letters as they were typed into the textarea and display the count below the textarea. If more than 8000 characters are entered, it gives an error message. If you try to submit with too many characters (in case you pasted more characters than allowed) it tosses up an error telling you to remove x number of excess errors.
Thanks again for everyone's responses... I don't mess with this stuff enough anymore to keep my brain engaged :( Tom > -----Original Message----- > From: Russell Stephany [mailto:[EMAIL PROTECTED] > Sent: Monday, January 31, 2005 6:29 PM > To: [email protected] > Subject: Re: Witango-Talk: Eliminating the SQL error message on large > fields > > > tom, > > > "Tom Ferguson" <[EMAIL PROTECTED]> wrote on 01/02/2005 09:50:54 AM: > > > 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? > > > when i use textareas, i tend to put a javascript on the page which checks > the length of the data in the field before leaving the page. if it's too > long, i pop up an alert and abort the submit. > > cheers, > > russell > > > TIA > > > Tom Ferguson > > > ________________________________________________________________________ > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > _______________________________________________________________________ > DISCLAIMER > > This email and any files transmitted with it are confidential and > may be subject to copyright. They are intended solely for the use of > the individual or entity to whom they are addressed. If you have > received this message in error please notify the AGSM immediately > by return email or reverse charge telephone call to +61 2 9931 9200. > Any views or opinions presented in this email are solely those of the > author and do not necessarily represent those of the AGSM, except > where an authorised sender specifically states them to be the views > of the AGSM. > > It is your responsibility to check this email and any attachments > for the presence of viruses. The AGSM accepts no liability for any > damage caused by any virus transmitted. > _______________________________________________________________________ > > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
