2. PHPRunner General questions
  3. Db lookup multi select view
This topic is locked

Db lookup multi select view

 		10/29/2015 6:30:09 PM
PHPRunner General questions
L
 lcslouis author

The Original table data is a nvarchar(max)
has Record1,Record2,Record3
I am using the DB lookup multi select Checkbox list, I am using a custom expression to do a line break which works.
This is my expression

SubEventName + ' ' + MemberPrice1 + ' ' + NonMemberPrice1 + CHAR(13)+CHAR(10)


and the results are
Record1

,Record2

,Record3
How do I remove the comma?
Sergey Kornilov admin 11/3/2015

Here is the solution that worked. BeforeDisplay event of the View page, SubEventsIDNums is the field name:

$xt->assign('SubEventsIDNums_value',str_replace(",","
",$xt->getvar('SubEventsIDNums_value')));