********************************************************************** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message **********************************************************************
Thanks Rizal, but the problem was caused by another field being to small, not the three I originally thought. Stephen -----Original Message----- From: Rizal Firmansyah [mailto:rizal.firmansyah@;sentracommerce.com] Sent: 28 October 2002 15:42 To: CF-Talk Subject: Re: OT: SQL Server database problem Just another taught... Using varchar instead of text as a datatype for this kind of data maybe helpful... Rizal At 10:21 PM 10/28/2002, you wrote: >I think the error message is straight forward, >that is you are trying to insert string that's longer than your datatype >can handle. > >For example: >Field: MessageTitle (16): You are trying to insert: "Some text to throw >error" which has 24 characters. > >Try to increase the length of the field in your DB. > >HTH, >Rizal ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm