[thelist] SQL Server smalldatetime field problems

[Steve Cook]

Looks like a different problem to me this time. Checking the code for values
longer than the space defined for them ("String or binary data would be
truncated.") I found this:

motiveContactMethod char 4 0 0 0  0   0
The value being added to this is 'Email' - 5 characters. I've not used the
"char" datatype myself, but I guess it's much the same as a varchar. You
probably want to change that.

Hope it helps.

.steve

----------------------------------
   WapWarp - http://wapwarp.com
 Wap-Dev - http://www.wap-dev.net
 Cookstour - http://cookstour.org
----------------------------------