List:General Discussion« Previous MessageNext Message »
From:Jay Blanchard Date:June 8 2006 12:05pm
Subject:RE: functions in AS
View as plain text  
[snip]
SET @sql=CONCAT('SELECT SUM(IF(SUBSTRING(updated,1,10)=CURDATE(), 1, 0)) AS ',
               
char(39),
               
CURDATE(),
               
CHAR(39),
               
' FROM tablename GROUP BY group by psDealer' );
PREPARE stmt FROM @sql;
[/snip]

Very clever Peter! Thanks for your help on this.
Thread
functions in ASJay Blanchard7 Jun
  • Re: functions in ASPeter Brawley7 Jun
RE: functions in ASJay Blanchard7 Jun
  • Re: functions in ASPeter Brawley8 Jun
RE: functions in ASJay Blanchard8 Jun