[TYPO3-project-formidable] _sqlSearchClause in class.tx_rdtcheckbox.php

[Oliver Klee]

Hi,

Albert van der Veen schrieb:
> If you enter data in a record of type 'check' in the typo3 BE, the value
> inserted in the db is an integer, where each bit represents the state of
> the corresponding checkbox item in the tca definition of the field.
> 
> However, the sql generated in the renderlet class, seems to assume the
> data is a comma-seperated list of values. So it generates FIND_IN_SET
> query parts.

There are two ways to create checkboxes in the BE: The bit field which
you describe above (which is really ugly to handle), and the nicer way
which looks like this in flexforms and which creates a comma-separated
list of keys:

<label>LLL:EXT:seminars/pi1/locallang.xml:seminars.pi_flexform.displayFrontEndEditorFields</label>
<config>
	<type>select</type>
	<items type="array">
		<numIndex index="0" type="array">
			<numIndex
index="0">LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.subtitle</numIndex>
			<numIndex index="1">subtitle</numIndex>
		</numIndex>
		<numIndex index="1" type="array">
			<numIndex
index="0">LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.accreditation_number</numIndex>
			<numIndex index="1">accreditation_number</numIndex>
		</numIndex>

...



Oliver