<option value=""> returns correct number but empty

[adam999]

I have a search page displaying three pull down menus. 2 of the menus are populated correctly based on the following code.

The third displays the correct number of selections but with no text. If I view the source html, option value="" is repeated for the correct number of entries in the database yet remains empty. Any clues? Here is the code:

<SELECT NAME="CategorySelectorField" >

<OPTION VALUE=""> - Select a Category -

[FMP-InlineAction: -db=Categories.fp5, -lay=Layout, -findall]

[FMP-Record] <option value="[FMP-Field:CategoryID]">[FMP-Field:Category] </option> [/FMP-Record]

[/FMP-InlineAction]

</SELECT>

<BR> <BR>

Thanks.

[Garry Claridge]

Are the fields "CategoryID" and "Category" on the Layout called "Layout"?

Good Luck.

Garry

[adam999]

Hi Garry. Thanks for you response.

Yes they are. I double checked this as I thought it might be the problem. I even duplicated the layout and changed the code but no joy.

Adam

[adam999]

All,

Just for the record, I have now resolved this. Garry was correct in it being a layout issue. The fields were on the layout but the database had not been enabled for web publishing (all my other ones had so I was very confused!). You do this by going to File > Sharing. Don't tear your hair out over the code like I did!

Thanks,

Adam