LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sozdemir

Hi all,

I am trying to incorporate an if statement with output, the below is what I have tried so far:

var1 = sqlSelect('sql_statement') #this returns only one field and one value

output "output1" {
if len(var1) > 0
then
"some_message"
else
"some_other_message"
}

With the above if statement, I keep getting "Unexpected token (if) at line..." error.

Any advice is appreciated.

Thanks

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

The text you have "some_message" is not assigned to a column name..

var1 = sqlSelect('sql_statement') #this returns only one field and one value

msg = if len(var1) > 0 then "some_message" else "some_other_message"

output "output1" {
emit msg as Message
}