Hi all,
This should be painfully obvious, but I don't see it :)
For a personal project, I want users to be able to click on a letter and get a
list of countries starting with that letter. I can do this:
my $letters = $c->model('DB')->storage->dbh->selectcol_arrayref(
'select distinct(substr(name,1,1)) as letter from country order by
letter'
);
$c->stash->{letters} = $letters;
But the country list is static and I want this available at startup. 'sub
begin' fails because that's called once per request, not once per app.
What's the recommend way of handling this? (I'm using DBIx::Class for the
model)
Cheers,
Ovid
--
Buy the book - http://www.oreilly.com/catalog/perlhks/
Tech blog - http://use.perl.org/~Ovid/journal/
Twitter - http://twitter.com/OvidPerl
Official Perl 6 Wiki - http://www.perlfoundation.org/perl6
_______________________________________________
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/
