Whitespace issue.
Has anyone experience the problem similar to below.
<cfquery name="getSomething" datasource="ds">
SELECT 'test' test1
FROM DUAL
</cfquery>
<cfoutput>
aaa#getSomething.test1#aa
</cfoutput>
result is:
aaatest aa
Notices the whitespace which is variable. The problem only occurred at one of our client machine which we don't have any controlled of.
I even surround it with csilent but nothing fix. I can trim as a temporary solution but need to find the cause so it could be prevented in the future. What puzzle me is it working fine at our dev and quality environment but not at our client environment.
