Process works fine... how to track which column is causing error..

hi, have big sp lets tasks a, b, c, d... after every task i.e a, b, c, d have update or insert statement. update & insert both work fine, except have coldfusion catch code sp execution , returns string or binary data truncated error. means inserting column lenght less whats being inserted. understand , how can determine column causing problem since after tasks a,b,c,d insert or update have working fine. have easy if couldnt have seen inserted or updated records, in case functionality working fine except coldfusin gives error want avoid.

thanks in advance.

this not coldfusion problem.

the sp needs catch own errors @ each step a, b, etc. , warn if data going truncated.

it should obvious looking @ table , sp design columns @ risk.

More discussions in Advanced Techniques

adobe