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.
> -----Original Message-----
> From: Asim Manzur [mailto:[EMAIL PROTECTED]
> Sent: 14 December 2004 16:49
> To: CF-Talk
> Subject: Re: <QUERY2FORM>
>
> Thanks I tried that but got the error.
> Somehow its trying to do the server side validation. Howto prevent
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 - New Atlanta
http://www.newatlanta.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187584
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
