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
Hello !
* 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
_______________________________________________
--
Ü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
https://lists.sourceforge.net/lists/listinfo/soci-users