Wt

How to get ID of database object? Below you see my query to the table. Result of this query is uest as a model for combobox. but now, how do i get the ID of a single autor so i could do query for arr the albums that belong to the Author. its a many-to-one relation.

@

AuthorsModel* Database::getAuthors() {

dbo::Transaction trans(session_);

AuthorsModel *model = new AuthorsModel();

model->setQuery(session_.find());

model->addColumn("name");

trans.commit();

return model;

}

AlbumsModel* Database::getAlbums(int author_id) {

dbo::Transaction trans(session_);

AlbumsModel* model = new AlbumsModel();

model->setQuery(session_.find().where("author_id = ?").bind(author_id));

model->addColumn("name");

trans.commit();

return model;

@