DB_DataObjects - Long Column Names
| From: | Barry Steele | 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