Steve Hutton wrote:
The idea is that to select all rows, you fetch within a loop. The vector gets resized to contain the number of rows returned.
const int BATCH_SIZE = 30; std::vector<int> valsOut(BATCH_SIZE); Statement st = (sql.prepare << "select value from numbers", into(valsOut)); st.execute(); while (st.fetch()) { std::vector<int>::iterator pos; for(; pos != valsOut.end(); ++pos) { cout << *pos << '\n'; } }
How abouit something like: sql::statement query; query << "select value from numbers"; sql::rowset< int > rows(query); cout << "found = " << rows.size() << endl; std::vector< int > values; std::copy( rows.begin(), rows.end(), values ); Multi-item row searches could use tuple: sql::rowset< int, std::wstring, int > rows( query ); std::tr1::tuple< int, std::wstring, int > value = rows.begin(); - Reece _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/