Ok, that seems to work, thanks. Another question:
How do you create two sql_create macros with the same name? (doesn't
If I change the name of the sql_create_N(name,...) to something else
it won't let me insert it into the database because it has a
different table name that doesn't match.
On Aug 11, 2007, at 8:29 PM, Jim Wallace wrote:
> I use auto_increment often. The trick is to not include that
> column in
> the sql_create_* macro. This may mean you have > 1 macro for the same
> table, one for insert w/o that column, and one for retrieval with that
> column. I often have > 1 macro for the same table depending on how
> using it.
> -----Original Message-----
> From: Graham Reitz [mailto:grahamreitz@stripped]
> Sent: Saturday, August 11, 2007 2:27 AM
> To: plusplus@stripped
> Subject: Inserting with a column that uses auto_increment
> How do you prevent an insert as shown in the code below from putting
> "bogus" data in an auto_increment field?
> It seems like the billing_id field, in the code below, inserts a
> based on the un-initialized value of client_id, instead of letting the
> database auto_increment the value. What's a good method to deal with
> this, that allows the database to auto_increment a database field?
> /************ CODE ************/
> #include <mysql++.h>
> #include <custom.h>
> using namespace mysqlpp;
> sql_create_2(clients, 1, 2,
> unsigned int, client_id, // auto_incremented field
> unsigned int, billing_id)
> void populate_client_info(clients& client_info)
> client_info.billing_id = 1;
> int main (int argc, char* const argv)
> Connection connection("db_name","ip_address","user",
> "password",3306, false);
> Query client_query = connection.query();
> clients a_client;
> return 0;
> MySQL++ Mailing List
> For list archives: http://lists.mysql.com/plusplus
> To unsubscribe: http://lists.mysql.com/plusplus?