[Typo3-dev] t3lib_befunc::deleteClause

Martin Kutschker martin.kutscher.n0 at 5pam.blackbox.net
Tue Mar 22 13:16:15 CET 2005


Hi!

So you can use FROM table AS alias in self written SELECT/WHERE clauses:

 function deleteClause($table,$alias='') {
  global $TCA;
  if ($TCA[$table]['ctrl']['delete']) {
   $tbl = $alias ? $alias : $table;
   return ' AND '.$tbl.'.'.$TCA[$table]['ctrl']['delete'].'=0';
  } else {
   return '';
  }
 }

Reason: my Mysql 4.0 doesn't like the real tablename when I uses aliases.

Masi






More information about the TYPO3-dev mailing list