rowset<std::string> rs = (sql.prepare << "select firstname from person");
std::copy(rs.begin(), rs.end(),
std::ostream_iterator<std::string>(std::cout, "\n"));

change to rowset<row> and make row streamable.

Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net