Date: 07/24/07 (SQL Server)    Keywords: asp

My previous post was easily solved but face a new one now. I am getting a String or binary data would be truncated error with the same AddUser stored procedure.

I double-checked that the sizes for the varChar and longVarChar fields were correct in both my code and the SP, and they are.

I am still learning a lot of the intricacies of using SP's in ASP/VB so I'm still highly uncertain on many things here.

Sample output. The length of the field is in parenthesis:
usrCategory: 2 (1)
usrCity: Manyunk (7)
usrZipcode: 19127 (5)
templateid: (0)
subaction: create (6)
ID: 0 (1)
usrEmail: testuser321@aol.com (19)
usrIsActive: 0 (1)
submit: Submit (6)
validate: 1 (1)
usrUserId: test1123 (8)
usrPassword: asdfsdf (7)
usrAddressID: (0)
usrContactMeansID: (0)
usrAddress1: 1900 West Ln. (13)
usrAddress2: Suite 4000 (10)
usrStatus: 7 (1)
usrFirstName: Bob (3)
usrPhone: 555-7878 (8)
usrPhoneExt: 351 (3)
usrMiddleInitial: A (1)
usrNonUsState: (0)
usrLastName: Smith (5)
usrCompany: Big Company (11)
usrFax: 555-9663 (8)
usrInactiveReason: just a test (11)
usrTitle: Big Chief (9)
usrCountry: 225 (3)
usrStateID: 38 (2)
usrComments: (0)

And turning off ANSI_WARNINGS is not an option.

Source: http://community.livejournal.com/sqlserver/61758.html