Hi!
I'm trying to execute a query, within another queries loop.
And it isn't working well. The program dies when I execute use()...
Like this:
Connection con("db", "Host", "User", "Passwd");
Query query = con.query();
ResUse res = query.use("SELECT id,value FROM table");
while (Row row = res.fetch_row()) {
string stuff;
string id = (row.at(0)).c_str();
string value = (row.at(1)).c_str();
Query query_0 = con.query();
ResUse res_0 = query_0.use("SELECT value2 FROM table2 WHERE id=" + id);
Row row_0 = res_0.fetch_row();
string value2 = (row_0.at(0)).c_str();
if (value2.length() > 0)
stuff = value2;
else
stuff = value;
/* ... */
}
It dies at "query_0.use(..." with this output from gdb:
#0 0x401e7467 in std::basic_string<char, std::char_traits<char>,
std::allocator<char> >::~basic_string ()
from /usr/lib/libstdc++.so.5
#1 0x08052bd3 in ~basic_stringbuf (this=0xbffff5d0) at query.h:195
#2 0x08058aeb in ~Query (this=0xbffff580) at main.cpp:45
#3 0x0805837d in main (argc=1, argv=0xbffffd54) at main.cpp:76
Can anybody solve this?
//Mattias
