Values being Passed from submit button

I am using the dynamic dropdowns and it is doing exactly as I needed, but with one small issue. I have three boxes and have created id's in three different tables. The lists I have consist of: Region, Building, and Project.
The problem I am having is not when the boxes load, those are loading with the text values from the DB like it is supposed to. However, when I submit the page the id's are being passed instead of the list values. This is being passed into Crystal and it works when I select one field,but once I select more than one it tries to pass as a string.

Instead what I want is for it to pass the values. I can see in the array option [0] as the id and [1] as the value, but where do I specify in the code to pass [1] instead of [0], or the values instead of the id's? I followed the instructions to a tee and very easy, but cannot figure out which control changes this part.

Any help would be greatly appreciated. I have attached the could for you to look at.
Here is the web link with response.write in the setSelectionInformation () fiunction. When you select items it will give an error, but also display the values's for the objects you selected. I need this to be the text from the lists instead of the id's.

Just select Americas | 100 Summer Street | then the two Projects and hit run report.

Finance_Details.asp

Thank you in advance!

A select list cannot be set to pass the lable. It will always pass the value.


In a select list where you can select one element, you could use javascript to populate a hidden element with the selected label. But in your case, you are using multiple select lists.

You should use DataAssist search to query your database using the ID columns and the IDs that are passed from the select lists.

OK. I actually got it figured out, but have a new problem when I submit.

When I submit the response.write(s), I have in place in my code, shows all values select without a delimiter between them.
(ex. Selecting Americas | 100 Summer Street | 2008SUM0151)
(Result: AMERICAS100 SUMMER STREET2008SUM0151)

If I select more than one it places a comma in between the two or more selected values which is what I need it to do. However, one I only select one Region and then the Building it combines the two of them and my DB does not see that as a qualifying Region name.

I need to know where in the code I can put ',' to separate the values from Parent, Child, Target without having to use the Prepend Source Text option.

Send me a copy of your page so I can see the code please.

The code is attached to my original posting. I am only saying this because if you are not able to see it then do I need to email it to you?

Please advise.

OK, but what code in the page you originally pasted do you need to edit?


I'm not sure I understand what code you want the comma added to?