Well using the fetch function right after execute is not working either
dbs::Server* server = new dbs::Server();
soci::statement st =
(sql.prepare << "SELECT linkname, name, engine, listening_ip,
listening_port, auth_id, auth_pw, max_clients, parent_linkname, childs, id
FROM `" << Server::table_name << "` WHERE `linkname`=':ii'",
soci::use(linkname, "ii"),
soci::into(server->linkname),
soci::into(server->name),
soci::into(server->engine_type),
soci::into(server->listening_ip),
soci::into(server->listening_port),
soci::into(server->auth_id),
soci::into(server->auth_pw),
soci::into(server->max_clients),
soci::into(server->parent_linkname),
soci::into(server->childs),
soci::into(server->id));
*st.execute();
st.fetch();
if(!st.got_data())
{
std::cout << "SQL = SELECT linkname, name, engine, listening_ip,
listening_port, auth_id, auth_pw, max_clients, parent_linkname, childs, id
FROM `" << Server::table_name << "` WHERE `linkname`='" << linkname << "'"
<< std::endl;
delete server;
throw Server::does_not_exist();*
}
else
{
Server::gets().insert({server->linkname, server});
server->init_load();
return *server;
}
2013/6/26 Mateusz Loskot <[email protected]>
> On 26 June 2013 15:02, Nicolas Deroche <[email protected]> wrote:
> > The query should return only one row, is t really necessary ?
> >
>
> Please, check the docs. It's all there what calls are necessary.
>
> Best regards,
> --
> Mateusz Loskot, http://mateusz.loskot.net
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Windows:
>
> Build for Windows Store.
>
> http://p.sf.net/sfu/windows-dev2dev
> _______________________________________________
> soci-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/soci-users
>
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
