[TYPO3-dev] Problem with long strings in tt_content (Oracle)

[Moreno Feltscher]

I completely agree with you Dmitry. If I can solve this problem I'll
share the solution with the community.

Now, I've got another question and I don't want to open a new list
entry for this:
How can I do an INNER JOIN in TYPO3 database syntax? I tried something
like this:
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
      'tt_content.uid AS uid, tt_content.pid AS pid, pages.title AS
title, tt_content.header AS header, tt_content.bodytext AS bodytext,
'.$this->config['sqlTstampField'].' AS tstamp',
      'tt_content INNER JOIN pages ON pages.uid = tt_content.pid',
      'tt_content.pid in ('.$in_pid_list.')
        AND tt_content.sys_language_uid = '.$syslanguage.'
        AND tt_content.pid <> 1'.
        $this->config['sqlAndWhere'].' '.
        $this->cObj->enableFields('tt_content')
      ,
      '',
      $this->config["sqlOrderBy"],
      '0,'.$this->config['maxRecs']
    );

But I only get an error with this...:
ORA-00904: "pages"."title": invalid identifier
The SQL-Command which is done by DBAL:
tt_content tt_content.uid AS uid, tt_content.pid AS pid, pages.title
AS title, tt_content.header AS header, tt_content.bodytext AS
bodytext, tt_content.tstamp AS tstamp tt_content.pid in (123) AND
tt_content.sys_language_uid = AND tt_content.pid <> 1 AND
tt_content.deleted=0 AND tt_content.t3ver_state!=1 AND
tt_content.hidden=0 AND (tt_content.starttime<=1196948990) AND
(tt_content.endtime=0 OR tt_content.endtime>1196948990) AND
(tt_content.fe_group='' OR tt_content.fe_group IS NULL OR
tt_content.fe_group='0' OR (tt_content.fe_group LIKE '%,0,%' OR
tt_content.fe_group LIKE '0,%' OR tt_content.fe_group LIKE '%,0' OR
tt_content.fe_group='0') OR (tt_content.fe_group LIKE '%,-1,%' OR
tt_content.fe_group LIKE '-1,%' OR tt_content.fe_group LIKE '%,-1' OR
tt_content.fe_group='-1')) tstamp DESC 0,10

There isn't a SELECT or WHERE clause... stupid, what's wrong..?


Moreno