data truncated with IP

[johnv20]

I'm updating a table with records of the form trackcode, string data - where string data is a varchar of size 999

While this is working most of the time, every now & again the string data seems to be getting truncated on insert to the database & is ended with IP

e.g.
correct - '<a val="123" /a><b val="233" /b>'
incorrect - '<a val="123" /a><b val=IP

Rerunning the insert always seems to resolve the issue & there are no database errors while this is occurring.

Any body got any idea what this IP value is???

 

[hmckillop]

Have you traced the call in profiler to ensure whatever is calling the INSERT statement isnt populating the string incorrectly?
Switch on SQL profiler and ensure you have the correct options on, and this should show whether the problem lies at the Application level (which I would guess it is).


"I'm living so far beyond my income that we may almost be said to be living apart

 

[johnv20]

I just found the problem - it's a bug in the app level, I really have left my brain at home today.

Thanks