Very clever thinking indeed. Well, that's certainly revealed the problem ... ${listing.id} is empty on my sub-entity query ...
And this because I prefix the indexed ID with a letter <field column="id" name="id" template="L${listing.id}" /> This appears to modify the internal value of $listing.id for subsequent uses. Well, I can work around this now. Thanks! On Oct 4, 2010, at 9:35 AM, Stefan Matheis wrote: > Allistair, > > Indeed, I have a column that already works using a lower-case id. I wish >> I could debug it somehow - see the SQL? Something particular about this >> config it is not liking. >> > > you may want to try the MySQL Query-Log, to check which Queries are > performed? > http://dev.mysql.com/doc/refman/5.1/en/query-log.html