[html-formfu] HTML::FormFu and many-to-many model

[Alex Povolotsky]

Zbigniew Lukasiak wrote:
> On Mon, Mar 31, 2008 at 4:44 PM, Alex Povolotsky <tarkhil at over.ru> 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

Alex.