yoshismokey
Programmer
Hi, I have a cfselect problem. When the following code is run, if there are any blanks in the fields, none of the values appear in the drop down box. Any ideas why?
Thanks,
Here's the code....
<cfquery name="getcust" datasource=#MM_connproducts_DSN# username=#MM_connproducts_USERNAME# password=#MM_connproducts_PASSWORD# debug="yes">
SELECT Customer_Number, Hospital_System_Name, Hospital_Name, Address1, City, State,
Customer_Number+' '+Hospital_System_Name+' '+Hospital_Name+' '+Address1+' '+City+' '+State+'' as dropdownvalue
FROM Customer
WHERE Customer.Agency_Name = '#Agency_Name#'
</cfquery>
<cfoutput><cfselect name="Selectbox" size="#getcust.recordcount#" message="You must select one customer number from the selection box."
query="getcust" value="dropdownvalue" required="yes" multiple="no">
</cfselect></cfoutput>
Thanks,
Here's the code....
<cfquery name="getcust" datasource=#MM_connproducts_DSN# username=#MM_connproducts_USERNAME# password=#MM_connproducts_PASSWORD# debug="yes">
SELECT Customer_Number, Hospital_System_Name, Hospital_Name, Address1, City, State,
Customer_Number+' '+Hospital_System_Name+' '+Hospital_Name+' '+Address1+' '+City+' '+State+'' as dropdownvalue
FROM Customer
WHERE Customer.Agency_Name = '#Agency_Name#'
</cfquery>
<cfoutput><cfselect name="Selectbox" size="#getcust.recordcount#" message="You must select one customer number from the selection box."
query="getcust" value="dropdownvalue" required="yes" multiple="no">
</cfselect></cfoutput>