[TYPO3] Error in SQL with $GLOBALS['TYPO3_DB']->SELECTquery
Stephen Bungert
s.bungert at metrinomics.de
Fri Jun 6 15:21:04 CEST 2008
Hello List members,
$whereClause =
$this->MOD_MENU['function'][(string)$this->MOD_SETTINGS['function']];
$query = $GLOBALS['TYPO3_DB']->SELECTquery(
'*',
'tx_metri_secure_log',
'website=' . $whereClause,
'',
$this->sortOrder,
$this->dlLimit
);
I have the following code in a module I'm making,
The error is in the where clause.
Here is the debug outputs last query built:
lastBuiltQuery
SELECT *
FROM tx_metri_secure_log
WHERE
pid=fmf.stephen.local
ORDER BY tstamp DESC
LIMIT 10
What could be causing it? Why, in the output, is the where clause on it's
own line? The other clauses are all on one line.
Stephen
More information about the TYPO3-english
mailing list