2. PHPRunner General questions
  3. Lookup wizard as checkbox list or as multiline
This topic is locked

Lookup wizard as checkbox list or as multiline

 		3/9/2012 6:34:13 AM
PHPRunner General questions
I
 imendes author

What's the differences between those two? I mean, how the data is stored? I tested the multiline. I was able to choose multiple lines with the ctrl key, and then I saved the record, but when I edited it only stored the first line I choosed previously. What's the point? I get the same as a checkbox. Sometimes, when I choose several values, it stores 0 in the table.
How to use this correctly?
Should I do something more?
For example, if I choose 3 values from the listbox, how can I add three records on the table, where all the fields values are the same except the listbox field?
Thank you.
C
 		cgphp 3/9/2012

Check this article: http://xlinesoft.com/phprunner/docs/select_multiple_values.htm
I
 		imendes author 3/9/2012



Check this article: http://xlinesoft.com/phprunner/docs/select_multiple_values.htm


Thank you for your response! It helps me a lot.
Just another question: it's possible to make reports (group by, etc) based on that field? I saw that if I choose several values they are stored like (value1,valu2,value3...) on the table field. Can I make a query base on that field? For example, I want to know the all the records that have the 'value2'.
Thanks again.
C
 		cgphp 3/9/2012

In the "Before SQL query" query, enter the following code:

$strWhereClause = whereAdd($strWhereClause,"your_field_name LIKE '%value2%'");