[TYPO3-english] SQL and checkbox 4 boxes ?
Xavier Perseguers
typo3 at perseguers.ch
Fri May 7 15:58:05 CEST 2010
Hi,
> But in the table it stores only integers ! How can I test what is checked in
> SQL query ?
>
> Like "where tx_topsolidvar_var.certification.I.0 = 1"
The integer that is stored is a bitmask of your checkboxes. That is you have to use bit operation in your query:
http://dev.mysql.com/doc/refman/5.0/en/bit-functions.html
--
Xavier Perseguers
http://xavier.perseguers.ch/en
More information about the TYPO3-english
mailing list