Populating data into a drop down box 1

[scottew]

I have a form which I would to populate a drop down box with some data. Below is the query and part of the form. Currently, it puts each location in a separate drop down. How can I get all the data into one drop down box.

Any help will be greatly appreciated!

Thanks,
Scott

<cfquery name="getTerminal" datasource="mssqlcf_hibarsky" dbtype="odbc">
	select *
	from locations			
	</cfquery>

<tr>
 <td width="35%" align="right">Terminal Name:</td>	  
<td width="65%" align="left">
<cfoutput query="getTerminal">
<SELECT NAME="A)Terminal_Name" SIZE="1">
<OPTION VALUE="getTerminal">#getTerminal.name#</option>
			
</cfoutput>			
</SELECT>		    
 </td>
  </tr>

 

[ecobb]

Move your cfoutput tags inside your select box and have them surround the option tags.

<tr>
 <td width="35%" align="right">Terminal Name:</td>      
<td width="65%" align="left">
<SELECT NAME="A)Terminal_Name" SIZE="1">
[red]<cfoutput query="getTerminal">[/red]
<OPTION VALUE="getTerminal">#getTerminal.name#</option>            
[red]</cfoutput>[/red]            
</SELECT>            
 </td>
  </tr>

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[scottew]

That did it. Thank you very much!

 

[scottew]

My next question is, once I select the Terminal from the drop down box, I would like to populate the remaining feilds in the form with a new single record query based on the terminal I selected.

Thanks again for your help!
Scott

 

[FALCONSEYE]

http://www.webtricks.com/sourcecode/code.cfm?CodeID=18

let me know if you need help.

http://www.jetansolutions.com

 

[GUJUm0deL]

Also check out FAQ232-6607 (this deals with 3 related select boxes but can be tweaked to only include 2 related select boxes)

____________________________________
Just Imagine.

http://www.imajinarts.com