Project

General

Profile

How to select all fields in a table? using wt::dbo::query.

Added by Rathnadhar K V almost 4 years ago

Namasthe,

My table has 21 columns (+2 added by Wt::Dbo).

I want all these columns as collection based on a complex and dynamic criteria.

I built the sql as thus:

std::string sql_query = "select * from open.tbl";

to this i append where conditions dynamically.

Finally execute the query as thus:

auto nse_company_information_records = bootstrap_handle~~get_database_session()~~>query(sql_query).

resultList(); //open_table_records is of type wt::dbo::collection ....

when I execute this, I get an exception.

please let me know how I can select all fields in the table row (based on a dynamic query) in wt::dbo.

Regards

Rathnadhar K V


    (1-1/1)