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
