Do you have any error messages in your apache error log? If you load the page a third time, or a fourth, does it continue to cause an error or does it sometimes randomly work a few page loads later? Have you tried completely stopping then starting apache? (I've found that errors that show up on one request but not on another are sometimes caused by the cache getting out of sync between apache threads, and stop/starting apache resets that.) Nothing in the query immediately jumps out at me as being wrong, apart from the nonsense words substituted for your table and field names :-) -janra On 26-Sep-06, at 6:59 PM, johnzenger at mailc.net wrote: > 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 > }); > > _______________________________________________ > Scoop-help mailing list > Scoop-help at lists.kuro5hin.org > http://lists.kuro5hin.org/mailman/listinfo/scoop-help