Link dropdown - db table

[DragonflyMaster]

Hi everybody,

I'd like to link a dropdown field to a db table, in order to make it show the values inside that table and not in a php file.
I'm not quite sure: how to create the logic for this control?
Any idea?


Sugar 5.0.0a CE - MSWindows2003Server - IIS 6 - PHP 5 - MSSQL 2005

[jli]

you cannot do this without custom coding; you can essentially make SQL calls to override and populate the key/value pairs of a pre-created drop down

[DragonflyMaster]

Thanks for replying.
I know it's a thing that requires custom coding, what I'm not sure about is where to place the custom code.
Not long ago I managed to link two dropdowns using javascript, but now I'd like to go further, making these dropdown show values from db tables.
In particular, opening dropdown A I'll see values in TABLE_A.Field1; after the choice, in dropdown B I'll have certain values, depending on the choice made in dropdown A.
The second part of the thing is done, I'm just unable to make it read a db table and show it in dropdowns.

[DragonflyMaster]

I haven't been able to solve this issue yet.
Is there anybody who could help me with it?
I have a custom db table where I stored data about cities and their zip codes.
What I'd like to create is a dropdown that shows a list of cities taken from my custom table; when I select a city form this dropdown I'd like to see in a second dropdown the list of zip codes for that city.

Any suggestion is very welcome, thanks.

[DragonflyMaster]

Ok,

after a week spent on this, we've finally managed to solve this issue.
Basically we built a dropdown and made sql query to estract data from a db table.
What we didn't know was the best place to put our code, now we've found out.

[caporales]

You could explain a little more as it has succeeded. Thanks !!! I'm need you help.

[DragonflyMaster]

Hi,
here's the to-do list:

1. create a dropdown in studio/module builder
2. write custom code to override dropdown definition
3. put custom code in the right php file

In my case, I

1. created a dropdown to show data from db in Account's editview.
2. wrote php code to run a simple sql query on a db table:

$myQuery = "select * from my_table";
$myResult=mssql_query($myQuery);
while ($myRow = mssql_fetch_array($myResult)) {
$myArray [] = $myRow['my_table_field'] ;
}
$GLOBALS['app_list_strings']['MyDropdown_list']= $myArray

3. put this custom code in <sugar-root>\custom\include\language\en_us.lang.php

[caporales]

Thanks !!!!!!

One more cuestion....

As for item and value, ??

$myQuery = "select PRO_CODIGO, PRO_DESCRIP from PROVINCIAS";
$myResult=mssql_query($myQuery);
while ($myRow = mssql_fetch_array($myResult)) {
$myArray [] = $myRow['PRO_CODIGO'] . ' =>' . $myRow['PRO_DESCRIP] ;
}
$GLOBALS['app_list_strings']['Provincias_list']=$myArray

[caporales]

YESS Succeed !!!

Very easy !!!!!

...
$myArray [$myRow['PRO_CODIGO']] = $myRow['PRO_DESCRIP'];


Thanks DragonflyMaster !!!!

[DragonflyMaster]

De nada!
I'm glad if I've helped you.