Illustra Problem with WebSelectList
Posted in 1996
Topics: SQL Development & Query Writing
Has anyone successfully implemented the function WebSelectList( , , ) in Illustra? I followed the example in manual WebDataBladeModule User Guide v.2.2 pg.108 the syntext is: WebSelectList(setof(text), text, setof(text)) first argument- a query returning the items of the selectionlist second argu- attributes of the select tag. third- a subset of the first argument for the initial selection. this is what I did: <?MISQL SQL="return WebSelectList( (select roles.oid from roles order by 1), 'NAME=test_role2 SIZE=10 MULTIPLE', (select roles.oid from roles order by 1));">$1 <?/MISQL> According to their manual, I should get a select list in html with all the options selected. However,This is the html page I got: |<SELECT NAME=test_role2 SIZE=10 MULTIPLE> <OPTION> <OPTION> <OPTION> <OPTION> <OPTION> </SELECT>| Problem: All the options are missing and nothing is selected. However, when I do the select statements seperate in msql, I do get the options printed. Has anyone ever got this function to work correctly? Please tell me how you did it or what I did wrong with mine. Wayne Chen wchen@panbio.com