Hi Sören, Could you post the actual code that fails? I can't think off the top of my head of anything in SOCI that would cause the effect you observe, but I may be missing something and also it could depend on how exactly you create the statement. The only string escaping the MySQL backend does is regular sql escaping for use() parameters, but that shouldn't result in %s%N%s I think.
Thanks, Aleksander On Mon, Apr 27, 2009 at 8:44 AM, Sören Meyer-Eppler <[email protected]> wrote: > 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 > ------------------------------------------------------------------------------ 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
