Date Validation

Report · Jun 24, 2009

I am trying to validate the date in this application. If the user does not enter a date, it throws an exception but does not return an error message, and the record insert into the DB2 database does not occur. The database date field defaults to today's date. Any suggestions on why this is not working, or how to accomplish this? Code examples are greatly appreciated.

Thank you,

Jeanne

____________________________________________________

<html>
<head>
<title>CAF Survey Form</title>
<style type="text/css">

</style>
</head>
<body bgcolor="#CCFFFF"><span class="style1">
<h2 align="center">Enter a CAF Survey Form</h2><br>

Date:
<cfinput type="datefield" name="SURVEY_DATE" size="10" maxlength="10" validateat="onBlur" validate="required,date" message="Please enter a date!"> <br><br><br>

Branch:
<cfinput type="text" name="BRANCH" size="4" maxlength="4"><br><br><br>

1. Did you get what you needed today?
<cfinput type="radio" name="NEED_FLG" id="radio" value="Y">Yes
<cfinput type="radio" name="NEED_FLG" id="radio" value="N">No
<cfinput type="radio" name="NEED_FLG" id="radio" value="X" checked>Did Not Answer<br><br>

If not, please explain:
<cftextarea name="NEED_COMMENT" wrap="virtual" rows="5" cols="25"
validate="maxlength" validateAt="onBlur" maxlength="200" onKeyDown="limitText('comments','countdown_comments',200)">
</cftextarea><br><br><br>

2. Did you receive information about other community resources?
<cfinput type="radio" name="RESOURCE_FLG" id="radio" value="Y">Yes
<cfinput type="radio" name="RESOURCE_FLG" id="radio" value="N">No
<cfinput type="radio" name="RESOURCE_FLG" id="radio" value="X" checked>Did Not Answer<br><br><br>

3. How long did you wait in the office to be seen today?              Minutes     Hours
   Did Not Answer<br>
<cfinput type="text" name="WAIT_MIN" size="2" maxlength="2" required="no" value="0">
<cfinput type="text" name="WAIT_HRS" size="2" maxlength="2" required="no" value="0">
<cfinput type="checkbox" name="WAIT_FLG" value="X"><br><br><br>

4. How long did it take to get today's appointment??          Hours        Days      Weeks
   Did Not Answer<br>
<cfinput type="text" name="APPT_HRS" size="2" maxlength="2" required="no" value="0">
<cfinput type="text" name="APPT_DAYS" size="2" maxlength="2" required="no" value="0">
<cfinput type="text" name="APPT_WEEKS" size="2" maxlength="2" required="no" value="0">
<cfinput type="checkbox" name="APPT_FLG" value="X"><br><br><br>

5. Did you have enough time during your appointment to <br>
tell your case worker what you wanted or needed?
<cfinput type="radio" name="TIME_FLG" id="radio" value="Y">Yes
<cfinput type="radio" name="TIME_FLG" id="radio" value="N">No
<cfinput type="radio" name="TIME_FLG" id="radio" value="X" checked>Did Not Answer <br><br>

If not, please explain:
<cftextarea name="TIME_COMMENT" wrap="virtual" rows="5" cols="25"
validate="maxlength" validateAt="onBlur" maxlength="200" onKeyDown="limitText('comments','countdown_comments',200)">
</cftextarea><br><br><br>

6. Did you get all of your questions answered?
<cfinput type="radio" name="ANSWERS_FLG" id="radio" value="Y">Yes
<cfinput type="radio" name="ANSWERS_FLG" id="radio" value="N">No
<cfinput type="radio" name="ANSWERS_FLG" id="radio" value="X" checked>Did Not Answer<br><br>

If not, please explain:
<cftextarea name="ANSWERS_COMMENT" wrap="virtual" rows="5" cols="25"
validate="maxlength" validateAt="onBlur" maxlength="200" onKeyDown="limitText('comments','countdown_comments',200)">
</cftextarea><br><br><br>

7. How was the service today?
<cfinput type="radio" name="SERVICE_FLG" id="radio" value="E">Excellent
<cfinput type="radio" name="SERVICE_FLG" id="radio" value="G">Good
<cfinput type="radio" name="SERVICE_FLG" id="radio" value="F">Fair
<cfinput type="radio" name="SERVICE_FLG" id="radio" value="P">Poor
<cfinput type="radio" name="SERVICE_FLG" id="radio" value="X" checked>Did Not Answer<br><br>

Comments:
<cftextarea name="SERVICE_COMMENT" wrap="virtual" rows="5" cols="25"
validate="maxlength" validateAt="onBlur" maxlength="200" onKeyDown="limitText('comments','countdown_comments',200)">
</cftextarea><br><br><br>

8. Would you like to share any other information about your visit today?<br><br>

<cftextarea name="OTHER_INFO" wrap="virtual" rows="5" cols="25"
validate="maxlength" validateAt="onBlur" maxlength="200" onKeyDown="limitText('comments','countdown_comments',200)">
</cftextarea><br><br><br>

9. Are there any unresolved issues that you would <br>
like to have addressed?
<cfinput type="radio" name="UNRESOLVED_FLG" id="radio" value="Y">Yes
<cfinput type="radio" name="UNRESOLVED_FLG" id="radio" value="N">No
<cfinput type="radio" name="UNRESOLVED_FLG" id="radio" value="X" checked>Did Not Answer<br><br><br>

If you would like someone to contact you, please include your name and phone number:<br><br>
Name: <cfinput type="text" name="CONTACT_NAME" size="40" maxlength="40" required="no">
Phone: <cfinput type="text" name="CONTACT_PHONE" size="10" maxlength="10" required="no" validate="telephone" message="Please enter a valid phone number!">

</td>
</table>

</cfform>

</body></span>
</html>

_____________________________________________________________________

<html>
<head> <title>Insert Survey Form</title> </head>
<body>

<cfquery datasource="AXMISC_SURVEY">
   INSERT INTO SURVEY.CAF_SURVEY
   (SURVEY_DATE, BRANCH, NEED_FLG, NEED_COMMENT, RESOURCE_FLG, WAIT_MIN, WAIT_HRS, WAIT_FLG, APPT_HRS, APPT_DAYS, APPT_WEEKS, APPT_FLG, TIME_FLG, TIME_COMMENT, ANSWERS_FLG, ANSWERS_COMMENT, SERVICE_FLG, SERVICE_COMMENT, OTHER_INFO, UNRESOLVED_FLG, CONTACT_NAME, CONTACT_PHONE)
   VALUES
   ( <cfqueryparam cfsqltype="cf_sql_date" value="#form.SURVEY_DATE#">,
     <cfqueryparam cfsqltype="cf_sql_char" value="#form.BRANCH#">,
     <cfqueryparam cfsqltype="cf_sql_char" value="#form.NEED_FLG#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value=#needCom#>,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.RESOURCE_FLG#">,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.WAIT_MIN#">,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.WAIT_HRS#">,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.WAIT_FLG#">,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.APPT_HRS#">,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.APPT_DAYS#">,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.APPT_WEEKS#">,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.APPT_FLG#">,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.TIME_FLG#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value=#timeCom#>,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.ANSWERS_FLG#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value=#answersCom#>,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.SERVICE_FLG#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value=#serviceCom#>,
<cfqueryparam cfsqltype="cf_sql_varchar" value=#otherInfo#>,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.UNRESOLVED_FLG#">,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.CONTACT_NAME#">,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.CONTACT_PHONE#">
   )
</cfquery>

</body>
</html>

Report · Jun 28, 2009

Hi,

try this

<cfquery datasource="AXMISC_SURVEY">
INSERT INTO SURVEY.CAF_SURVEY
(

SURVEY_DATE,

</cfif>

BRANCH,

NEED_FLG, NEED_COMMENT, RESOURCE_FLG, WAIT_MIN, WAIT_HRS, WAIT_FLG, APPT_HRS, APPT_DAYS, APPT_WEEKS, APPT_FLG, TIME_FLG, TIME_COMMENT, ANSWERS_FLG, ANSWERS_COMMENT, SERVICE_FLG, SERVICE_COMMENT, OTHER_INFO, UNRESOLVED_FLG, CONTACT_NAME, CONTACT_PHONE)
VALUES
(

<cfqueryparam cfsqltype="cf_sql_date" value="#form.SURVEY_DATE#">,

</cfif>

Report · Jul 06, 2009

Hi,

I tried the code above to validate the date. I am still getting the same response: it does not insert the record into the DB2 database, and it does not return and error message for the user. I prefer to have the validation occur onBlur (in addition to server side validation), but have not been able to get that to work. Some of the other elements on validated onSubmit.

Thank you for your help,

Jeanne

Report · Jul 10, 2009

HI

It seems like validateat="onblur" wont work if the type is date field

you can try the following

(note that required="yes" is the correct syntax not validate="required")

The above code will work onsubmit

But as you said if you prefer to provide validation onblur you can use js function called on blur

code snippet is as follows

         if(document.getElementById("SURVEY_DATE").value == "")
          {
                     alert("Please enter a date!");
                     document.getElementById("SURVEY_DATE").focus();
          }
}
</script>