[Libpqxx-general] how to create dynamic queries?

[Peter Geoghegan]

Hi,

2009/9/21 Lanre Sarumi <lsarumi at dwarfgoat.com>:
> just use std::stringstream. That way you don't have to worry about mixing
> data types.
>
> std::stringstream sql;
>
> sql<<"INSERT INTO korama.tracks ( file_path, title ) VALUES ('"
>   <<tran.esc(iter->path())
>   <<"','" <<tran.esc(iter->path())
>   <<"')";
>
> tran.exec(sql.str());
>

You can just do "trans.exec(sql);". exec is overloaded for stringstream,

Regards,
Peter Geoghegan