Posted to tcl by colin at Tue Apr 27 00:22:02 GMT 2010view raw

  1. "pages_gt_date_with_content" { set sql {SELECT *
  2. FROM pages a, pages_content b
  3. WHERE a.id = b.id
  4. AND a.date > :date
  5. AND length(b.content) > 1
  6. ORDER BY a.date DESC} }