[TYPO3-dev] SQL - GROUP BY - returns false

[Tomas Norre Mikkelsen]

Hi,

When using this SQL:

    $result = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
                 'uid,question,reply,full_name,email', // SELECT
                 $this->dbExportTable, // FROM
                 '1=1 AND pid ="' . $pid . '"', // WHERE
                 'question,email,reply', // GROUP BY
                 '', // ORDER BY
                 ''// LIMIT
         );

$result is false, but if I echo the sql-statement:
SELECT uid,question,reply,full_name,email FROM tx_nicompetition_reply 
WHERE 1=1 AND pid ="61" GROUP BY question,email,reply

And paste it into fx. phpmyadmin, it works fine, any hints on the problem?

-- 
Venlig Hilsen / Best Regards
Tomas Norre Mikkelsen
Tomasnorre at gmail.com

TYPO3 Developer @netimage.dk
TYPO3 Profile:
http://forge.typo3.org/users/4289


Follow me at twitter
Twitter.com/tomasnorre