On Thu, Jan 5, 2012 at 11:59 AM, Alexander Thurgood <[email protected]> wrote: > Le 05/01/12 19:26, Jeff Sadowski a écrit : > > Hi Jeff, > >> Thank you for mentioning datediff >> "SELECT * FROM `modifiedprintusage` where >> DATEDIFF(CURRENT_DATE,`date`)<3 ORDER BY `ip` DESC;" >> works great from the commandline mysql but libreoffice is rejecting it. >> > > It should work with the SQL parser turned off, but this means that you > can't use the graphical query designer, you can only work in SQL mode. > How do you turn it off? I don't see the option.
> Alex > > > -- > For unsubscribe instructions e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
