August 29, 2008 09:28pm pdt

1. SidFishes 204,731
2. gdemaria 204,094
3. Zvonko 191,035
4. _agx_ 103,710
5. Plucka 93,513
6. SBennett 49,530
7. zadoc 49,250
8. hielo 43,750
9. erikTsomik 31,010
10. Jester_48 27,025
11. pmascari 24,754
12. Mr_Nil 24,710
13. js_vaughan 24,050
14. dgrafx 16,675
15. pigmentarts 16,150
16. Kerrdo 14,850
17. danrosent... 14,300
18. msfletch 13,920
19. srikanthm... 12,950
20. b0lsc0tt 12,000
21. ee_rlee 10,500
22. Yamagami 9,900
23. digicidal 9,550
24. rucky544 9,200
25. dwkd 9,175

1. gdemaria 546,086
2. _agx_ 477,265
3. SidFishes 331,537
4. SBennett 212,175
5. Zvonko 200,099
6. Plucka 115,213
7. zadoc 76,380
8. pmascari 73,529
9. hielo 65,250
10. Jester_48 63,845
11. js_vaughan 54,450
12. erikTsomik 43,280
13. pigmentarts 36,698
14. dgrafx 31,250
15. danrosent... 28,200
16. digicidal 27,550
17. 73Spyder 26,575
18. Mr_Nil 24,710
19. angelIII 24,200
20. Mause 23,200
21. b0lsc0tt 22,472
22. R_Hos 21,150
23. mplungjan 18,125
24. rucky544 18,100
25. srikanthm... 17,800

02.26.2008 at 11:40AM PST, ID: 23194761

	[x] Attachment Details

working with drop down list box to change contents of label

Asked by sonicimpulse in Cold Fusion Markup Language, WebApplications

Thanks to all the generous people on here help me out. I have this section of code I want to modify. This code changes the contents of a label depending on whats selected in a listbox. What I want to do is modify it to populate the list box from a database instead of the array. I will attach both the code I got from here and the code I use to populate a list box from a database. Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:

           
           
             <!--- This is the code that changes the contents of a list box --->
<cfset mySel = queryNew("")>
<cfset queryAddColumn(mySel, "label", listToArray("test,Option2,Option3,Option4,Option5"))>
<cfset queryAddColumn(mySel, "selval", listToArray("O1,O2,O3,O4,O5"))>
<cfset queryAddColumn(mySel, "description", listToArray("Description for Option1;Description for Option2;Description for Option3;Description for Option4;Description for Option5",";"))>
<form>
<select name="mySelect" onChange="showDesc(this)" >
<option descript="Select one Option.">-Select-</option>
<cfoutput query="mySel">
  <option value="#selval#" descript="#description#" >#label#</option>
</cfoutput>
</select>
<span id="description">Select one Option.</span>
</form>
<script>
function showDesc(theSel){
 var theDesc = theSel.options[theSel.selectedIndex].getAttribute("descript");
 document.getElementById("description").innerHTML = theDesc;
}
</script>
 
 
<!--- This is the code I use to populate a list box from a database --->
<tr>
  <td>Catagory:</td>
  <td>  <cfquery name="cata" datasource="#DSN#">
SELECT id,catagory from catagories
</cfquery>
<select name="lcatagory">
<cfoutput query="cata">
<option value="#id#|#catagory#">#catagory#</option>
</cfoutput>
</select></td>
</tr>

           
         

Keywords: working with drop down list box to cha…

	Title
1	Array of labels....
2	Placing a Circle around a Label
3	read url and display hyperlinks in label
4	labels
5	Zebra label printing speed vb.net to M…
6	Combo box and a labels

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

working with drop down list box to change contents of label

Asked by sonicimpulse in Cold Fusion Markup Language, WebApplications

About this solution