Started: 9/20/2018 8:53 AM
Picture: Sergio Schinoff
Sergio Schinoff
Multiple external SQL records to be populated into a form

Hi, I was wondering how could I allows multiple external SQL records to be populated into a form. For instance, can I populate a check box list with multiple journal names from a SQL query?
Is there a way to accomplish this?

Picture: Sergio Schinoff
  • Sergio Schinoff
http://www.itlaq.com:80/my/User%2520Photos/Profile%2520Pictures/sergio_MThumb.jpg?t=63623640572" alt="Picture: Sergio Schinoff" />
Sergio Schinoff

Hi, I was wondering how could I allows multiple external SQL records to be populated into a form. For instance, can I populate a check box list with multiple journal names from a SQL query?
Is there a way to accomplish this?

19/20/2018 8:53 AM9/20/2018 8:53 AMNoCodes & Scripts
6.72227682908735
19/20/2018 8:29 AM1
Jim Hidson
Posted: 9/23/2018 5:44 AM
Picture: Jim Hidson
Jim Hidson

You can create and external list connected to that SQL table, and use the function getListItemData() to retrieve the data and bind them to the control ie. (checkbox).

Or you can set the control (checkbox) in a repeater and use the function generateRepeaterRowValues() to get the records from the external list and populate them in the repeater control.

 

Picture: Jim Hidson
  • Jim Hidson
http://www.itlaq.com:80/my/User%2520Photos/Profile%2520Pictures/jim_MThumb.jpg?t=63627189186" alt="Picture: Jim Hidson" />
Jim Hidson

You can create and external list connected to that SQL table, and use the function getListItemData() to retrieve the data and bind them to the control ie. (checkbox).

Or you can set the control (checkbox) in a repeater and use the function generateRepeaterRowValues() to get the records from the external list and populate them in the repeater control.

 

Sergio Schinoff3609/23/2018 5:44 AM9/23/2018 5:44 AM
9/19/2018 7:49 AM