How can I execute this SQL directly? (and use it)

SELECT
  *
FROM
  projects,
  users_has_projects
WHERE
  users_has_projects.projects_id = projects.id AND
  users_has_projects.users_id = 1
ORDER BY
  projects.type_projects_id ASC,
  projects.nam ASC;


Users and Projetcs has a ManyToMany relationship.

ptr<User> user = session_.find<User>().where("id =
?").bind(app_->userID); tt.commit(); // OK
collection< ptr<Project> > collect = user->projects;  // Segmentation fault

How can I read all projects of a user?  (Both are related N-M)

I searched in the Wt::Dbo Tutorial, examples (like blog) and I could not
understand/find the solution to this problem.

Could someone post an example of how, or rather perhaps an insert in
Wt::Dbo Tutorial example of this kind?

Tks,
John


------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger.
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Discover what all the cheering's about.
Get your free trial download today. 
http://p.sf.net/sfu/quest-dev2dev2 
_______________________________________________
witty-interest mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/witty-interest

Reply via email to