How to use TRIM DATA in CFFORM?

[chumjeen]

How to use TRIM DATA in CFFORM? when data is retrieving from DATABASE. Wanna rtrim and ltrim while spaces.

[Maneesh_Tikkiwal]

What do you mean? Please give example.

do you want to do this?

<cfform name="myForm" method="post" action="abc.cfm">
<cfinput type="text" name="myField" value="<cfoutput>#TRIM(sql.data)#</cfoutput>">
</cfform>

[drforbin1970]

Check out the SQL functions LTrim/RTrim for MSSQL. Not sure about MySQL but I think there is a Trim function.

[rizalfir]

Better to trim those values after the form submission.
Once you put them into form,
user may also makes mistake by hitting space, right?

Also, by trimming all form fields after submission, you will be sure that your DB is clean... no whitespaces on it.
Well unless someone insert data directly onto it :)