Hello,
I am new in using soci, but haven't you forgotten soic::into(map_id)?
You've selected map_id, but there is nothing to put that into.
Gabor
2013-03-07 09:14 keltezéssel, Nicolas Deroche írta:
Hello !
I'm fetching a list using statements, here's the code:
/ game::portal_id_t p_id, p_t2, ptype = 0;//
// game::map_id_t p_t, px, py, pfx, pfy;//
//
// soci::statement subst2 =//
// (sql.prepare << "SELECT "//
// << "`id`, `map_id`,`x`, `y`, `type`, `target`,
`target2`, `forcex`, `forcey` "//
// << "FROM `pack_maps_portals` "//
// << "WHERE `map_id`=:map_id "//
// << "ORDER BY `id` ASC",//
// soci::into(p_id),//
// soci::into(px),//
// soci::into(py),//
// soci::into(ptype),//
// soci::into(p_t),//
// soci::into(p_t2),//
// soci::into(pfx),//
// soci::into(pfy),//
// soci::use(map_id));//
//
// subst2.execute();//
// while(subst2.fetch())//
// {//
// std::cout << "PORTAL: mapid " << map_id << "
portal_id:" << p_id << ", type: " << ptype << "- x:" << px << "- y;"
<< py//
// << "; map=" << p_t << " portal=" << p_t2 << std::endl;//
// map_ps.insert({p_id,//
// new
game::Portal(px,py,p_id,0,ptype,p_t,p_t2,pfx,pfy)});//
// }/
The thing is that, the value of "ptype" is into "px" and "px" into
"ptype".
Same for p_t and p_t2, they are swapped aswell.
And it certainly disturbs me to swap the soci::into(...) lines because
it does not match the correct field order in the SQL statement ...
How can I fix that?
Thanks, nico
------------------------------------------------------------------------------
Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester
Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the
endpoint security space. For insight on selecting the right partner to
tackle endpoint security challenges, access the full report.
http://p.sf.net/sfu/symantec-dev2dev
_______________________________________________
soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
--
Üdvözlettel,
Wacha Gábor
------------------------------------------------------------------------------
Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester
Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the
endpoint security space. For insight on selecting the right partner to
tackle endpoint security challenges, access the full report.
http://p.sf.net/sfu/symantec-dev2dev
_______________________________________________
soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
