   [web] mysql++ Retrieving column data using column name
  I've got mysql++ working and can retrieve column data by using queries, but I cannot get it to work by using column names.BTW I am using mysql++ 1.7.27.For example:Query charInfo(m_pDBConnection);charInfo << "select race,level from player_characters where name = \"" << characters[index].c_str() << "\"";Result charInfoResult = charInfo.store();Row charInfoRow = *charInfoResult.begin();charInfoPkt.Level[index] = (int)charInfoRow[3];This works fine. In the documentation is says I should be able to replace the last line withcharInfoPkt.Level[index] = (int)charInfoRow["level"];This does not work.So I checked out the source for Row, and it has a function called lookup_by_name and takes a const char *.So I triedcharInfoPkt.Level[index] = (int)charInfoRow.lookup_by_name("level");But this does not work either, and the program crashes.Anyone know how I can achieve this?   
  You do realise you posted in the networking forum? Hope you're not spamming the forum!Where does it crash? Have you used the debugger? What is index? You're indexing an array using index, but is index valid?   ;  I think we've previously noted that there really isn't a better forum for remote database questions -- perhaps the webdev forum will have a number of db people on it, too, although they're likely to want to use Perl or PHP or something.I don't know the specifics of the MySQL C++ interface, though. Try reading the source :-)   ;  The Web Development forum was made in part as a place for SQL/database related queries (pardon the pun). You'll find a lot more people with knowledge about databases doing web development then you will among people writing fast UDP code for their FPS. (Moved to web dev)   ;  Thanks guys, I wasn't sure where the most appropriate place for this was, I figured networking would be best.The index I'm using is a string..."level", which is the column name of the row in the database I'm trying to retrieve data from. It works fine if I use the numerical index.Anyway...it crashes in the lookup_by_name on a null pointer, I'll try and find out exactly where when I get home.   