Validate the data coming in. If the data passed in is “”””, set
it to NULL instead. From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard
This should go to the discussion list (and I redirected it
there). I apologize, this is my first
attempt at trying to ask a question to the ACFUG and I just replied to an email
that I received. Yes,
it is set to accept nulls. The issue is the form passes a ""
and when it tries to update a smalldate and a money field in the table it
throws and error. I put the SQL statement generated in the CF error into
Enterprise Manager and dissected it field by field. The error that I get from
Enterprise Manager is invalid data type or length. Do you Yahoo!? ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink ------------------------------------------------------------- |
- [ACFUG Discuss] Re: [ACFUG Community] Quick (an... Dean H. Saxe
- Re: [ACFUG Discuss] Re: [ACFUG Community] ... Jeff Howard
- Re: [ACFUG Discuss] Re: [ACFUG Communi... Precia
- re[2]: [ACFUG Discuss] Re: [ACFUG Comm... Mischa Uppelschoten ext 10
- Re: re[2]: [ACFUG Discuss] Re: [AC... Teddy Payne
- Re: re[2]: [ACFUG Discuss] Re: [AC... Jeff Howard
- RE: [ACFUG Discuss] Re: [ACFUG Communi... Justin Haygood
- Re: [ACFUG Discuss] Re: [ACFUG Com... Teddy Payne
- Re: [ACFUG Discuss] Re: [ACFUG... Dean H. Saxe
- Re: [ACFUG Discuss] Re: [... Jeff Howard
- RE: [ACFUG Discuss] R... John Mason
- Re: [ACFUG Discus... Douglas Knudsen
- RE: [ACFUG Discuss] R... Justin Haygood
- re[2]: [ACFUG Discuss... Mischa Uppelschoten ext 10
- Re: re[2]: [ACFUG... Dean H. Saxe
- RE: [ACFUG Discuss] Re: [ACFUG Community] ... axunderwood
- RE: re[2]: [ACFUG Discuss] Re: [ACFUG Comm... Dan