| Index
» Projects
» phpMyEdit
» Forum
» Dropdownlist from join with default empty |
 |
bentuinstra
Joined: 12 Sep 2004
Posts: 29
Posted: 2005-01-26 11:47
Back to top
Reply with quote
|
Hi all,
Is it possible to have a dropdownlist which reads from an other table with an empty default.
I tried
$opts['fdd']['PRECEDER']['default'] = '';
But this doensn't seem to do the trick,
Help appriciated!
Ben
| Code: |
$opts['fdd']['PRECEDER']['values']['table'] = 'trackit';
$opts['fdd']['PRECEDER']['values']['column'] = 'WO_NUM';
$opts['fdd']['PRECEDER']['values']['description']['columns'][0] = 'WO_NUM';
$opts['fdd']['PRECEDER']['values']['description']['divs'][0] = ' , ';
$opts['fdd']['PRECEDER']['values']['description']['columns'][1] = 'TASK';
$opts['fdd']['PRECEDER']['values']['description']['divs'][1] = ' , ';
$opts['fdd']['PRECEDER']['values']['description']['columns'][2] = 'REQUEST';
$opts['fdd']['PRECEDER']['name'] = 'PRECEDING WO';
$opts['fdd']['PRECEDER']['select'] = 'M';
$opts['fdd']['PRECEDER']['default'] = '';
$opts['fdd']['PRECEDER']['sort'] = 'false';
$opts['fdd']['PRECEDER']['options'] = 'ADC';
$opts['fdd']['PRECEDER']['trimlength'] = '10';
$opts['fdd']['PRECEDER']['values']['filters']='STATUS <> "COMPLETED"';
|
|
cbonde
Joined: 27 Jan 2005
Posts: 2
Posted: 2005-01-27 00:52
Back to top
Reply with quote
|
Use this line instead:
$opts['fdd']['PRECEDER']['values2'] = 'whatever';
Regards
| bentuinstra wrote: |
Hi all,
Is it possible to have a dropdownlist which reads from an other table with an empty default.
I tried
$opts['fdd']['PRECEDER']['default'] = '';
But this doensn't seem to do the trick,
Help appriciated!
Ben
| Code: |
$opts['fdd']['PRECEDER']['values']['table'] = 'trackit';
$opts['fdd']['PRECEDER']['values']['column'] = 'WO_NUM';
$opts['fdd']['PRECEDER']['values']['description']['columns'][0] = 'WO_NUM';
$opts['fdd']['PRECEDER']['values']['description']['divs'][0] = ' , ';
$opts['fdd']['PRECEDER']['values']['description']['columns'][1] = 'TASK';
$opts['fdd']['PRECEDER']['values']['description']['divs'][1] = ' , ';
$opts['fdd']['PRECEDER']['values']['description']['columns'][2] = 'REQUEST';
$opts['fdd']['PRECEDER']['name'] = 'PRECEDING WO';
$opts['fdd']['PRECEDER']['select'] = 'M';
$opts['fdd']['PRECEDER']['default'] = '';
$opts['fdd']['PRECEDER']['sort'] = 'false';
$opts['fdd']['PRECEDER']['options'] = 'ADC';
$opts['fdd']['PRECEDER']['trimlength'] = '10';
$opts['fdd']['PRECEDER']['values']['filters']='STATUS <> "COMPLETED"';
|
|
|
bentuinstra
Joined: 12 Sep 2004
Posts: 29
Posted: 2005-01-28 14:21
Back to top
Reply with quote
|
Hi cbonde
I've tested it and it worked very well.
Thanks again for your support,
Kind regards, Ben
|
|
Post new topic
Reply to topic
|
|
|
|