Quoting "Adams, Stephen" <[EMAIL PROTECTED]>: > > The problem I am having is a "ODBC Error Code = 22001 (String data > right truncation)" error. > My table design is like this. > Column name Datatype Length > MessageID int 4 > MessageType char 20 > Department char 20 > CreationDate char 15 > PublicationDate char 15 > MessageTitle text 16 > MessageTeaser text 16 > MessageBody text 16 > I think that the problem is when the text is being added to the > fields, MessageTitle, MessageTeaser and MessageBody.
'Some text to throw error' is indeed longer as 16 characters. Not entirely unexpected behaviour, isn't it? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.