Assigning multipls DB table columns to multiple CB fields

Hello,

In "CB Query Tutorials - 04 - articles list table" Nant explains how to DISPLAY multiple rows and columns. I wonder if this is possible for STORING multiple coulumns in a related number of CB fields.

How can I retrieve 1+ columns from DB table and assign them to 1+ CB fields?

This simply doesn't work as target is just one CB field (query multiple or single):

"SELECT cb_industry_key, cb_industry_display_name FROM #_industry_table WHERE lang_tag='en-US';" does not work to assign 2 separate values to 2 CB fields.

Do I have to use
"SELECT CONCAT(cb_industry_key,'|',cb_industry_display_name) FROM #_industry_table WHERE lang_tag='en-US';" instead, parsing and splitting apart values into separate CB fields using CB Auto Action afterwards?

Use case is quite simple: Get the index key of a displayed DB table cell user has choosen.
However for my CB app this is essential and required for many CB query fields.

Thank you.

CB Query Field outputs the results of your query as the field you created (the query field). To output multiple columns you need to use the appropriate Output mode under the Display tab as shown in the below tutorial.



If you need both values, but as separate fields then you need to create 2 query fields.