[SOLVED] onCPayAfterPaymentStatusUpdateEvent and var3

krileon wrote: Can you provide an example of your exact usage that caused it to fail?

See screenshot of syntax error message here:



Note the underlined field name, which in the query code was correctly but got scrambled by Auto Action (so to speak) to Also note the single closing quote instead of `. Trust me I've been through a lot of variations of this, all of which - with the exception of this screenshot - I deleted after I figured that CASE WHEN THEN ELSE END works instead.

It's failing at the IF syntax. The column name being cut off is just because it only shows a specific length of characters for an SQL error. If you look after the error through it shows you the fully query where the column name is fine. See the below MYSQL documentation regarding the IF syntax as it does not appear valid or at least that usage isn't familiar to me.

dev.mysql.com/doc/refman/5.6/en/control-flow-functions.html#function_if

Regardless CASE is the proper usage for your needs. I was unable to confirm your issue.

Thanks as always, Kyle.

Two different IF functions exist for MySQL. See here: dev.mysql.com/doc/refman/5.5/en/if.html - the blue "Note" box early on underlines the fact. Or google "mysql if then" and get a lot more on this other function.

However, I am familiar with the one you're referring to, had also tried it (did work in a very simple format), but when there were nested conditions, other than it getting hard to read it then failed in the same fashion... and I had paid really careful attention to getting the syntax right.

Anyway, we agree it works perfectly fine with CASE, no problem, and that's what matters.

Thanks and cheers!