Greetings, I can't seem to get the authors form the books list in the Catalyst::Manual::Tutorial
[% tt_authors = [ ];
tt_authors.push(author.last_name) FOREACH author = book.authors %]
([% tt_authors.size | html %])
[% tt_authors.join(', ') | html %]
the schema for the SQLite database is
sqlite> .schema
CREATE TABLE author (
id INTEGER PRIMARY KEY,
first_name TEXT,
last_name TEXT
);
CREATE TABLE book (
id INTEGER PRIMARY KEY,
title TEXT ,
rating INTEGER
);
CREATE TABLE book_author (
book_id INTEGER REFERENCES book(id) ON DELETE CASCADE ON UPDATE
CASCADE,
author_id INTEGER REFERENCES author(id) ON DELETE CASCADE ON UPDATE
CASCADE,
PRIMARY KEY (book_id, author_id)
);
I'm probably messing up between the TT and SQL and DBIx::Class nomenclature in
the FOREACH statement.
But I can's see the error.
I get this:
[cid:[email protected]]
no author names recovered.
Suggestions greatly appreciated.
Tom
MMI DNA Services Core
Facility<http://www.ohsu.edu/xd/research/research-cores/dna-analysis/>
503-494-2442
kellert at ohsu.edu<http://ohsu.edu>
Office: 6588 RJH (CROET/BasicScience)
OHSU Shared Resources<http://www.ohsu.edu/xd/research/research-cores/index.cfm>
<<inline: Screen Shot 2011-09-09 at 4.57.30 PM.png>>
_______________________________________________ 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/
