On Tue, Aug 25, 2009 at 9:57 AM, Tim Claremont<[email protected]> wrote: > > Just about everything else in my move from CF7 to CF8 went well, except when > I try to update an Access database. I get the following: > > Error Executing Database Query. The field is too small to accept the amount > of data you attempted to add. Try inserting or pasting less data. > > The database has been in use under CF7 for years, and works fine. It really > is not a matter of field sizes or anything like that. I am using the build in > Access driver and have everything set exactly the same as my production CF7 > server.
Are you sure the old Access drivers didn't just automatically trim the data to size? We migrated an application from Access to SQL Server and had that problem... where as Access (on the old system) didn't care about the field size, it would just auto-trim... SQL Server bitched. The old ACcess system we ran was CFMX7, so it may be a similar situation. Maybe the Access drivers in CF8 are different and are less accepting of oversized data? One way to be sure is to cfqueryparam the query where you're getting this error, and put maxlength="xx" on all the insert/update params, and see if CF bitches about it - just make sure you use the correct sizes from the table definition. -- Rick Root CFFM - Open Source Coldfusion File Manager http://www.opensourcecf.com/cffm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325676 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
