Zbigniew Lukasiak wrote:
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.
\
Well, I've added print $form->render to
t/defaults_from_model/many_to_many_select.t
Got empty select. And (potentially) incorrect select. Something must be
wrong.
Try
env DBIC_TRACE=2 perl t/defaults_from_model/many_to_many_select.t
to get
SELECT id FROM user_band me JOIN band band ON ( band.id = me.band )
WHERE ( me.user = ? ): '2'
instead of
SELECT band.id FROM user_band me JOIN band band ON ( band.id = me.band
) WHERE ( me.user = ? ): '2'
Alex.
_______________________________________________
HTML-FormFu mailing list
[email protected]
http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/html-formfu
