TRIM

I l @ ve RuBoard

Used to remove excess white space from the beginning and end of variables .

Syntax

 Trim(name_of_variable_to_be_trimmed) 

Parameters

Trim needs to have the name of the variable you want to clean up.

Example

 <!--- Clean up form value before database insert --->  <cfquery name="userinfo" datasource="users"?   INSERT INTO tblUser (     Fname,     Lname   )   VALUES(     '#Trim(form.Fname)#',     '#Trim(form.Lname)#'   ) </cfquery> 

I l @ ve RuBoard