neosoul
Založený: 12.02.2009
Príspevky: 1
Zaslal: 2009-02-12 17:50
Návrat hore
Odpovedať s citátom
|
Hi,
Thanks to a lot of folks here for their knowledge and the developers for this great product. I was able to get through most of the problems just by reading the documents and browsing this support forum.
Unfortunately I have a cosmetic output issue and was hoping someone here could help.
I used a concat statement(?) to join multiple columns:
'sql|LFV'=>"concat('column_name1,'-',column_name2,'-',column_name3,'\n')"
The issue is that I have about 15 allowable edit points per record and when displayed, if I only have say 4 filled in, it would still display the '-' and new line like this:
record one - foo1-bar1
' foo2-bar2
' foo3-bar3
' foo4-bar4
' -
' -
' -
' -
' -
etc.
Is there a way to stop displaying the newline along with the - if there are no more records to display?
|
doug
Založený: 10.02.2003
Príspevky: 1013
Bydlisko: Denver, Colorado (USA)
Zaslal: 2009-02-14 16:58
Návrat hore
Odpovedať s citátom
|
The following is untested, but will probably cause the concatenated display to occur only if column_name contains a value.
| Kód: |
| 'sql|LFV' => "if(column_name > '', concat('column_name1,'-',column_name2,'-',column_name3,'\n'), '' )" |
|
|
Odoslať novú tému
Odpovedať na tému
|
|
|
Prihlásiť
Registrácia
English
