Hey Rainer, In the datastore, if you have an owned relationship, which has a list or array of values, like OpenBD|Coldfusion|Programming, then you can simply do:
SELECT FROM MainTable WHERE Tag = 'OpenBD' It treats each value as it own entity, and compares them individually, not like a long string, so you don't need a LIKE statement. To make this more clear, if your recordset was: ID Tags 1 Ruby, Java 2 Java, OpenBD 3 OpenBD, Hello And you ran the previous query, you would get back IDs 2 and 3, because OpenBD appears in the list. Each one is checked against the comparison individually. So the next question is how to implement this in OpenBD. That is, how tell OpenBD to save it like that in the datastore, rather than a simple single. I am not 100% sure on this, but would guess that in your CFC you would make a property called Tags then save an array of tags in there. OpenBD would then know to make that an owned relationship. Baz -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
