hi,
how can I use a query like:

SQL> SELECT a
 FROM test_table
 CONNECT BY PRIOR b=a
 
in my controller like:
$c->stash->{a} = [ $c->model('MyAppDB::Bla')->search({ }, ???????????????? { }  
)];


SQL> SELECT * FROM test_table;

          A              B
-----------     ----------
          1             -1
          2              1
          3              1
          4              2
          5              2
          6              4
          7              4
          8              5
          9              5
         10              3
         11              3

Can anyone help me here in the catalyst-list? 
Or post it to thedbix-list?


thanks - ulf.


p.s. : are there any experience with analog features for mysql?


begin:vcard
fn:Dr. Ulf Lenski
n:Lenski;Ulf
email;internet:[EMAIL PROTECTED]
tel;work:030 9406 2983
tel;fax:030 9406 2925
x-mozilla-html:FALSE
url:http://www.proteinstrukturfabrik.de/~lenski
version:2.1
end:vcard

_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/

Reply via email to