[Typo3-dev] Help with extension (TCA?)

[Joshua Preston]

Rainer,

Well, I used the extension kickstarter to setup the database tables, the 
m_to, m_cc and m_bcc fields are  all field types "database relation", 
with a relation to Front End Users, (fe_users) .  The relation type is 
Field with Element Browser.  It has 20 max num relations.  I'm not using 
True M-M relations, so its a commalist of values.  Should I have used 
M-M relations?  I wasn't sure about that, but it says that (otherwise 
commalist of values).  I didn't really think True M-M relations were 
good, but should I go that route?  I'd still have the same problem, but 
maybe filtering the messages would perhaps be easier?

Rainer Kuhn wrote:

> Joshua Preston wrote:
>
>> I've tried adding to the SELECT statement, but the problem is that 
>> smaller number can fit into bigger ones (ie 2 is in 12 and 22 and 2000).
>
>
> Hi Joshua,
>
> I didn't get the exact problem!? Do you use comma seperated string 
> lists? Using FIND_IN_SET('2', $yourStringDatabaseField) you can get a 
> single numeric element from a comma seperated list (see e.g. 
> http://dev.mysql.com/doc/mysql/en/string-functions.html)
>
>
> Rainer
> _______________________________________________
> Typo3-dev mailing list
> Typo3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev