I am working with a form on an ASP page and getting the
following error when attempting to insert data into my
MSSQL7 table which had been working fine.

Microsoft OLE DB Provider for ODBC Drivers
error '80040e57'
[Microsoft][ODBC SQL Server Driver][SQL Server]String or
binary data would be truncated.
/respond.asp, line 90

Can someone tell me is this an invalid data issue or what
else it may be?

Thanks in advance.

Rodney,
This means that your ASP page is trying to insert data that is longer
than the allowed length. Let's say you have a field called firstname
defined as CHAR(15). If a client tries to insert more than 15 character
you will see this message.

Make sure that your program does not include invisible space characters
before or after the value, which will change the length.

AB


--

You don't pay to get spam, why pay to clean it?
Visit http://www.spammarshall.com to create an account for free
<http://www.spammarshall.com>

[quoted text, click to view]