converting javascript variable to coldfusion

Question

I am running a form that submits data via the cf ajax to a .cfc file --
when it returns to the calling page -- i turn the forms into text and remove the form fields.
the problem is i run the statement:
document.getElementById("PROGRAM_TYP").innerHTML = document.myform.PROGRAM_TYP.value;

most of the items submitted are just text values and the value of the form field is the actual display text which then populates correctly.
in this case -- the form field is a select where and ID is used -- so when i go to populate the <td> with the submitted value -- it only puts in the ID (as this was the actual submitted value)

i am trying to take this submitted value and resolve the ID back to the display value and use this value in place of the document.myform.PROGRAM_TYP.value

what i need to be able to do is convert the document.myform.PROGRAM_TYP.value into something i can plug into CFQUERY.
or use the <cfreturn> to return and catch a specific variable.

Anonymous · Answer

i think i used the wrong wording in my original question.
the ID i was referring to was the database ID value
like query of:
ID NAME
1 Red
2 Blue
3 Green

in my select statement -- the ID is the value that is submitted by the form and held in the database. (not the ID of an html tag).
so when the form is submitted - i have the value but not the database resolved value of that field.
for instance the form value was 2, the code places 2 into the corresponding database field. but i want to now display the value of 2 in clear text as 'Blue' -- i am trying to do this via a query that was run and have the result passed from the cfc to the webpage to populate the innerHTML value

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded