How do I Trim a value coming from a CFC?

Hi!

I have a simple CFC which gets records from a database.

I have then created a ColdFusion page and used <cfobject> to make an instance of the CFC. I then use this instance to populate a <cfselect> form element.

The problem is that the field has too many spaces in it so I need to Trim it.

Here is my code:

<cfobject component = "globalFilters" name="globalFilters">

<cfinvoke component="#globalFilters#" method="filters_Status" returnvariable="rsStatus">

<cfselect name="Status"

query="rsStatus"

value="#Trim(Status)#"

display="Status">

</cfselect>

Unfortunately it CF says "Status" is not defined and fails. But if I remove the Trim method then it works fine.

How do I trim the value in the select list?