nope. that doesnt work either. i got no problem outputing other recoard. but got problem with strftime('%s', 'now')
--- Jeff Thompson <[EMAIL PROTECTED]> wrote: > On Tue, 1 Feb 2005 06:51:49 -0800 (PST), teoh > <[EMAIL PROTECTED]> wrote: > > > > sqlite3::reader reader=con.executereader("select * > > from each_transaction;"); > > while(reader.read()) > > {cout << reader.getcolname(0) << ": " << > > reader.getstring(0) << endl; } > > > > I get output like this: > > > > datetime: á " <----- invalid > > > > This is a guess since I'm not familiar with > sql3_plus, but it looks > like you may be printing the pointer to the > character string instead > of the string itself... If reader.getstring(0) > returns a std::string, > try the following: > > cout << reader.getcolname(0) << ": " << > reader.getstring(0).c_str() << endl; > > -- > Jeff Thompson > [EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo