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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-08 : 15:45:23
|
Chris writes "I'm doing work on a site which constructs a huge string of user details and then tries to put it in a SQL string.
The constructed string is:
"UPDATE Label SET SystemLabel='Sex: male; Age: 31
Occupation: Webmaster
Industry: Information Technology
Born In: AUSTRALIA
Grew up in: AUSTRALIA
Smokes: No
In a Relationship: No
Children: Does not have children
Pets:
Lifestyle Code: A
Leisure Code: 2
Vital requests:
' WHERE MemberID=65776"
This create an error message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.
Believe it or not, this statement is supposedly used on the current website without problems, which (if to be believed) rules out the syntax with all those extra lines.
Is there some way of setting the allowable string length on either the ASP server (NT4,IIS) or the Database (SQL7 SP3) Server? These are two different machines.
I'm learning on the fly here (who isn't right?), and very confused.
TIA
CB" |
|
|
|
|
|
SQL Query Length