[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