MySQL - user variables

2002-02-13 Thread Luc Foisy
Perhaps I should have split this up into two mails, but I saw them related in the difference of databases On mysql Ver 11.12 Distrib 3.23.32, for pc-linux-gnu (i686) this works SELECT SQL_BUFFER_RESULT DATE_FORMAT(ORDERHEADER.AvailableAt,'%y/%m/%d') AS 'Date', (@tl:=SUM(IF(DISPATCHLOG.ID_STATU

MySQL - user variables

2002-02-07 Thread Luc Foisy
Perhaps I should have split this up into two mails, but I saw them related in the difference of databases On mysql Ver 11.12 Distrib 3.23.32, for pc-linux-gnu (i686) this works SELECT SQL_BUFFER_RESULT DATE_FORMAT(ORDERHEADER.AvailableAt,'%y/%m/%d') AS 'Date', (@tl:=SUM(IF(DISPATCHLOG.ID_STATU