Details
-
Improvement
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
3.0
-
None
Description
"SELECT *" SQLTemplates sometimes mess up the capitalization of labels in a returned DataRow, so it can't be converted to an object properly. Most users would follow a naming convention for the table names (ALL_UPPERCASE or all_lowercase). Unfortunately such mapping will not work consistemtly across different databases and SELECT * queries. So what was suggested on the mailing list [1] to address this problem (and avoid using #result workaround) is an API to force capitalization of the result set labels.
I did a few preliminary tests, and this solution works extremely well.
[1] http://objectstyle.org/cayenne/lists/cayenne-user/2007/06/0044.html