DB_DataObjects - Long Column Names

From: Date: Sat, 04 Jun 2005 04:22:13 +0000
Subject: DB_DataObjects - Long Column Names
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-19454@lists.php.net to get a copy of this message
Hi, We have just come across a very bemusing issue with DataObjects. We have table with a column whose name is 32 characters long (don't ask why). in our development environment this works just fine, but when we moved into pre-production testing (on the target box) we noticed the the query that was generated has the last 3 characters chopped off. THe attribute name in the object remained correct, but of course never gets set the column name is something like 'InternalMembershipCategoryTypeID'. As soon as we shortened the attribute name it works - on both platforms. Both platforms are using DataObjects 1.7.1. I have not as yet had time to look at the DBO code, but I thought that this might be of interest to other folks. -- Stay happy, stay well ... get involved Barry Steele www.hpfm.com.au mob: +61 413 947980 off: +61 2 99816329 fax: +61 2 9981 7806

« previous php.pear.general (#19454) next »