[EMAIL PROTECTED] wrote: > Message: 1 > Date: Thu, 1 May 2008 16:44:43 -0400 > From: "Paul Yasi" <[EMAIL PROTECTED]> > Subject: Re: [Citrusdb-users] Billing Module Query Failure > To: "For users of CitrusDB discussion" > <citrusdb-users@lists.sourceforge.net> > Message-ID: > <[EMAIL PROTECTED]> > Content-Type: text/plain; charset=ISO-8859-1 > > I think this may have to do with the sql_mode setting, it's may > default to something different when running under windows vs. linux. > In linux it's empty by default, and in windows it's strict. > > Can you check that in the my.ini file, or by running the query: SELECT > @@global.sql_mode, @@session.sql_mode, @@sql_mode; > > I thought this worked in strict, but I guess not. I'll have to change > my sql_mode and find out. > > Paul > All 3 of those settings are the same as follows:
'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' Rich C. ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
