Classic ASP Discussion - field too small to accept data

Print Page | Close Window

field too small to accept data

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=6392
Printed Date: 31 March 2026 at 3:07pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: field too small to accept data

Posted By: cuedog
Subject: field too small to accept data
Date Posted: 13 October 2003 at 9:32pm

Here is an easy one that I can't figure out. I have a form with an input field with a max character input of 50 and in the database(MS Access) I have a text field(50) but for some reason I keep getting this error. I have tried to input the max characters and everything works fine.

Category = Microsoft JET Database Engine
Number = 0x80040E57
Description = The field is too small to accept the amount of data you
attempted to add. Try inserting or pasting less data.

This is a poll demo

If a foreign language is written in the input field can it input more than 50 characters?

-------------
http://www.512ryders.com - 512 Ryders

Replies:

Posted By: vshriniwasan
Date Posted: 14 October 2003 at 9:44am

Try to Trim the the variable you are receiving and do a len on that. That will tell you how many char are coming through. Then try without trim and see what happens. that would give some idea of what size value coming through.

Posted By: cuedog
Date Posted: 14 October 2003 at 4:36pm

Good idea, Thanks! Now I know another way of debugging my scripts.

-------------
http://www.512ryders.com - 512 Ryders