hello

does anybody here use korma ?

I'm doing a select over multiple tables and I need the return of the korma.select to give me some predefined value if a field is nil

I don't want to parse text and str/replace

which is lame

thing is I have an :approved field with returns true or false or nil in case there's nothing to join on (i've been using nil as a pending value)

but it gets evaluated same as false in a framework that I'm using

and I want to have like a default field value that's pending if the select over a joined table has no entries

instead of korma.select's nil

This sounds like a simple post-processing fn; map an update over your results. You could also look to use the sql COALESCE fn to return something other than NULL in your query.

ok

i used sqlfn (ifnull ....)

coalesce sounds better i think