[TYPO3-project-formidable] modify custom LISTER query

[Asbjørn Morell]

Hello,

Very nice :) Works great with a view.

Best regards.
Asbjørn Morell.




"Ivan Gomez Rodriguez" <igomez at igalia.com> wrote in message 
news:mailman.329692.1181993121.21067.typo3-project-formidable at lists.netfielders.de...
> Hi,
>
> I got a similar error. When formidable builds the query puts all fields
> from table specificates in <tablename>, then you need put all fields
> from that table in the SELECT which defines the view.
>
> Regards,
>
> Iván Gómez Rodríguez
> Ingeniero en Informática
> mailto:igomez at igalia.com
> Igalia-http://www.igalia.com
>
>
>
>
> Asbjørn Morell wrote:
>> 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
>>>>
>>
>> _______________________________________________
>> TYPO3-project-formidable mailing list
>> TYPO3-project-formidable at lists.netfielders.de
>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-formidable
>>