Hi folks,

I'm a humble non-programmer who just wants to read a float table value into
a float variable.
----------------------------------------------------------------------------
-------------
Query query = con.query();
query << "select kwh from basic120 order by time desc limit"; // Last value
this column.
mysqlpp::ResUse res = query.use();
???
float kwh = ???
----------------------------------------------------------------------------
-------------
I've tried using the method Fields but can't get it to compile.

Thanks,

Benjamin Liu



--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

On Wed, Jul 20, 2005 at 04:10:46PM -0700, Benjamin Liu wrote:
Check out the usequery.cpp example, or some of the other files in the
examples/ subdirectory.

Here's a snippet:

// Execute the query, but don't save results in memory
mysqlpp::ResUse res = query.use();
if (!res) {
std::cerr << "Result set is empty!" << std::endl;
return 1;
}

// Iterate through result set, printing each row.
mysqlpp::Row r;
while (r = res.fetch_row()) {
print_stock_row(r);
}

i.e. you need to use a Row object, and fetch each row, then access the
data from that row.

More docs are here: http://tangentsoft.net/mysql++/doc/

- Chris


--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw