RE: CASE statement and version 4.1.x

2005-03-09 Thread Paul DuBois
At 12:40 -0800 3/9/05, Homam S.A. wrote: Thanks Tom, Daniel, and Philippe for you replies. Yes, I got the statement working exactly as I wrote it. I was confused about this documentation: http://dev.mysql.com/doc/mysql/en/case-statement.html which states that you need to specify "END CASE" instead

RE: CASE statement and version 4.1.x

2005-03-09 Thread Homam S.A.
Thanks Tom, Daniel, and Philippe for you replies. Yes, I got the statement working exactly as I wrote it. I was confused about this documentation: http://dev.mysql.com/doc/mysql/en/case-statement.html which states that you need to specify "END CASE" instead of just "END". So I used the same synt

RE: CASE statement and version 4.1.x

2005-03-09 Thread Tom Crimmins
On Wednesday, March 09, 2005 07:49, Philippe Poelvoorde wrote: > Daniel Kasak wrote: >> Homam S.A. wrote: >> >>> In the documentation, it doesn't mention which version >>> of MySQL supports the CASE statement, but it refers to >>> stored procedures, so is it only supported for 5.x? >>> >>> I ca

Re: CASE statement and version 4.1.x

2005-03-09 Thread Philippe Poelvoorde
Daniel Kasak wrote: Homam S.A. wrote: In the documentation, it doesn't mention which version of MySQL supports the CASE statement, but it refers to stored procedures, so is it only supported for 5.x? I can't get any example of a CASE statement work in MySQL. For example, I can execute the follo

Re: CASE statement and version 4.1.x

2005-03-08 Thread Daniel Kasak
Homam S.A. wrote: In the documentation, it doesn't mention which version of MySQL supports the CASE statement, but it refers to stored procedures, so is it only supported for 5.x? I can't get any example of a CASE statement work in MySQL. For example, I can execute the following in MS SQL Serve