{"action":"created","issue":{"url":"https://api.github.com/repos/rbock/sqlpp11/issues/56","labels_url":"https://api.github.com/repos/rbock/sqlpp11/issues/56/labels{/name}","comments_url":"https://api.github.com/repos/rbock/sqlpp11/issues/56/comments","events_url":"https://api.github.com/repos/rbock/sqlpp11/issues/56/events","html_url":"https://github.com/rbock/sqlpp11/issues/56","id":121679688,"number":56,"title":"Dynamic statements.","user":{"login":"slepasteur","id":5400486,"avatar_url":"https://avatars.githubusercontent.com/u/5400486?v=3","gravatar_id":"","url":"https://api.github.com/users/slepasteur","html_url":"https://github.com/slepasteur","followers_url":"https://api.github.com/users/slepasteur/followers","following_url":"https://api.github.com/users/slepasteur/following{/other_user}","gists_url":"https://api.github.com/users/slepasteur/gists{/gist_id}","starred_url":"https://api.github.com/users/slepasteur/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/slepasteur/subscriptions","organizations_url":"https://api.github.com/users/slepasteur/orgs","repos_url":"https://api.github.com/users/slepasteur/repos","events_url":"https://api.github.com/users/slepasteur/events{/privacy}","received_events_url":"https://api.github.com/users/slepasteur/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-12-11T10:19:45Z","updated_at":"2015-12-11T10:50:54Z","closed_at":null,"body":"Hi,\r\n\r\nI'm trying to use the dynamic select statements like dynamic_where and dynamic_limit like that:\r\n\r\n    auto s = dynamic_select(m_db, all_of(entry)).from(entry).dynamic_where();\r\n    s.add_where(true);\r\n\r\nbut I got the following compilation error:\r\n\r\n    error: ‘struct sqlpp::statement_t<sqlpp::sqlite3::connection, sqlpp::no_with_t, sqlpp::select_t, sqlpp::no_select_flag_list_t, sqlpp::select_column_list_t<...>, sqlpp::from_t<void, sdn_sql::Entry>, sqlpp::no_extra_tables_t, sqlpp::where_t<sqlpp::sqlite3::connection>, sqlpp::no_group_by_t, sqlpp::no_having_t, sqlpp::no_order_by_t, sqlpp::no_limit_t, sqlpp::no_offset_t, sqlpp::no_union_t>’ \r\n    has no member named ‘add_where’\r\n\r\nMy code seems similar to the one on the wiki. I search the code and it does not seem to have the add_where method. Did you change the usage of dynamic select statements?\r\n\r\nBest regards,\r\nSimon"},"comment":{"url":"https://api.github.com/repos/rbock/sqlpp11/issues/comments/163907517","html_url":"https://github.com/rbock/sqlpp11/issues/56#issuecomment-163907517","issue_url":"https://api.github.com/repos/rbock/sqlpp11/issues/56","id":163907517,"user":{"login":"slepasteur","id":5400486,"avatar_url":"https://avatars.githubusercontent.com/u/5400486?v=3","gravatar_id":"","url":"https://api.github.com/users/slepasteur","html_url":"https://github.com/slepasteur","followers_url":"https://api.github.com/users/slepasteur/followers","following_url":"https://api.github.com/users/slepasteur/following{/other_user}","gists_url":"https://api.github.com/users/slepasteur/gists{/gist_id}","starred_url":"https://api.github.com/users/slepasteur/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/slepasteur/subscriptions","organizations_url":"https://api.github.com/users/slepasteur/orgs","repos_url":"https://api.github.com/users/slepasteur/repos","events_url":"https://api.github.com/users/slepasteur/events{/privacy}","received_events_url":"https://api.github.com/users/slepasteur/received_events","type":"User","site_admin":false},"created_at":"2015-12-11T10:50:54Z","updated_at":"2015-12-11T10:50:54Z","body":"Hum it compiles with the dynamic_order_by, I suppose it is not possible to use static order_by on a dynamic_select?"}}