[TYPO3-project-formidable] modify custom LISTER query

[Asbjørn Morell]

Hello,

That might be what I was looking for. Hmmm I get an error when I try to use 
a compileddatasource:

caller t3lib_DB::sql_query

ERROR Unknown column 'plain.pid' in 'field list'

lastBuiltQuery SELECT SQL_CALC_FOUND_ROWS 
plain.uid,plain.pid,plain.tstamp,plain.crdate,plain.cruser_id,plain.deleted,plain.hidden,plain.text,plain.price,plain.category,plain.image,plain.title
FROM tx_myart_art467304d960658467304d96e1a9 AS compiled, 
tx_myart_art467304d960658 AS plain
WHERE
1 AND plain.uid = compiled.uid
ORDER BY compiled.uid DESC

debug_backtrace require // include // TSpagegen::renderContent // 
tslib_cObj->cObjGet // tslib_cObj->cObjGetSingle // tslib_cObj->COBJ_ARRAY 
// tslib_cObj->cObjGet // tslib_cObj->cObjGetSingle // tslib_cObj->CTABLE // 
tslib_cObj->cObjGet // tslib_cObj->cObjGetSingle // tslib_cObj->CONTENT // 
tslib_cObj->cObjGetSingle // tslib_cObj->cObjGetSingle // 
tslib_cObj->CASEFUNC // tslib_cObj->cObjGetSingle // tslib_cObj->COBJ_ARRAY 
// tslib_cObj->cObjGet // tslib_cObj->cObjGetSingle // tslib_cObj->CASEFUNC 
// tslib_cObj->cObjGetSingle // tslib_cObj->cObjGetSingle // 
tslib_cObj->USER // tslib_cObj->callUserFunction // call_user_method // 
tx_myart_pi1->main // tx_ameosformidable->render // 
tx_ameosformidable->_render // tx_dhlister->_doTheMagic // 
t3lib_DB->sql_query // t3lib_DB->debug


Formidable : Mayday
SQL QUERY IS NOT VALID
Unknown column 'plain.pid' in 'field list'
SELECT SQL_CALC_FOUND_ROWS 
plain.uid,plain.pid,plain.tstamp,plain.crdate,plain.cruser_id,plain.deleted,plain.hidden,plain.text,plain.price,plain.category,plain.image,plain.title 
FROM tx_myart_art467304d960658467304d96e1a9 AS compiled, 
tx_myart_art467304d960658 AS plain WHERE 1 AND plain.uid = compiled.uid 
ORDER BY compiled.uid DESC


This is my LISTER:
  <datahandler:LISTER>

   <tablename>tx_myart_art</tablename>
   <keyname>uid</keyname>
   <labelname>title</labelname>

        <compiledatasource>
          <view>
            <select><![CDATA[

          SELECT
      tx_myart_art.uid AS uid,
      tx_myart_art.cruser_id AS cruser_id,
      tx_myart_art.title AS title,
      tx_myart_art.category AS category,
      tx_myart_images.title AS imgtitle,
      fe_users.name as name
    FROM
      tx_myart_art
      LEFT OUTER JOIN tx_myart_art_image_mm ON (tx_myart_art.uid = 
tx_myart_art_image_mm.uid_local)
      LEFT OUTER JOIN tx_myart_images ON (tx_myart_art_image_mm.uid_foreign 
= tx_myart_images.uid)
      LEFT OUTER JOIN fe_users ON (tx_myart_art.cruser_id = fe_users.uid)
    GROUP BY
      tx_myart_art.uid

            ]]></select>
          </view>
        </compiledatasource>




   <pager>
    <rows>
     <perpage>10</perpage>
     <alternate>###ROW1###</alternate>
    </rows>
    <nav>
     <window>7</window>
    </nav>
   </pager>

   <callback>
    <userobj>
     <php><![CDATA[

      $aParams = func_get_args();
      $this->_oParent->sHtmlList = $aParams[1]["HTML"];

     ]]></php>
    </userobj>
   </callback>


  </datahandler:LISTER>


Possible a bug?

Best regards.
Asbjørn Morell.


"Ivan Gomez Rodriguez" <igomez at igalia.com> wrote in message 
news:mailman.327483.1181907021.21067.typo3-project-formidable at lists.netfielders.de...
> Hello,
>
> You can try with compiledatasource.
>
> http://lists.netfielders.de/pipermail/typo3-project-formidable/2006-December/000162.html
>
>
>
> Asbjørn Morell wrote:
>> Hello,
>>
>> I have a page that generates a search form and a lister from the same xml
>> file. (sHtmlList) I have created a custom query for my lister, but now my
>> search form does not work anymore. My custom query is executed each time 
>> and
>> all my input fields gets ignored. Also tried with <overridesql> and
>> <onfields> . Any ideas?
>>
>> Best regards.
>> Asbjørn Morell.
>>
>>
>>    <search>
>>     <sql>
>>      <query>
>>
>>       <userobj>
>>        <php><![CDATA[
>>
>>        return "
>>
>>        SELECT
>>          tx_myart_art.uid,
>>          tx_myart_art.cruser_id,
>>          tx_myart_art.title,
>>          tx_myart_art.category,
>>          tx_myart_images.title AS img_title,
>>          fe_users.name
>>        FROM
>>          tx_myart_art
>>          LEFT OUTER JOIN tx_myart_art_image_mm ON (tx_myart_art.uid =
>> tx_myart_art_image_mm.uid_local)
>>          LEFT OUTER JOIN tx_myart_images ON
>> (tx_myart_art_image_mm.uid_foreign = tx_myart_images.uid)
>>          LEFT OUTER JOIN fe_users ON (tx_myart_art.cruser_id = 
>> fe_users.uid)
>>        GROUP BY
>>          tx_myart_art.uid
>>
>>          ";
>>
>>        ]]></php>
>>       </userobj>
>>      </query>
>>     </sql>
>>    </search>
>>
>> _______________________________________________
>> TYPO3-project-formidable mailing list
>> TYPO3-project-formidable at lists.netfielders.de
>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-formidable
>>