One note I did not mention, The rules for valid field names in a query, and the
rules for valid form field names are different. It is allowable to have spaces
and other characters as part of a sql column name, but those same characters
are not allowed as part of a form field name.
That is not your error, though.
It looks like you are doing some sort of error checking on the receiving page.
It seems that the data in your query is failing that validation.
I am stuck, too. Hopefully you can get some ideas why this isn't working from
others on this list.
Can you list the field names? can you list the value passed for BILLING? can
you list the expected value for BILLING?
Jerry
Jerry Johnson
Web Developer
Dolan Media Company
>>> [EMAIL PROTECTED] 12/14/04 10:48AM >>>
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 Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187570
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54