[TYPO3-core] [dbal] RFC Bug-fix 0010411: table name are not mapped in the value part of a query and in inner join

[Xavier Perseguers]

Hi,

> Branches: trunk/typo3/sysext/dbal/ (revision 4432)
> 
> Bugtracker reference: http://bugs.typo3.org/view.php?id=10411
> 
> Problem:
> when having a query like this:
> 
> SELECT table1.* FROM table1 INNER JOIN table2 ON table1.uid = table2.fk_table1 WHERE table1.price < table2.cost
> 
> INNER JOIN and all other join(i suppose) are not supported for the mapping 
> 
> table2 is not mapped in the where 
> 
> Solution:
> add join mapping in map_remapSELECTQueryParts function and modify value mapping in map_sqlParts function 
> 
> Index: trunk/typo3/sysext/dbal/class.ux_t3lib_db.php

My mailing list box has been completely rebuilt yesterday and Thunderbird got me very old posts too. I missed this one when I created thread "RFC #10411: table name are not mapped in the value part of 
a query", on 19-10-2009. I reply to this one just to have kind of a link to the other thread and to somehow "close" this one.

Cheers

-- 
Xavier Perseguers
http://xavier.perseguers.ch/en

One contribution a day keeps the fork away