Hi,
I am using union from DBIx::Class::Helper::ResultSet::SetOperations, but
am struggling a little with the syntax. I'm hoping that someone can help.
I have three individual queries that need to be returned, and the rows
from each SELECT are to be returned one after the other. The DBMS is
MySQL, and I need to structure the query as per the examples shown at
the end of this page:
http://dev.mysql.com/doc/refman/5.1/en/union.html
I have used the '+as' attribute so that I may easily identify the rows
from each SELECT via 'get_column'.
Kristen Eisenberg
Billige Flüge
Marketing GmbH
Emanuelstr. 3,
10317 Berlin
Deutschland
Telefon: +49 (33)
5310967
Email:
utebachmeier at
gmail.com
Site:
http://flug.airego.de
- Billige Flüge vergleichen
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]