RE: Large class to table

  There are << >> overloads for the 'Query' object.  You can do something like

Query query = con.query();
if (query) {
  query << "INSERT INTO " << <table> "(" << <Field1> "," << <Field2> << "," ... 
")" << "VALUES (" << <value1> << "," << <value2> << "," ... ");";
  ResNSel result = query.execute();
  if (result)
    long rows_affected = result.rows;
}

  Of course, it's all relative.  The above SQL string created with 40+ 
field-value pairs could also be hard to maintain.

 HTH...steve---


Steven J Orton
Software Engineer
Northrop Grumman Mission Systems
Middletown, RI 02842




-----Original Message-----
From: Jim Langston [mailto:serpardum@xxxxxxxxx]
Sent: Wed 6/21/2006 2:51 AM
To: MySql++
Subject: Large class to table
 
I have a few large classes which I wish to save to a MySQL table.  Currently
I am saving them to flat files using override>> and override<< with streams.

By large I mean 47+ variables/fields.

I'm trying to determine the best way to do this using MySQL++.  I've been
looking at SSQLS but think it would be a real pain to maintain.

I really didn't see an override for >> or << in the documentation, but I may
have just missed is.  Is there an override that will let me do something
like:

  con.something() << Field1 << field2 << field3 << field4;
  con.insert(); // or something

  con.something() >> Field1 >> field2 >> field3 >> field;
etc?


--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe:    
http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@xxxxxxxxxxx