[TYPO3-dev] Problem with pi_list_browseresults()

[Peter Russ]

Brian Bendtsen schrieb:
> Peter Russ skrev:
>> Brian Bendtsen schrieb:
>>> Peter Russ skrev:
>>>> IMHO at this point group by doesn't make any sense: you should 
>>>> better use order by and see what you get
>>>>
>>>> Regs. Peter.
>>>>
>>>>
>>> If I use "order by" I get a single row with the number 4. And I get 4 
>>> rows without the count. But this is no good as it will show 3 of the 
>>> same records on the front end.
>>>
>>> /BB
>>
>> Then it's time to rethink your query...
>>
> Well, there is nothing wrong with my query, I just need a function for 
> returning number of rows.
> 
> /BB
> 
Well: if you query returns a result of 4 rows, but you want to get only 
2 unique rows, than you should fix your query.
SQL just delivers what you ASK for and can not guess what you expect to 
get ;-)
Wrong result, wrong question . Pretty plain.

Regs. Peter.


-- 
Fiat lux!
Docendo discimus.
_____________________________
4Many® Services
openBC: http://www.openbc.com/go/invuid/Peter_Russ