[TYPO3] tt_news bug #5103

[Dmitry Dulepov [typo3]]

Francois Suter wrote:
> Hi,
> 
>> Should nt be SQL error. ###STORAGE_PID### is replaced by TCEforms. May 
>> be it simply does not find anything there?
> 
> Maybe, yes. I'm not sure indeed if MySQL throws an error for such a 
> malformed statement. I know PostrgreSQL would :-)

It is not true SQL :) ###STORAGE_PID### is replaced with a number. From core API doc about foreign_table_where:

---------------------------
You can use markers in the WHERE clause:
   1. ###REC_FIELD_[fieldname]###
   2. ###THIS_UID### - is current element uid (zero if new).
   3. ###CURRENT_PID### - is the current page id (pid of the record).
   4. ###STORAGE_PID###
   5. ###SITEROOT###
   6. ###PAGE_TSCONFIG_ID### -  a value you can set from Page TSconfig dynamically.
   7. ###PAGE_TSCONFIG_IDLIST### -  a value you can set from Page TSconfig dynamically.
   8. ###PAGE_TSCONFIG_STR### -  a value you can set from Page TSconfig dynamically.

The markers are preprocessed so that the value of CURRENT_PID and PAGE_TSCONFIG_ID are always integers (default is zero), PAGE_TSCONFIG_IDLIST will always be a commalist of integers (default is zero) and PAGE_TSCONFIG_STR will be addslashes'ed before substitution (default is blank string).
---------------------------

-- 
Dmitry Dulepov
TYPO3 core team
Web: http://typo3bloke.net/
Skype: callto:liels_bugs
"Nothing is impossible. There are only limits to our knowledge"