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.

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