concat in browse form

[hering]

Hello,

I have problem with CONCAT in browse.

Browse>Columns>Display:

Code: Select all

CONCAT(wyr_operacja_c,wyr_operacja_s,wyr_operacja_m)

In browse it works for some rows and for some it doesn't.

thx.

[kev1n]

Hi,

Have you tried running the query in phpMyAdmin to view the generated SQL and check if the output is as expected?
(see Form Info -> Browse SQL to view the generated SQL)

Please note that concatenating a string with NULL will always result in NULL.

Using IFNULL handles the case If any of these values are NULL, they are replaced with an empty string before concatenation.

Code: Select all

CONCAT(IFNULL(wyr_operacja_c,''),IFNULL(wyr_operacja_s,''),IFNULL(wyr_operacja_m,''))

[hering]

Thank You.
NULL was a problem