nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Popluating a select list item in form-api

niranjan

hi,
I want to populate a select list by fetching records from the database. I mean i have to execute a select statement and then populate the select list with the returned resultset.
How can did be achieved in form-api

Thanks
Niranjan

Find more posts tagged with

Comments

abhishek_gupta

If you want to populate in your DCT, I think the best option would be writing a java/cgi callout.

AK
Interwoven TeamSite Consultant

Michael

Hi Niranjan,

If the values in the select list are not dependent on values in your DCR then you could populate the list using an inline call to a script which returns the options.

If the values in the select list are dependent on values in your DCR. ie if you want different options available in the list based upon the value in another field in your DCR then you will need to use FormAPI.

One way of doing this with FormAPI is by have a callSerer call to a script. The script queries the database and returns some JavaScript which will be executed when the script is complete. This JavaScript will set the values in your select list.

The FormAPI manual has some good information on this process if that is the road you are going down that road.

Cheers
Michael

niranjan

Hi Michael,
i want to populate a select based on the value of another select list as you mentioned.
colud you please let me know where i could get the documentation you refered.

Thanks
Niranjan

Michael

The manual I referred to is called "TeamSite ® Templating: FormAPI Developer’s Guide Release 5.5.2" and is available for download from the Interwoven support site: Download -> Documentation -> Templating -> 5.5.2 FormAPI

Hope that helps.

Cheers
Michael