[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