When I use SQLBuilder to construct a query, the SQL clause generated is
incorrect for anything that has a column name that deviates from Ian's
standard. A little digging shows that eg, Organisation.q is a SmartTable
instance, which tweaks any attribute access (like salespersonID) to
replace camelCaseNames with corresponding underscore_names. This is the
default attribute-to-column name mapping in SQLObject, but our database
doesn't use this convention.
I can simply tweak the module to stop Organisation.q from being a
SmartTable (and be explicit about the column names) - but is there any
simple way to have SQLBuilder get the dbName from the corresponding
SQLObject column attribute?
Thanks
Christian
|