cfml + javascript = populating text box?

I wanted to populate a text field and possibly refresh the page so it can output a query correctly (keeping the populated
data so coldfusion will see that data and populate the field correctly when it interprets the code?). My reasoning behind it is i
have a page that querys a database selecting everything in a table. (using coldfusion) then populates a dropdown with a
certain column of that data (on load). I want it to populate the text field depending on which option you select in the
dropdown (with another column of data). Is this possible? I know how to populate the field with my column (#sftr_sn#) but i cant make it interpret this because this is selected AFTER coldfusion (serverside) interprets the variables! any help would be much appriciated! thanks!

to some degree, its not populating to a second list, i.e. its not a progressive dropdown. rather its populating a text field. heres an example. lets say i populate a dropdown list with a column named sftr_nm (software name) and when i choose one i want it to populate the text field below it with the corrosponding sftr_sn (software serial no.). i know its possible and i hadnt thought of having it submit to the same page, that might work. ill try it. any other ideas plz plz let me know. thanks!

i had thought of that but was not sure how to populate the arrays with the CF output =/ if anyone knows that would be good (eventually im going to have to requery because of length of table, but for nbow arrays would be nice just as a convience.). thanks ethan, much appriciated =)

hrmm so it will output the first peice of info from each column into a array, and then increment the array (index) number and then do the same untill it is out of columns? i see what you are saying but im not seeting if it is gonna populate just one or multiple parts of the array not just the 0. if this works you're officially my hero of the week haha, thanks.