I did soci::use(map_id), but i'm not saving this field, just setting a
clause on it.
But I never checked if this could be the error, I'll do that when i'm back
from work.
I just hope it's something else, it'd really be a shame if it was that..
thanks
2013/3/7 Wacha Gábor <[email protected]>
> 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
> [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
>
>
------------------------------------------------------------------------------
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
