I creating a dynamic page that will display a list of values based on what the user input into the parameters. It works find as long as they only input a single value in (ex. Create User) but when attempting to input multiple values (ex. Create User, Delete User) no information is brought back. Is there a way that I can fix this so that the user can input multiple values? Any help with this would be greatly appreciated, thanks.
select i.folder_id pageid
from items i
where i.caid = :p_sitecode
and i.subtype = ity.id
and i.display_name in (:p_formname)
A quick and dirty method is to create separate form objects for each selection, i.e. :p_formname1, :p_formname2. Then your query would be something like display_name in (:p_formname1,:p_formname2). Otherwise you may need to parse your :p_forename into multiple name value pairs.