Hi all. I have been trying to find an answer to this little problem but have failed so far.
In my sqlite app, in some queries I get a result 'undefined' (which is a correct return since no correct entry is found). I would like to convert any result returned as 'undefined' to a value 0, but i cant seem to get hold of the value "undefined" to convert.
basically, i would like a value 0 showing in any position where 'undefined' appears in my app.
any help appreciated