Re: Stored Procedure to Add Record not adding record

["JR "Bob" Dobbs"]

Replace:

    <cfif isdefined ("Form.Amt_Principle") and Form.Amt_Principle NEQ "">
                <cfprocparam cfsqltype="cf_sql_decimal" 
value="#Form.Amt_Principle#">
        <cfelse>Null</cfif>


 With:

 I'd provide each form variable with a default value so that a value will 
always exist for each variable.
 <cfparam name="form.Amt_Principle" default="" />

 Use the null attribute, if the value is 'yes' the value NULL will be passed to 
the stored procedure parameter, else the contents of the value attribute will 
be used
 <cfprocparam cfsqltype="cf_sql_decimal" value="#Form.Amt_Principle#" 
null="#YesNoFormat(not(IsNumeric(form.Amt_Principle))#">


 
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_p-q_14.ht
ml#1102102