I have a form. I need one of the things that happens on submission is
for the current date to be put in the database. The only way I knew to
do this is with a SQL insert instead of a cfinsert. This part works
fine. The part that isnt working is some of the form boxes need to be
required, and some need to be validated too, but some need to be
optional. So I have cfinserts and a SQL statement. When the optional
form fields are left blank, I get an error message that such-n-such
field can not have a string length of 0. I checked the database, none
of the fields are required in the database itself, and I have tried
making the non-required fields cfinserts too with required="no" and
this does not work either.
I am having the same problem with text areas.
PS
I have updated my e-mail address in the profile on the dfwcfug home
page, but I have yet to recieve mail at my new address. Is there
something else I needed to have done?
=====
Veni, Vedi, Velcro.
I came, I saw, I stuck with it.
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org