Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Wednesday, November 11, 2026
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  Dropdownlist from join with default empty

phpMyEdit General     Dropdownlist from join with default empty
Post new topic   Reply to topic    
 
bentuinstra     Joined: 12 Sep 2004   Posts: 29  
Post 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  
Post 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  
Post 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    

Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS
Go to Top · Feedback form · Application form
Report bug on PLATON.SK website · Terms of use · Privacy policy