Question about ValueList in CDML

[Brulotte]

I have a FM database that has a field called Owner and that pulls from a ValueList called OwnerList. I'm trying to write the CDML that will show a drop down with the values from OwnerList in it. That way, if I add another owner in the database, I don't have to go back into the page and add that name (hardcoded)into the CDML. These forums say the code should be:

<select name="Owner">

<OPTION VALUE="" SELECTED>- Select Owner -

[FMP-option: Owner, list=OwnerList]

</select>

However, when I look at it in a browser, I don't see the list of names in OwnerList. Instead, I see a window that says "- Select Owner - [FMP-option: Owner, list=OwnerList]"

What, praytell, am I doing wrong?

[Garry Claridge]

Try this, add the </option> tag:

<select name="Owner">

<OPTION VALUE="" SELECTED>- Select Owner -</option>

[FMP-option: Owner, list=OwnerList]

</select>

All the best.

Garry

[Brulotte]

That worked to get rid of the [FMP-option: Owner, list=OwnerList] that was showing in the drop down window but the values from the valuelist in FM is not displaying.

Is that something I need to pull earlier in order for it to display or is it just not possible?

[Garry Claridge]

Is the page in question being called as a format file? If not, the database will not be accessed to display the ValueList.

All the best.

Garry

[Brulotte]

Not sure what you're asking. I've got a hidden tag (-format) but that, as I understand, tells where the output is displayed.

What I'm trying to get in this is to have the drop-down list pull it's info from the valuelist in the FM database instead of having to put in option values whenever a name is added or subtracted from the database.

Does that make sense?

[Garry Claridge]

The page with the drop-down needs to be called my another page/url via FMP. FMP needs to process the page so that the ValueList can be displayed.

The drop-down page can be called with a -view tag. E.G. http://1.2.3.4:1234/FMPro?-db=mydb.fp5&-format=dropdown.html&-view

This way FMP will look at the database to find the ValueList.

Garry

[Keith M. Davie]

The cdml "valuelist" is a waste of your time. Write a simple html popup. List whatever values you want to use and direct that to the appropriate field in your web layout. Set that field as STANDARD. It will work with that field being a popup on a different layout as long as you use the same values. But simplify and use a standard field in your web layout along with html for the popup and a cdml tag for the field you want to affect.

[Simon]

Keith,

How does that answer his question. He clearly states that he wants people to add to the database and not have to keep rewriting the code every time somones does. His only problem seems to be that he is not building the page from an action call. The CDML value list works perfectly.

Simon

[Keith M. Davie]

Well if the owner's name is added to the standard field (including a linebreak), and that field is then called as the drop-down (pop-up) menu ...