Hi Jess,
I've not quite understood most of this thread, but it sounds like
what you want is:
Table with user1_id, user2_id,
query that returns all user2_id matching a given user_id AND
returns all user1_id that match when user2_is the given user_id..
correct?
Exactly! :)
I have this with DBIC, no unions involved ;)
Damn, it looks like this works perfectly! I was gonna give up on DBIC
but this
just saved my day ... :)
Thanks a lot, man!
--Tobias
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/dbix-class@lists.rawmode.org/
