[Libpqxx-general] how to create dynamic queries?

[Caleb Cushing]

            tran.exec("INSERT INTO korama.tracks ( file_path, title ) VALUES ('"
                + tran.esc(iter->path())
                + "','"
                + tran.esc(iter->path())
                + "');"
            );
trying to insert the path() (using boost::filesystem) into the
database but I can't get it to compile. I've tried various variations
of concatenating the strings in exec... none work, and each withe
different errors. any help would be appreciated.

-- 
Caleb Cushing

http://xenoterracide.blogspot.com