Render_complex_sql 3rd parameter

Suite and Optimus Suite 5
#1

Hi all,
I’m trying to display a combo with 2 columns using render_complex_sql

The 3rd parameter of this function should take “a comma separated list of data fields”… however when I write “field1, field2” for the 3rd parameter I always see only field1 in the combo’s list!

Is it possible to see a PHP sample code to make a two-column combo?

Thank you very much,
Marco

#2

Hi all,
I finally found a way out and was able to display a 2 column combo…!

With these two lines of code and a template it worked:

$res=new PDO("mysql:dbname=dbTest;host=localhost","root","pwd");

$result = $res->query($sql);

The simpler ‘query’ command works better for this task!

Hope this can help someone…
Greetings,
Marco

#3

Please, try to remove the spaces between the field names.