Hi Philipp,
This is the code I use, maybe it will help:
try {
soci::indicator ind;
this->sql << "select `id` from `" << this->table_prefix << table << "` "
"where name = :name limit 1;", soci::into(id, ind),
soci::use(name);
if (not sql.got_data() || ind != soci::i_ok) {
// not found
}
}
catch (//exception handling
this->sql is a soci::session.
-S.
On 28 December 2012 12:43, Philipp Kraus <[email protected]> wrote:
> Hello,
>
> I'm using something like:
> soci::statement l_stm = (l_sess.prepare << "select id, name from table",
> soci::use(l_id), soci::use(l_name));
>
> The result of the select can be only one record, so I need only the
> information if a result record exists eg
> if (!l_stm.result_exists)
> throw exception("record not exists");
>
> How can I do this?
>
> Thanks
>
> Phil
>
>
> ------------------------------------------------------------------------------
> Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
> much more. Get web development skills now with LearnDevNow -
> 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122812
> _______________________________________________
> soci-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/soci-users
------------------------------------------------------------------------------
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812
_______________________________________________
soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
