Hello everyone,
I would like to make a SQL query to assign an image, according to my character level. In my app, I have a number variable “Character level” and I would like to compare this value in my SQL query.
The SQL is like that :
SELECT *, “image1.png” color FROM data WHERE “Required level” <= ‘"+document.childByName(“Character level”).content.doubleNumber+"’
UNION
SELECT *, “image2.png” color FROM data WHERE “Required level” > ‘"+document.childByName(“Character level”).content.doubleNumber+"’
But it does not work. Where is the error ?
Hope I explained correctly.
Thanks by advance.