List:MySQL++« Previous MessageNext Message »
From:Steve Orton Date:June 21 2006 2:54pm
Subject:RE: Large class to table
View as plain text  
  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.


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

-----Original Message-----
From: Jim Langston [mailto:serpardum@stripped]
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

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

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

Large class to tableJim Langston21 Jun
  • RE: Large class to tableSteve Orton21 Jun
  • Re: Large class to tableWarren Young21 Jun
    • Re: Large class to tableWarren Young21 Jun
      • Re: Large class to tableJim Langston28 Jun
        • Re: Large class to tableWarren Young29 Jun