On Thu, Jan 5, 2012 at 1:08 PM, Jeff Sadowski <[email protected]> wrote: > 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. Found it Edit->"Run SQL command directly" did the trick. It would be nice if the design view worked a bit better but I can live without it. > >> 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
