So I've got a page that is generated mostly from the results of a single
db_select query. The first time I load the page, it all works fine.
Then, I hit reload, and db_select does not return a sth, but instead
returns an undefined value.
Is this a problem with how I've set up MySQL? Or am is there something
wrong with my query statement?:
my ($rv, $sth) = $S->db_select({
WHAT => qq~foreignk, anotherk, DATE_FORMAT(date_made, "%e %b %Y
%T") AS date, field, ornate_field, prkey, quack~,
FROM => 'supertable',
WHERE => "prkey = 5",
ORDER_BY => 'date_made DESC',
NOCACHE => 1
});