I have a .fex that populates a drop down in my html, then that value(s) chosen are passed into a stored procedure. I need to have only specific values included in a 'All values1,2,3' in addition to the 'All' option that is already listed.

How would webfocus handle that?
Woudl it have to be done a dbase level?

TABLE FILE LOOKUP_COMPANY
PRINT
NAME1
NAME2
NAME3
NAME4
NAME5
NAME6
ALLNAME1STVALUES (NAME1,NAME2,NAME3)

ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XML
ON TABLE SET STYLE *
$
ENDSTYLE
END

This message has been edited. Last edited by: <Kathryn Henning>,

Use following sample code:-
TABLE FILE CAR
PRINT
CAR.COMP.CAR
CAR.CARREC.MODEL
CAR.BODY.SEATS
WHERE CAR.COMP.CAR EQ &CAR.(OR(FIND CAR.COMP.CAR IN car)).CAR:.;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END

SOLVED

Thank u for your help.

Please Mark this post as SOLVED