[Typo3-dev] Nested Queries in MySQL wrapper class

[Karsten Dambekalns]

Hi,

On 2004-07-16, Rainer Kuhn <kuhn at punkt.de> wrote:
> Joel Faucett wrote:
>>    How does one implement nested queries in the wrapper functions? e.g. 
 ...
> maybe this is the issue:
> http://dev.mysql.com/doc/mysql/en/Subquery_errors.html

Indeed, if you really tried to use nested queries, this won't work
with MySQL. Plus it won't be supported by the SQL parser of the DB
wrapper stuff in TYPO3.

Have you tried the SQL statement on the command line, i.e. have you
verified it works outside of TYPO3?

To make it work, you could perform the first select, implode the
results and then use the list of ids directly in your query.

Karsten