Hey,
I have some problems with SOCI's session operator << to execute a query.
I have manually constructed a huge (as in several MegaBytes) SQL insert
statement and would like to execute it verbatim against the mySQL native
backend. The query fails. However, if I catch the soci exception and log
the session.get_last_query() to a file I can execute that manually just
fine.
It seems SOCI does some string escaping magic before it executes the
statement.
The exception I get is:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near
''"\\r\\n%s%N%s' at line 1
If that actually was part of the query I'd agree that it's malformed
SQL. However, if I search the logged query for that string it cannot be
found. Thus I'm assuming SOCI is doing something behind the scenes it
doesn't tell me about... Correct?
cheers,
Sören
--
Sören Meyer-Eppler
software developer
[email protected]
http://www.BuschnicK.net
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensign option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
