Hi,
I have a picklist in powerprompts that I need to then use the values of it to provide another picklist (cascading prompt). The problem is the values of the first picklist need reformatted on submitting the page to display ('12345678','23456789') so the sql can be formatted as select * from table where fields in (\''+ App.Variables("Group_Num") +'\'). I have been told I can do this in javascript, but I do not know how to code javascript, can any one help with this?
Tricia
I have a picklist in powerprompts that I need to then use the values of it to provide another picklist (cascading prompt). The problem is the values of the first picklist need reformatted on submitting the page to display ('12345678','23456789') so the sql can be formatted as select * from table where fields in (\''+ App.Variables("Group_Num") +'\'). I have been told I can do this in javascript, but I do not know how to code javascript, can any one help with this?
Tricia