Nested IF statement in 3.23.57

2004-03-25 Thread David Perron 
Are nested IF statements valid?  Doesn't say anything here:
http://www.mysql.com/doc/en/Control_flow_functions.html

Trying to get a conditional count using the following statement - but Im
receiving an error.  I would use a CASE statement but my version 
doesn't support it.

SUM(IF(AdGroups.Status = 'Paused',IF(AdGroupCriteria.Status,Active,1,0),0))

+-+
| version()   |
+-+
| 3.23.57-Max |
+-+

Re: Nested IF statement in 3.23.57

2004-03-25 Thread Paul DuBois 
At 18:44 -0500 3/25/04, David Perron wrote:
Are nested IF statements valid?  Doesn't say anything here:
http://www.mysql.com/doc/en/Control_flow_functions.html
Yes, you can nest them, but you must do so correctly. :-)

Your inner IF() below appears to have four arguments.

Trying to get a conditional count using the following statement - but Im
receiving an error.  I would use a CASE statement but my version
doesn't support it.
SUM(IF(AdGroups.Status = 'Paused',IF(AdGroupCriteria.Status,Active,1,0),0))

+-+
| version()   |
+-+
| 3.23.57-Max |
+-+


--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]