[Dbix-class] Union and Limit

[Kristen Eisenberg]

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=FCge
Marketing GmbH
Emanuelstr. 3,
10317 Berlin
Deutschland
Telefon: +49 (33)
5310967
Email:
utebachmeier at
gmail.com
Site:
http://flug.airego.de
- Billige Fl=FCge vergleichen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20111021/05d=
3d536/attachment.htm