Hi
that was the problem
the table field was named bill_date
and your function works fine only had the problem with cleanForm
but I have changed the field name in the table
>This is due to CF automatic server side validation. You can't have any
>form fields that end in _date, _eurodate, _required, _integer, _float,
>_time, _range (check the docs to see if the list is complete)
>
>Looking at your error, I suspect you have billing_date as a form field.
>
>This will give you problems with your automated cfquery2form. As a
>workaround, you could add a custom extension (like _asim at the end of
>the form vars and strip it of in the action page:
>
><cffunction name="Query2Form" returntype="string" output="false">
> <cfargument name="query" required="yes">
> <cfargument name="extension" required="no" default="_asim">
> <cfset var i = "">
> <cfset var out = "">
> <cfif query.recordCount>
> <cfloop list="#query.columnList#" index="i">
> <cfset out = out & '<input type="hidden"
>name="#i##extension#" value="#HTMLEditFormat(query[i][1])#">'>
> </cfloop>
> </cfif>
> <cfreturn out>
></cffunction>
><cffunction name="CleanForm" returntype="struct" output="false">
> <cfargument name="stForm" required="yes">
> <cfargument name="extension" required="no" default="_asim">
> <cfset var stTmp = StructNew()>
> <cfset var key = "">
> <cfloop collection="#stForm#" item="key">
> <cfset stTmp[REReplaceNoCase(key,"#ext#$","")] =
>stForm[key]>
> </cfloop>
> <cfset stForm = stTmp>
> <cfreturn true>
></cffunction>
>
>Pascal
>
>PS I wrote the code in the mail and didn't test it at all.
>
>that
>>
>>
>> Form entries incomplete or invalid.
>> Dry Van
>> Yes
>> The value entered for the BILLED field ('0') is not correctly
>formatted.
>> Please go back and correct the problem.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187591
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
