Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Re: String or binary data would be truncated.


Message #1 by <risho@c...> on Thu, 16 May 2002 14:05:47 -0400
Sounds like your table field is too small. Not sure though.

Eric
> 
> From: Aftab Ahmad <aftab.ahmad@k...>
> Date: 2002/05/16 Thu AM 05:08:43 EDT
> To: "ASP Databases" <asp_databases@p...>
> Subject: [asp_databases] String or binary data would be truncated.
> 
> Hello
> 
> I got following error message while inserting a record in table through a
> stored procedure.
> 
> Error message:
> 
> Microsoft OLE DB Provider for SQL Server error '80040e57' 
> 
> String or binary data would be truncated. 
> 
> /aspapps/AnsattFiles/Admin/inserted.asp, line 61 
> 
> 
> 
> Can anyone help me.
> Thanks in advance.
> 
> 
> Aftab
> 
> 

Message #2 by "Patrick Sullivan" <pat@s...> on Thu, 16 May 2002 04:29:34 -0500
One of the fields being inserting is too long for the table, check your
field sizes against the expected data and you should be ok.

-----Original Message-----
From: Aftab Ahmad [mailto:aftab.ahmad@k...] 
Sent: Thursday, May 16, 2002 4:09 AM
To: ASP Databases
Subject: [asp_databases] String or binary data would be truncated.

Hello

I got following error message while inserting a record in table through
a
stored procedure.

Error message:

Microsoft OLE DB Provider for SQL Server error '80040e57' 

String or binary data would be truncated. 

/aspapps/AnsattFiles/Admin/inserted.asp, line 61 



Can anyone help me.
Thanks in advance.


Aftab



Message #3 by Aftab Ahmad <aftab.ahmad@k...> on Thu, 16 May 2002 11:08:43 +0200
Hello

I got following error message while inserting a record in table through a
stored procedure.

Error message:

Microsoft OLE DB Provider for SQL Server error '80040e57' 

String or binary data would be truncated. 

/aspapps/AnsattFiles/Admin/inserted.asp, line 61 



Can anyone help me.
Thanks in advance.


Aftab

  Return to Index