---

testharness.cpp

#include "openDB.hpp"
#include "../openTools/cgiExtend.h"

int main( int argc, char * argv[])
{
  cout << "Creating a db" << endl;

  openDbFactory DbMaker(MySQL, "host=localhost;uid=http_user;pwd=mydeal99;db=dealmania");
  openDB & db = DbMaker.db();

  cout << "db established : provider is: " << db.getProvider() << endl;

  if( db.isGood() )
  {
    cout << "Good Connection -- Creating an rs" << endl;
    openRsFactory RsMaker(db);
    openRS & rs = RsMaker.rs();

    cout << "rs established - making a query" << endl << endl;

    if( rs.open("select * from beFree_x1") )
    {
      cout << "Query made!" << endl;
      int i;
      for( i=0; i<rs.getFieldCount();i++)
      {
        cout << rs.getField(i).getName() << "\t\t";
      }
      cout << endl << "====================================================" << endl;
      do{

          for( i=0; i<rs.getFieldCount();i++)
          {
            string name =  rs.getField(i).getName();
            // intentional bad name test result is a seg fault =====> name += " ";
            cout << rs.getField(name.c_str()).format() << "\t\t";

          }
          cout << rs.getErrors() << endl;
          cout << endl << "------------------------------------------------------" << endl;

      }while( rs.isOpen() && rs.next() );
    }
    rs.close();
  }
  else
  {
    cout << "connection ain't no good" << endl;
    // cout << dynamic_cast<mySqlDB&>(db).errorString() << endl;
  }

}

---