[TYPO3-english] TYPO3 LIMIT from flexform field

Adrian Marcinkowski amarcinkowski at gmail.com
Tue Jul 16 12:40:26 CEST 2013

Hi list,

I just insert to flexform field max_item_to_display and try to get that
value in my SELECT query:

$maxDisplayItem = $this->_getFlexformConfig('max_item_to_display');

$dbResource =
$GLOBALS['TYPO3_DB']->exec_SELECTquery('*',                           //

'tx_mageconnect_products',     // FROM
                                                     'product_id IN
                                                        AND store_view =
                                                        AND hidden = \'0\'
                                                        AND deleted = \'0\'
                                                        AND pid =
\''.$pid.'\'',    // WHERE

'product_id',                  // GROUP BY

'',                            // ORDER BY

'$maxDisplayItem'              // LIMIT

The value of max_item_to_display is in tt_content table, but above code
didn't work.

Any suggestion?

More information about the TYPO3-english mailing list