Greetings, Is there a way to output a prepared statement with the values already replaced? (as in just before being sent to the DB) Setting the logging to cxxtools::Logger::DEBUG prints the query but the parameters change to something like "$1", "$2"...
Anyway I think found a bug, or a lack of a feature, I'm trying to launch an "upsert" using a CTE (common table expression) against a postgres 9.4rc1 database. If I write the values on the string the query works but If I use substitution I keep getting errors, like this one: Postgresql-Error 42883: operator does not exist: integer = text at 209 in PQprepare Removing substitution step by step and using direct values moves the error to the next field that still uses substitution, until there is none left and it works. code: http://pastebin.com/xVxcqEHU (includes the sql for the table creation and the same query to use directly on a client like psql) I'm using the latest tntdb code pulled from github. Regards, Joan ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk _______________________________________________ Tntnet-general mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/tntnet-general
