SQL query IFNULL

[Ruslan Zasukhin]

on 10/29/03 14:31, Martin Kloss at martin.kloss at gmx.de wrote:

> Hi Ruslan,
> 
> the following query produces an error, but the docs suggest
> that this should work:
> 
> SELECT RecID, type, IF(comment IS NULL, 'n', 'j') FROM data, data_types
> ORDER BY type ASC

Martin,

You can use functions only in BaseObject methods.
 
You need create BaseObject method and use it in SELECT.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------