checking query result for newline character
Hi guys ,
I have a query which is called in coldfusion and the values of its volumns are set into variables
LIKE in the code segment below:
<cfquery name="divisions_models" datasource="#request.formula_dsn#">
SELECT division_code as div_cd, division_name as div_dsc,
nvl(model_code,0) as mdl_cd, nvl(model_name,'All') as mdl_dsc
FROM fe_mfg_lkp
where division_code is not null
ORDER BY div_dsc, mdl_dsc
</cfquery>
<cfset div_cds = ValueList(divisions_models.div_cd)>
<cfset div_list = ValueList(divisions_models.div_dsc)>
<cfset mdl_cds = ValueList(divisions_models.mdl_cd)>
<cfset mdl_list = ValueList(divisions_models.mdl_dsc)>
i am using division models query and assigning values of them to div_cds and three other variables as shown in code.
The PROBLEM is the values from query(division_models) are sometimes returning newline character ,which i have to eliminate .
Any ideas or code examples on how to acheive it.
Thanks
