[TYPO3-dev] pi_exec_query with addWhere returns only one element, what is wrong?

[Matthias Stuebner]

On Mon, 27 Nov 2006 09:36:25 -0800, Christopher Torgalson wrote:

>> // 2. Extend WHERE clause to return only selected items
>> $addUidList = "('".$comma_separated."')";
>> $addWhere = 'AND uid IN '.$addUidList;
> 
> If this is a direct c&p from your code, I'd guess it's a missing space
> before 'AND'; the comments in the code have this to say about this
> function:
> 
> 'Additional WHERE clauses (should be starting with " AND ....")'

But in class.tslib_pibase you see a space added:

// Add '$addWhere'
if ($addWhere)	{$WHERE.=' '.$addWhere.chr(10);}

So I wouldn't see any difference, but will try it too.

> If you're not already using it, the extension development evaluator
> [1] is an excellent tool for helping with the pibase (and other) API.

Will give it a try, thanx.

-- 
br Matthias