Re: auto_increment

[Chris Frey]

On Mon, Mar 14, 2005 at 08:35:27PM +0100, Joachim Person wrote:
> and subscription also has a "id" field which is auto_increment, doesn't
> work. The id field gets some seemingly random value. How can I make sure
> auto_increment works?

auto_increment happens at the database level.  I don't believe mysql++
automatically updates the struct with the new id, you need to get it yourself
with the insert_id() call.

	query.store();
	int id = connection.insert_id();// do this right after the
					// insert operation

- Chris