good idea! Thanks > -----Original Message----- > From: Customer Support [mailto:[EMAIL PROTECTED] > Sent: Monday, January 31, 2005 7:06 PM > To: [email protected] > Subject: Re: Witango-Talk: Eliminating the SQL error message on large > fields > > > Tom, > Make sure that you check your script with a browser with javascript > turned off. > > I would still recommend using @LEFT so only the first 8000 chars were > passed to the SQL server. > > Witango Support > > On 01/02/2005, at 10:56 AM, Tom Ferguson wrote: > > > 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 > > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
