Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gbaia
Yak Posting Veteran
52 Posts |
 Posted - 2004-05-11 : 07:13:27
|
| I have a very simple form with 5 text boxes. One of them is a nvarchar(100) and every time I try updating or inserting something on it, I get the error below.It seems like it's inserting white spaces in the end, if I delete them, it works... (see country_name post data in the error). This never happened before!! :-(Any idea of how I can sort this out? Thank You!!!!Technical Information (for support personnel)Error Type:Microsoft OLE DB Provider for SQL Server (0x80040E21)Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done./admin/aux_country_add.asp, line 19Page:POST 193 bytes to /admin/aux_country_add.aspPOST Data:Country_Code=fbs4&Country_Name=test+to+see+if+it+works++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++&Active=on&PC=on&Submit=Submit&submitted=-1Grazi |
|
|
vganesh76
Yak Posting Veteran
64 Posts |
Posted - 2004-05-26 : 00:17:52
|
| This only happens when the data inserted being is longer than the one defined in table.Can u trim the values before inserting the values.Enjoy working |
 |
|
|
|
|
|
Error on updating or inserting a simple form