String or binary data would be truncated. ERROR

I keep getting this error and i have no idea why.

 Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.

The error occurred in E:\\Development\\SGTest\\NewsletterApp\
ewsletter.cfc: line 125
Called from E:\\Development\\SGTest\\NewsletterApp\\addEdition.cfm: line 13
Called from E:\\Development\\SGTest\\NewsletterApp\
ewsletter.cfc: line 125
Called from E:\\Development\\SGTest\\NewsletterApp\\addEdition.cfm: line 13

123 :             (<cfqueryparam value="#arguments.NewsletterID#">, <cfqueryparam value="#arguments.EditionTitle#">, <cfqueryparam value="#arguments.EditionNumber#">,
124 :             <cfqueryparam value="#arguments.Introduction#">, <cfqueryparam value="#arguments.ConclusionTitle#">, <cfqueryparam value="#arguments.Conclusion#">,
125 :             <cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp">)
126 :         </cfquery>
127 :     </cffunction>

Here is my Function:

<!--- Insert a new edition --->
    <cffunction displayname="Insert Edition" returntype="void" access="remote" name="InsertEdition" hint="Insert the form details into the edition table">
        <cfargument name="NewsletterID" default="" required="yes">
        <cfargument name="EditionTitle" default="" required="yes">
        <cfargument name="EditionNumber" default="" required="yes">
        <cfargument name="Introduction" default="" required="yes">
        <cfargument name="ConclusionTitle" default="" required="yes">
        <cfargument name="Conclusion" default="" required="yes">

        <cfset var qInsertEdition = "">
        <cfquery datasource="#THIS.dsn#" name="qInsertEdition">
            INSERT INTO NewsletterEdition
            (NewsletterID, EditionTitle, EditionNumber, Introduction, ConclusionTitle, Conclusion, dtCreated )
            (<cfqueryparam value="#arguments.NewsletterID#">, <cfqueryparam value="#arguments.EditionTitle#">, <cfqueryparam value="#arguments.EditionNumber#">,
            <cfqueryparam value="#arguments.Introduction#">, <cfqueryparam value="#arguments.ConclusionTitle#">, <cfqueryparam value="#arguments.Conclusion#">,
            <cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp">)

And here my form:

<cfform action="#CGI.SCRIPT_NAME#" method="post" id="addEdition">

    <!--- Post Form submit message --->
        <cfif isdefined('FORM.AddButton')>
            <cfif len (form.EditionTitle) and len (form.EditionNumber)>
                <p class="message green">You have added your new edition.</p>
                <p class="message red">Please fill out all the required fields (*).</p>

    <div><!--- Owning Group Select --->
        <label for="TemplatesList">Owning Group:</label>
        <cfselect name="TemplatesList" bind="cfc:newsletter.ListGroups()" display="prompt" value="id" bindonload="true" />

    <div><!--- Parent Template Select --->
        <label for="Template">Parent Template:</label>
        <cfselect name="Template" bind="cfc:newsletter.ListTemplates({TemplatesList})" display="NewsletterTitle" value="NewsletterID" />

        <div><!--- Edition Title Input --->
            <label for="EditionTitle">Edition Title<abbr title="Required field"> *</abbr></label>
            <input type="text" name="EditionTitle" placeholder="Winter Edition" size="40"/>

        <div><!--- Edition Number Input --->
            <label for="EditionNumber">Edition Number<abbr title="Required field"> *</abbr></label>
            <input type="text" size="3" maxlength="3" name="EditionNumber" placeholder="1"/>

        <div><!--- Summary Input --->
            <label for="Introduction">Introduction</label>
            <textarea cols="50" rows="6" name="Introduction"></textarea>

        <div><!--- Conclusion Title Input --->
            <label for="ConclusionTitle">Conclusion Title</label>
            <input type="text" name="ConclusionTitle" placeholder="Conclusion" size="40"/>

        <div><!--- Conclusion Body Text Input --->
            <label for="Conclusion">Conclusion</label>
            <textarea cols="50" rows="6" name="Conclusion"></textarea>

        <div><!--- Controls Input --->
            <input id="submit" type="submit" name="AddButton" value="Create Edition"/>


Any ideas of what could be causing this error. I have had it working in the past with the same Function but with a different form. so i know the DB table and CFC is set up correctly.

Double check your fields in your database table to make sure they can handle the length of the data being passed in.

Most likely fields are your char and varchar fields - most databases default to 50 characters. Set the length of the fields to max and try out your form.

Another thing to watch out for are hidden characters in the text coming from your forms. You may have set the length property in the database field to say 1000 characters and then typed in 500 characters and submitted the form, then got an error. Spaces count as characters and if you are using html enable controls, you could be passing along a lot of hidden characters.

After alot of looking around a possible problems i found the section of code i should of posted here in my first post.

<cfif isdefined('FORM.AddButton') and len (EditionTitle) and len (EditionNumber)>
    <cfset AddEdition = newslettercfc.InsertEdition (NewsletterID = Trim(FORM.Template), EditionTitle = Trim(FORM.EditionTitle),
        EditionNumber = Trim(FORM.EditionNumber), Introduction = Trim(FORM.Introduction), ConclusionTitle = Trim(FORM.ConclusionTitle),
        Conclusion = Trim(FORM.Conclusion))>

The problem was caused by having single quotes wrapped around my trim value on each element. removed the quotes and the problem is gone.


Off Topic:

Try to use <cfsqltype> with your <cfqueryparam>