Ok.. I got it. This means I need to serialize the query string and the parameters myself. Thank you!
On Tue, Oct 4, 2011 at 2:30 PM, Maciej Sobczak <[email protected]> wrote: > Hello, > > On 03/10/2011 11:57, Li Lirong wrote: >> Thank you for your reply! Is there a way to retrieve the final query >> text so that I can save it for later use? This means I can stile use >> soci to do the data binding. Instead of executint the statement, I >> want to save the query as text. > > There is a basic logging support, described here: > > http://soci.sourceforge.net/doc/statements.html#logging > > But I think you try to do something strange. What do you mean by "I can > still use SOCI to do the data binding"? > Do you expect SOCI to insert your data values into the SQL string, so > that you can save it for later use? This is not how SOCI works and in > most cases such data insertion does not take place at all, not even > internally. Instead, SOCI sends the SQL text and data values separately, > which is safer (it protects against SQL injection attacks) and (at least > in theory) also faster. > > Best regards, > > -- > Maciej Sobczak * www.msobczak.com * www.inspirel.com > > ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure contains a > definitive record of customers, application performance, security > threats, fraudulent activity and more. Splunk takes this data and makes > sense of it. Business sense. IT sense. Common sense. > http://p.sf.net/sfu/splunk-d2dcopy1 > _______________________________________________ > Soci-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/soci-users > ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 _______________________________________________ Soci-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/soci-users
