ColdFusion查询:ODBC Error Code = 22001 (String data right truncation)
那位大侠能帮助我解决一下,下面这个问题?非常感谢....
当我提交表单时,就出现如下的错误 ,急.........
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 22001 (String data right truncation)
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.
Date/Time: 12/06/09 23:46:54
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; CIBA; MAXTHON 2.0)
Remote Address: 114.243.229.154
[解决办法]
coldfusion的datasource有最大取出数据的长度。你拿的字段里,有个字段可能内容太长。到administration里,修改一下datasource里的那个值就可以。