On Tue, Apr 1, 2008 at 12:13 PM, Alex Povolotsky <[EMAIL PROTECTED]> wrote: > Zbigniew Lukasiak wrote: > > On Mon, Mar 31, 2008 at 4:44 PM, Alex Povolotsky <[EMAIL PROTECTED]> wrote: > > > >> Hello! > >> > >> Can someone please provide me with working example of many_to_many > >> relationship with HTML::FormFu config file?... > >> > > > > Have a look at the t directory :) > > > > Looked. Got some problems. > > First of all, HTML::FormFu assumes that fields to join are named > different in different tables. > > For instance, > > table alarm (alid primary key, name text) > table abonent (abid primary key, name text) > table a_to_a (alid references alarm(alid), abid references abonent(abid)) > > with standard DBIx::Class::Schema classes (autogenerated by Catalyst > helper) yields > > SELECT abid FROM a2a me JOIN abonent abid ON ( abid.abid = me.abid ) > WHERE ( me.alid = ? ): '1' > > which fails with error on Postgres. > > Well, I've changed table definitions, and > > (1) I do not understand how to specify text field > (2) why do I get empty select and no attempt to extract anything from > abonents table >
Please try to write a test case - this looks like an important bug - but it's very hard to guess what is really failing. First verify it if is really a PostgreSQL thing - check if the same schema works in SQLite. \ > > > Alex. > > > _______________________________________________ > HTML-FormFu mailing list > [email protected] > http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/html-formfu > -- Zbigniew Lukasiak http://brudnopis.blogspot.com/ _______________________________________________ HTML-FormFu mailing list [email protected] http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/html-formfu
