On 2011-07 -08, at 09:43, Koen Deforche wrote: > Hey Boris, > > 2011/7/7 Nagaev Boris <[email protected]>: >> With expanding expression like "select B from blog B" to "select B.id, >> B.version, B.name, ... from Block B". Wt should replace table aliases >> (like B) with lists of all fields of this table (like B.id, B.version, >> B.name,...). This is useful while constructing complex queries with >> SQL joins (I used them for QueryModel). >> I do not remember what was the reason of errors, maybe it was >> connected with adding of quotation marks near names of fields. >> WtDboMysql seems not to be developed, therefore can be not compatible >> with newer versions of Wt::Dbo > > Last time I checked, it was still working just fine! We are careful > not to break the SqlConnection interface (and there is also little > reason to do so). > > The issue you had with the quotation marks is apparently a matter of > configuring MySQL to be standards compliant with that respect -- it > was discussed a few times on the mailing list. > > Regards, > koen >
Indeed MySQL must be configured to be in ANSI mode for the correct handling of quotation marks - see http://wtdbomysql.sourceforge.net/classWt_1_1Dbo_1_1backend_1_1MySQL.html for more information. Paul. ------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 _______________________________________________ witty-interest mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/witty-interest
