cfselect display attribute question
I have a cfselect where I need to concat two variables "AgentFName" "AgentLName" in the display attribute. How can this be done?
<cfquery name="agent" datasource="test">
SELECT fagents.Agent,fagents.Agen
</cfquery>
<cfselect Name = "Agent" query = "agent" value = "Agent" display="AgentFName" queryPosition="below" class="selectpicker show-menu-arrow span4">
<option value=" ">Please Select</option>
</cfselect>
Thanks!
<cfquery name="agent" datasource="test">
SELECT fagents.Agent,fagents.Agen
</cfquery>
<cfselect Name = "Agent" query = "agent" value = "Agent" display="AgentFName" queryPosition="below" class="selectpicker show-menu-arrow span4">
<option value=" ">Please Select</option>
</cfselect>
Thanks!
Concatenate the columns in the query to create one column and use that in the select
<cfquery name="agent" datasource="test">
SELECT f.Agent
,f.AgentLname + ' ' + f.AgentFName as AgentFName
from fagents
</cfquery>
<cfquery name="agent" datasource="test">
SELECT f.Agent
,f.AgentLname + ' ' + f.AgentFName as AgentFName
from fagents
</cfquery>
Hi gdemaria,
When I run that I get no error, but each record is displayed as 0.0 ?? what could cause that? See attached pic."
<cfquery name="agent" datasource="test">
SELECT fagents.Agent,fagents.Agen
</cfquery>
<cfselect Name = "Agents" query = "agent" value = "Agent" display="Name" queryPosition="below" class="selectpicker show-menu-arrow span4">
<option value=" ">Please Select</option>
</cfselect>
![screenshot]()
When I run that I get no error, but each record is displayed as 0.0 ?? what could cause that? See attached pic."
<cfquery name="agent" datasource="test">
SELECT fagents.Agent,fagents.Agen
</cfquery>
<cfselect Name = "Agents" query = "agent" value = "Agent" display="Name" queryPosition="below" class="selectpicker show-menu-arrow span4">
<option value=" ">Please Select</option>
</cfselect>
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Check out the Concat_WS function for MySQL:
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat-ws
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat-ws
CONCAT_WS(',', 'fagents.AgentLname', 'fagents.AgentFName') as Name
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat
SELECT fagents.Agent, CONCAT(fagents.AgentLname,
Worked! Thanks again
Worked! Thanks again
> each record is displayed as 0.0 ?? what could cause that?
FWIW, it's because MySQL only uses "+" for addition. If you use it with strings, MySQL attempts to convert the strings to numbers first. Since a name like "John" or "Smith" isn't a number, MySQL converts it to zero.
SELECT 'John' + 'Smith' AS Name <== translates to SELECT '0' + '0' AS Name
The behavior's similar to CF's Val() function. Val() converts any non-numeric values to 0.
FWIW, it's because MySQL only uses "+" for addition. If you use it with strings, MySQL attempts to convert the strings to numbers first. Since a name like "John" or "Smith" isn't a number, MySQL converts it to zero.
SELECT 'John' + 'Smith' AS Name <== translates to SELECT '0' + '0' AS Name
The behavior's similar to CF's Val() function. Val() converts any non-numeric values to 0.
Join our community and discover your potential
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.
*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.