5 Replies Latest reply on Sep 7, 2009 10:28 PM by Adam Cameron.

    Javascript calendar does not save date...HELP!!!!!!

    emartek1 Level 1

      This form is driving me crazy!!!! This is the third time I have had to request help from this forum while trying to finish one simple form. The input calendar appears to work correctly but no date is saved in my database. Anyone have any suggestions...this thing is grinding me to a halt. Thanks in advance!!!

       

      Here is the code:

       

      <cfinclude template="mp_ck_auth1.cfm">

      <cfquery name="CheckUser" datasource="manna_premier">
      SELECT *
      FROM  Users
      WHERE UserID  = #Session.UserID#
      </cfquery>

      <html>
      <head>

      <style type="text/css">

      .ds_box {
      background-color: #FFF;
      border: 1px solid #000;
      position: absolute;
      z-index: 32767;
      }

      .ds_tbl {
      background-color: #FFF;
      }

      .ds_head {
      background-color: #333;
      color: #FFF;
      font-family: Arial, Helvetica, sans-serif;
      font-size: 13px;
      font-weight: bold;
      text-align: center;
      letter-spacing: 2px;
      }

      .ds_subhead {
      background-color: #CCC;
      color: #000;
      font-size: 12px;
      font-weight: bold;
      text-align: center;
      font-family: Arial, Helvetica, sans-serif;
      width: 32px;
      }

      .ds_cell {
      background-color: #EEE;
      color: #000;
      font-size: 13px;
      text-align: center;
      font-family: Arial, Helvetica, sans-serif;
      padding: 5px;
      cursor: pointer;
      }

      .ds_cell:hover {
      background-color: #F3F3F3;
      } /* This hover code won't work for IE */

      </style>
      </head>
      <title>Manna Pro Products, LLC</title>
      <body>

      <table class="ds_box" cellpadding="0" cellspacing="0" id="ds_conclass" style="display: none;">
      <tr><td id="ds_calclass">
      </td></tr>
      </table>

      <script type="text/javascript">
      // <!-- <![CDATA[

      // Project: Dynamic Date Selector (DtTvB) - 2006-03-16
      // Script featured on JavaScript Kit- http://www.javascriptkit.com
      // Code begin...
      // Set the initial date.
      var ds_i_date = new Date();
      ds_c_month = ds_i_date.getMonth() + 1;
      ds_c_year = ds_i_date.getFullYear();

      // Get Element By Id
      function ds_getel(id) {
      return document.getElementById(id);
      }

      // Get the left and the top of the element.
      function ds_getleft(el) {
      var tmp = el.offsetLeft;
      el = el.offsetParent
      while(el) {
        tmp += el.offsetLeft;
        el = el.offsetParent;
      }
      return tmp;
      }
      function ds_gettop(el) {
      var tmp = el.offsetTop;
      el = el.offsetParent
      while(el) {
        tmp += el.offsetTop;
        el = el.offsetParent;
      }
      return tmp;
      }

      // Output Element
      var ds_oe = ds_getel('ds_calclass');
      // Container
      var ds_ce = ds_getel('ds_conclass');

      // Output Buffering
      var ds_ob = '';
      function ds_ob_clean() {
      ds_ob = '';
      }
      function ds_ob_flush() {
      ds_oe.innerHTML = ds_ob;
      ds_ob_clean();
      }
      function ds_echo(t) {
      ds_ob += t;
      }

      var ds_element; // Text Element...

      var ds_monthnames = [
      'January', 'February', 'March', 'April', 'May', 'June',
      'July', 'August', 'September', 'October', 'November', 'December'
      ]; // You can translate it for your language.

      var ds_daynames = [
      'Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat'
      ]; // You can translate it for your language.

      // Calendar template
      function ds_template_main_above(t) {
      return '<table cellpadding="3" cellspacing="1" class="ds_tbl">'
            + '<tr>'
         + '<td class="ds_head" style="cursor: pointer" onclick="ds_py();">&lt;&lt;</td>'
         + '<td class="ds_head" style="cursor: pointer" onclick="ds_pm();">&lt;</td>'
         + '<td class="ds_head" style="cursor: pointer" onclick="ds_hi();" colspan="3">[Close]</td>'
         + '<td class="ds_head" style="cursor: pointer" onclick="ds_nm();">&gt;</td>'
         + '<td class="ds_head" style="cursor: pointer" onclick="ds_ny();">&gt;&gt;</td>'
         + '</tr>'
            + '<tr>'
         + '<td colspan="7" class="ds_head">' + t + '</td>'
         + '</tr>'
         + '<tr>';
      }

      function ds_template_day_row(t) {
      return '<td class="ds_subhead">' + t + '</td>';
      // Define width in CSS, XHTML 1.0 Strict doesn't have width property for it.
      }

      function ds_template_new_week() {
      return '</tr><tr>';
      }

      function ds_template_blank_cell(colspan) {
      return '<td colspan="' + colspan + '"></td>'
      }

      function ds_template_day(d, m, y) {
      return '<td class="ds_cell" onclick="ds_onclick(' + d + ',' + m + ',' + y + ')">' + d + '</td>';
      // Define width the day row.
      }

      function ds_template_main_below() {
      return '</tr>'
            + '</table>';
      }

      // This one draws calendar...
      function ds_draw_calendar(m, y) {
      // First clean the output buffer.
      ds_ob_clean();
      // Here we go, do the header
      ds_echo (ds_template_main_above(ds_monthnames[m - 1] + ' ' + y));
      for (i = 0; i < 7; i ++) {
        ds_echo (ds_template_day_row(ds_daynames[i]));
      }
      // Make a date object.
      var ds_dc_date = new Date();
      ds_dc_date.setMonth(m - 1);
      ds_dc_date.setFullYear(y);
      ds_dc_date.setDate(1);
      if (m == 1 || m == 3 || m == 5 || m == 7 || m == 8 || m == 10 || m == 12) {
        days = 31;
      } else if (m == 4 || m == 6 || m == 9 || m == 11) {
        days = 30;
      } else {
        days = (y % 4 == 0) ? 29 : 28;
      }
      var first_day = ds_dc_date.getDay();
      var first_loop = 1;
      // Start the first week
      ds_echo (ds_template_new_week());
      // If sunday is not the first day of the month, make a blank cell...
      if (first_day != 0) {
        ds_echo (ds_template_blank_cell(first_day));
      }
      var j = first_day;
      for (i = 0; i < days; i ++) {
        // Today is sunday, make a new week.
        // If this sunday is the first day of the month,
        // we've made a new row for you already.
        if (j == 0 && !first_loop) {
         // New week!!
         ds_echo (ds_template_new_week());
        }
        // Make a row of that day!
        ds_echo (ds_template_day(i + 1, m, y));
        // This is not first loop anymore...
        first_loop = 0;
        // What is the next day?
        j ++;
        j %= 7;
      }
      // Do the footer
      ds_echo (ds_template_main_below());
      // And let's display..
      ds_ob_flush();
      // Scroll it into view.
      ds_ce.scrollIntoView();
      }

      // A function to show the calendar.
      // When user click on the date, it will set the content of t.
      function ds_sh(t) {
      // Set the element to set...
      ds_element = t;
      // Make a new date, and set the current month and year.
      var ds_sh_date = new Date();
      ds_c_month = ds_sh_date.getMonth() + 1;
      ds_c_year = ds_sh_date.getFullYear();
      // Draw the calendar
      ds_draw_calendar(ds_c_month, ds_c_year);
      // To change the position properly, we must show it first.
      ds_ce.style.display = '';
      // Move the calendar container!
      the_left = ds_getleft(t);
      the_top = ds_gettop(t) + t.offsetHeight;
      ds_ce.style.left = the_left + 'px';
      ds_ce.style.top = the_top + 'px';
      // Scroll it into view.
      ds_ce.scrollIntoView();
      }

      // Hide the calendar.
      function ds_hi() {
      ds_ce.style.display = 'none';
      }

      // Moves to the next month...
      function ds_nm() {
      // Increase the current month.
      ds_c_month ++;
      // We have passed December, let's go to the next year.
      // Increase the current year, and set the current month to January.
      if (ds_c_month > 12) {
        ds_c_month = 1;
        ds_c_year++;
      }
      // Redraw the calendar.
      ds_draw_calendar(ds_c_month, ds_c_year);
      }

      // Moves to the previous month...
      function ds_pm() {
      ds_c_month = ds_c_month - 1; // Can't use dash-dash here, it will make the page invalid.
      // We have passed January, let's go back to the previous year.
      // Decrease the current year, and set the current month to December.
      if (ds_c_month < 1) {
        ds_c_month = 12;
        ds_c_year = ds_c_year - 1; // Can't use dash-dash here, it will make the page invalid.
      }
      // Redraw the calendar.
      ds_draw_calendar(ds_c_month, ds_c_year);
      }

      // Moves to the next year...
      function ds_ny() {
      // Increase the current year.
      ds_c_year++;
      // Redraw the calendar.
      ds_draw_calendar(ds_c_month, ds_c_year);
      }

      // Moves to the previous year...
      function ds_py() {
      // Decrease the current year.
      ds_c_year = ds_c_year - 1; // Can't use dash-dash here, it will make the page invalid.
      // Redraw the calendar.
      ds_draw_calendar(ds_c_month, ds_c_year);
      }

      // Format the date to output.
      function ds_format_date(d, m, y) {
      // 2 digits month.
      m2 = '00' + m;
      m2 = m2.substr(m2.length - 2);
      // 2 digits day.
      d2 = '00' + d;
      d2 = d2.substr(d2.length - 2);
      // YYYY-MM-DD
      return y + '-' + m2 + '-' + d2;
      }

      // When the user clicks the day.
      function ds_onclick(d, m, y) {
      // Hide the calendar.
      ds_hi();
      // Set the value of it, if we can.
      if (typeof(ds_element.value) != 'undefined') {
        ds_element.value = ds_format_date(d, m, y);
      // Maybe we want to set the HTML in it.
      } else if (typeof(ds_element.innerHTML) != 'undefined') {
        ds_element.innerHTML = ds_format_date(d, m, y);
      // I don't know how should we display it, just alert it to user.
      } else {
        alert (ds_format_date(d, m, y));
      }
      }

      // And here is the end.

      // ]]> -->
      </script>

       

      <style type="text/css">
      <!--
      .style1 {
      font-family: "Arial Black";
      font-size: 18px;
      font-weight: bold;
      }
      .style2 {font-size: 24px}
      .style7 {font-size: 18px; font-family: Tahoma; }
      .style8 {font-family: Tahoma}
      -->
      </style>

      <style type="text/css">
      <!--
      body {
      background-image: url();
      background-repeat: no-repeat;
      margin-left: 0px;
      margin-top: 0px;
      }
      a:link {
      text-decoration: none;
      }
      a:visited {
      text-decoration: none;
      }
      a:hover {
      text-decoration: none;
      }
      a:active {
      text-decoration: none;
      }
      .style12 {font-size: 12}
      .style15 {
      font-size: 14px;
      font-weight: bold;
      }
      .style16 {font-size: 12px}
      .style17 {font-size: 18px}
      -->
      </style>


      <table align="center" width="755" background="images/manna_premier_bg.jpg" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="27%">
            <table border="0" cellpadding="0" cellspacing="0" width="159">
      <!-- fwtable fwsrc="manna_premier_menu.png" fwbase="manna_premier_menu.jpg" fwstyle="Dreamweaver" fwdocid = "90849735" fwnested="0" -->
        <tr>
         <td><img src="images/spacer.gif" width="4" height="1" border="0" alt="" /></td>
         <td><img src="images/spacer.gif" width="7" height="1" border="0" alt="" /></td>
         <td><img src="images/spacer.gif" width="36" height="1" border="0" alt="" /></td>
         <td><img src="images/spacer.gif" width="54" height="1" border="0" alt="" /></td>
         <td><img src="images/spacer.gif" width="2" height="1" border="0" alt="" /></td>
         <td><img src="images/spacer.gif" width="21" height="1" border="0" alt="" /></td>
         <td><img src="images/spacer.gif" width="21" height="1" border="0" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="1" border="0" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="1" border="0" alt="" /></td>
         <td><img src="images/spacer.gif" width="8" height="1" border="0" alt="" /></td>
         <td><img src="images/spacer.gif" width="4" height="1" border="0" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="1" border="0" alt="" /></td>
        </tr>

        <tr>
         <td colspan="11"><img name="manna_premier_menu_r1_c1" src="images/manna_premier_menu_r1_c1.jpg" width="159" height="86" border="0" id="manna_premier_menu_r1_c1" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="86" border="0" alt="" /></td>
        </tr>
        <tr>
         <td rowspan="14" colspan="2"><img name="manna_premier_menu_r2_c1" src="images/manna_premier_menu_r2_c1.jpg" width="11" height="463" border="0" id="manna_premier_menu_r2_c1" alt="" /></td>
         <td colspan="4"><a href="mp_imagelibrary.cfm" target="_self" onClick="MM_nbGroup('down','navbar1','manna_premier_menu_r2_c3','images/manna_premier_men u_r2_c3_f3.jpg',1);" onMouseOver="MM_nbGroup('over','manna_premier_menu_r2_c3','images/manna_premier_menu_r2_c 3_f2.jpg','images/manna_premier_menu_r2_c3_f4.jpg',1);" onMouseOut="MM_nbGroup('out');"><img name="manna_premier_menu_r2_c3" src="images/manna_premier_menu_r2_c3.jpg" width="113" height="12" border="0" id="manna_premier_menu_r2_c3" alt="" /></a></td>
         <td rowspan="4" colspan="5"><img name="manna_premier_menu_r2_c7" src="images/manna_premier_menu_r2_c7.jpg" width="35" height="68" border="0" id="manna_premier_menu_r2_c7" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="12" border="0" alt="" /></td>
        </tr>
        <tr>
         <td colspan="4"><img name="manna_premier_menu_r3_c3" src="images/manna_premier_menu_r3_c3.jpg" width="113" height="22" border="0" id="manna_premier_menu_r3_c3" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="22" border="0" alt="" /></td>
        </tr>
        <tr>
         <td colspan="2"><a href="mpremier_whatsnew.cfm" target="_self" onClick="MM_nbGroup('down','navbar1','manna_premier_menu_r4_c3','images/manna_premier_men u_r4_c3_f3.jpg',1);" onMouseOver="MM_nbGroup('over','manna_premier_menu_r4_c3','images/manna_premier_menu_r4_c 3_f2.jpg','images/manna_premier_menu_r4_c3_f3.jpg',1);" onMouseOut="MM_nbGroup('out');"><img name="manna_premier_menu_r4_c3" src="images/manna_premier_menu_r4_c3.jpg" width="90" height="12" border="0" id="manna_premier_menu_r4_c3" alt="" /></a></td>
         <td rowspan="2" colspan="2"><img name="manna_premier_menu_r4_c5" src="images/manna_premier_menu_r4_c5.jpg" width="23" height="34" border="0" id="manna_premier_menu_r4_c5" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="12" border="0" alt="" /></td>
        </tr>
        <tr>
         <td colspan="2"><img name="manna_premier_menu_r5_c3" src="images/manna_premier_menu_r5_c3.jpg" width="90" height="22" border="0" id="manna_premier_menu_r5_c3" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="22" border="0" alt="" /></td>
        </tr>
        <tr>
         <td colspan="6"><a href="mp_open_promos.cfm" target="_self" onClick="MM_nbGroup('down','navbar1','manna_premier_menu_r6_c3','images/manna_premier_men u_r6_c3_f3.jpg',1);" onMouseOver="MM_nbGroup('over','manna_premier_menu_r6_c3','images/manna_premier_menu_r6_c 3_f2.jpg','images/manna_premier_menu_r6_c3_f3.jpg',1);" onMouseOut="MM_nbGroup('out');"><img name="manna_premier_menu_r6_c3" src="images/manna_premier_menu_r6_c3.jpg" width="135" height="12" border="0" id="manna_premier_menu_r6_c3" alt="" /></a></td>
         <td rowspan="2" colspan="3"><img name="manna_premier_menu_r6_c9" src="images/manna_premier_menu_r6_c9.jpg" width="13" height="34" border="0" id="manna_premier_menu_r6_c9" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="12" border="0" alt="" /></td>
        </tr>
        <tr>
         <td colspan="6"><img name="manna_premier_menu_r7_c3" src="images/manna_premier_menu_r7_c3.jpg" width="135" height="22" border="0" id="manna_premier_menu_r7_c3" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="22" border="0" alt="" /></td>
        </tr>
        <tr>
         <td colspan="7"><a href="mp_events.cfm" target="_self" onClick="MM_nbGroup('down','navbar1','manna_premier_menu_r8_c3','images/manna_premier_men u_r8_c3_f3.jpg',1);" onMouseOver="MM_nbGroup('over','manna_premier_menu_r8_c3','images/manna_premier_menu_r8_c 3_f2.jpg','images/manna_premier_menu_r8_c3_f4.jpg',1);" onMouseOut="MM_nbGroup('out');"><img name="manna_premier_menu_r8_c3" src="images/manna_premier_menu_r8_c3.jpg" width="136" height="12" border="0" id="manna_premier_menu_r8_c3" alt="" /></a></td>
         <td rowspan="8" colspan="2"><img name="manna_premier_menu_r8_c10" src="images/manna_premier_menu_r8_c10.jpg" width="12" height="361" border="0" id="manna_premier_menu_r8_c10" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="12" border="0" alt="" /></td>
        </tr>
        <tr>
         <td colspan="7"><img name="manna_premier_menu_r9_c3" src="images/manna_premier_menu_r9_c3.jpg" width="136" height="22" border="0" id="manna_premier_menu_r9_c3" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="22" border="0" alt="" /></td>
        </tr>
        <tr>
         <td colspan="5"><a href="bookings.cfm" target="_self" onMouseOut="MM_nbGroup('out');" onMouseOver="MM_nbGroup('over','manna_premier_menu_r10_c3','images/manna_premier_menu_r10 _c3_f2.jpg','images/manna_premier_menu_r10_c3_f4.jpg',1);" onClick="MM_nbGroup('down','navbar1','manna_premier_menu_r10_c3','images/manna_premier_me nu_r10_c3_f3.jpg',1);"><img name="manna_premier_menu_r10_c3" src="images/manna_premier_menu_r10_c3.jpg" width="134" height="12" border="0" id="manna_premier_menu_r10_c3" alt="" /></a></td>
         <td rowspan="6" colspan="2"><img name="manna_premier_menu_r10_c8" src="images/manna_premier_menu_r10_c8.jpg" width="2" height="327" border="0" id="manna_premier_menu_r10_c8" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="12" border="0" alt="" /></td>
        </tr>
        <tr>
         <td colspan="5"><img name="manna_premier_menu_r11_c3" src="images/manna_premier_menu_r11_c3.jpg" width="134" height="22" border="0" id="manna_premier_menu_r11_c3" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="22" border="0" alt="" /></td>
        </tr>
        <tr>
         <td><a href="mpremier_faq.cfm" target="_self"><img name="manna_premier_menu_r12_c3" src="images/manna_premier_menu_r12_c3.jpg" width="36" height="12" border="0" id="manna_premier_menu_r12_c3" alt="" /></a></td>
         <td rowspan="2" colspan="4"><img name="manna_premier_menu_r12_c4" src="images/manna_premier_menu_r12_c4.jpg" width="98" height="34" border="0" id="manna_premier_menu_r12_c4" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="12" border="0" alt="" /></td>
        </tr>
        <tr>
         <td><img name="manna_premier_menu_r13_c3" src="images/manna_premier_menu_r13_c3.jpg" width="36" height="22" border="0" id="manna_premier_menu_r13_c3" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="22" border="0" alt="" /></td>
        </tr>
        <tr>
         <td colspan="3"><a href="mpremier_contact.cfm" target="_self" onClick="MM_nbGroup('down','navbar1','manna_premier_menu_r14_c3','images/manna_premier_me nu_r14_c3_f3.jpg',1);" onMouseOver="MM_nbGroup('over','manna_premier_menu_r14_c3','images/manna_premier_menu_r14 _c3_f2.jpg','images/manna_premier_menu_r14_c3_f4.jpg',1);" onMouseOut="MM_nbGroup('out');"><img name="manna_premier_menu_r14_c3" src="images/manna_premier_menu_r14_c3.jpg" width="92" height="12" border="0" id="manna_premier_menu_r14_c3" alt="" /></a></td>
         <td rowspan="2" colspan="2"><img name="manna_premier_menu_r14_c6" src="images/manna_premier_menu_r14_c6.jpg" width="42" height="259" border="0" id="manna_premier_menu_r14_c6" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="12" border="0" alt="" /></td>
        </tr>
        <tr>
         <td colspan="3"><img name="manna_premier_menu_r15_c3" src="images/manna_premier_menu_r15_c3.jpg" width="92" height="247" border="0" id="manna_premier_menu_r15_c3" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="247" border="0" alt="" /></td>
        </tr>
        <tr>
         <td rowspan="2"><img name="manna_premier_menu_r16_c1" src="images/manna_premier_menu_r16_c1.jpg" width="4" height="42" border="0" id="manna_premier_menu_r16_c1" alt="" /></td>
         <td colspan="9"><a href="mpremier_main.cfm" target="_self" onClick="MM_nbGroup('down','navbar1','manna_premier_menu_r16_c2','images/manna_premier_me nu_r16_c2_f3.jpg',1);" onMouseOver="MM_nbGroup('over','manna_premier_menu_r16_c2','images/manna_premier_menu_r16 _c2_f2.jpg','images/manna_premier_menu_r16_c2_f4.jpg',1);" onMouseOut="MM_nbGroup('out');"><img name="manna_premier_menu_r16_c2" src="images/manna_premier_menu_r16_c2.jpg" width="151" height="36" border="0" id="manna_premier_menu_r16_c2" alt="" /></a></td>
         <td rowspan="2"><img name="manna_premier_menu_r16_c11" src="images/manna_premier_menu_r16_c11.jpg" width="4" height="42" border="0" id="manna_premier_menu_r16_c11" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="36" border="0" alt="" /></td>
        </tr>
        <tr>
         <td colspan="9"><img name="manna_premier_menu_r17_c2" src="images/manna_premier_menu_r17_c2.jpg" width="151" height="6" border="0" id="manna_premier_menu_r17_c2" alt="" /></td>
         <td><img src="images/spacer.gif" width="1" height="6" border="0" alt="" /></td>
        </tr>
      </table></td>
          <td width="73%" valign="top">  <table border="0" align="center" cellpadding="0" cellspacing="0">
            <tr>
              <td colspan="3"><div align="center" class="style2 style1">TERRiTORY MANAGER STATUS </div></td>
              </tr>
            <tr>
              <td colspan="3" valign="top"><cfoutput query="CheckUser"><div align="center">
                  <div align="center"><span class="style7">Welcome back #UserFirstName# #UserLastName#!
                    Your last login was #DateFormat(LastLogin, "mmm dd, yyyy")# at #TimeFormat(LastLogin, "h:mm tt")# PST.
                    You have logged into the site a total of #TotalLogins# times.</span></div>
              </cfoutput>
      <cfform method="post" action="log_entry.cfm">
        <div align="center"><cfoutput>
          <input type="hidden" name="LogDate" value="#DateFormat(Now(), "mm/dd/yyyy")#">
        </cfoutput>
          <table width="525" border="0" align="center" cellpadding="0" cellspacing="0">
            <tr>
              <td width="177" align="left" class="style8 style15">Territory Manager: </td>
                          <td width="363" height="16" align="left"><span class="style12">
                            <label><cfoutput query="CheckUser">
                              <input name="TerritoryManager" type="text" id="TerritoryManager" value="#UserFirstName# #UserLastName#" />
                              </label>
                          </span></cfoutput></td>
                        </tr>
            <tr>
              <td align="left" bgcolor="#CCCCCC" class="style8 style15">Status:</td>
                          <td height="20" bgcolor="#CCCCCC" class="style12">
                          <label></label>                    </td>
                        </tr>
            <tr>
              <td align="left" class="style8 style16"><strong>
                <input name="Status" type="radio" value="In the Field" />
                In the Field </strong></td>
                          <td class="style12">
                            <label></label>                    </td>
                        </tr>
            <tr>
              <td align="left" bgcolor="#CCCCCC" class="style8 style16"><strong>
                <input name="Status" type="radio" value="Vacation" />
                Vacation</strong></td>
                          <td bgcolor="#CCCCCC"> </td>
                        </tr>
            <tr>
              <td align="left"><blockquote>
                <p class="style16 style8"><strong>Start date:
                  </strong></p>
                          </blockquote>                 </td>
                          <td align="left"><input type="text" onclick="ds_sh(this);" name="VacStart" style="cursor: text" /></td>
                        </tr>
            <tr>
              <td align="left"><blockquote>
                <p class="style16 style8"><strong>End date:
                  </strong></p>
                          </blockquote>                      </td>
                          <td align="left">"><input type="text" onclick="ds_sh(this);" name="VacEnd" style="cursor: text" /></td>
                        </tr>
            <tr>
              <td align="left" class="style8 style16"><strong>
                <label>
                  <input name="Status" type="radio" value="Sick day" />
                  </label>
                Sick Day </strong></td>
                          <td> </td>
                        </tr>
            <tr>
              <td align="left" class="style8 style16"><strong>
                <label>
                  <input name="Status" type="radio" value="Admin Day" />
                  </label>
                Admin Day </strong></td>
                          <td> </td>
                        </tr>
            <tr>
              <td align="left" class="style8 style16"><strong>
                <input name="Status" type="radio" value="DSR Ride Along" />
                DSR Ride Along </strong></td>
                          <td align="left"><label>
                            <input name="DSRName" type="text" id="DSRName" />
                          </label></td>
                        </tr>
            <tr>
              <td align="left" class="style8 style16"><strong>
                <label>
                  <input name="Status" type="radio" value="ServiceCall" />
                  </label>
                Service Calls </strong></td>
                          <td align="left"><label>
                            <input type="text" name="ServiceName" />
                          </label></td>
                        </tr>
            <tr>
              <td align="left"> </td>
                          <td align="left"> </td>
                        </tr>
            <tr>
              <td colspan="2" align="center"><label>
                <input type="submit" value="Submit" />
                </label>
                <label>
                  <input type="reset" value="Reset" />
                  </label></td>
                        </tr>
          </table>
        </div>
      </cfform>
                <p align="center" class="style7"><br />
                  <a href="TM_launch.html" target="_self">Continue without updating status. </a></p>
              </div></td>
              </tr>
            <tr>
              <td colspan="3"><p> </p>
                  <p> </p>            <p> </p></td>
              </tr>
            <tr>
              <td colspan="3" bordercolor="#000000"> </td>
              </tr>
            <tr valign="top">
              <td colspan="3"><div align="center" class="style8"></div></td>
              </tr>
            <tr>
              <td> </td>
                  <td> </td>
                  <td> </td>
              </tr>
          </table></td>
        </tr>
      </table>
      </body>
      </html>

        • 1. Re: Javascript calendar does not save date...HELP!!!!!!
          Adam Cameron. Level 5

          Your posting too much code: people are not going to want to wade through all that to locate which bits your having problems with.  Almost all of that stuff you posted is irrelevant to your problem, and is just clutter.

           

          Also, for your own troubleshooting, just create a simple form with only the bit you're having trouble with, and get it working there, then integrate it back into your actual solution.  Having a minimum of "moving parts" will focus you.

           

          Strip down your test rig to just a form with a calendar control (and the relevant form-processing code), and start from there.

           

          --

          Adam

          • 2. Re: Javascript calendar does not save date...HELP!!!!!!
            emartek1 Level 1

            Sorry Adam...I had thought that perhaps the javascript would be necessary but I totally understand what you are saying. I took your advice and scaled down the code to try to figure this out but to no avail. Every other field in this form saves correctly but the date fields for vacation start and end will not record. Here is the code for the form only...PLEASE SOMEONE END MY PAIN!!!!

             

              <form method="post" action="log_entry.cfm">
              <div align="center"><cfoutput>
                <input type="hidden" name="LogDate" value="#DateFormat(Now(), "mm/dd/yyyy")#">
              </cfoutput>
                <table width="525" border="0" align="center" cellpadding="0" cellspacing="0">
                  <tr>
                    <td width="177" align="left" class="style8 style15">Territory Manager: </td>
                                <td width="363" height="16" align="left"><span class="style12">
                                  <label><cfoutput query="CheckUser">
                                    <input name="TerritoryManager" type="text" id="TerritoryManager" value="#UserFirstName# #UserLastName#" />
                                    </label>
                                </span></cfoutput></td>
                              </tr>
                  <tr>
                    <td align="left" bgcolor="#CCCCCC" class="style8 style15">Status:</td>
                                <td height="20" bgcolor="#CCCCCC" class="style12">
                                <label></label>                    </td>
                              </tr>
                  <tr>
                    <td align="left" class="style8 style16"><strong>
                      <input name="Status" type="radio" value="In the Field" />
                      In the Field </strong></td>
                                <td class="style12">
                                  <label></label>                    </td>
                              </tr>
                  <tr>
                    <td align="left" bgcolor="#CCCCCC" class="style8 style16"><strong>
                      <input name="Status" type="radio" value="Vacation" />
                      Vacation</strong></td>
                                <td bgcolor="#CCCCCC"> </td>
                              </tr>
                  <tr>
                    <td align="left"><blockquote>
                      <p class="style16 style8"><strong>Start date:
                        </strong></p>
                                </blockquote>                 </td>
                                <td align="left"><input onclick="ds_sh(this);" name="VacStart" style="cursor: text" /></td>
                              </tr>
                  <tr>
                    <td align="left"><blockquote>
                      <p class="style16 style8"><strong>End date:
                        </strong></p>
                                </blockquote>                      </td>
                                <td align="left"><input onclick="ds_sh(this);" name="VacEnd" style="cursor: text" /></td>
                              </tr>
                  <tr>
                    <td align="left" class="style8 style16"><strong>
                      <label>
                        <input name="Status" type="radio" value="Sick day" />
                        </label>
                      Sick Day </strong></td>
                                <td> </td>
                              </tr>
                  <tr>
                    <td align="left" class="style8 style16"><strong>
                      <label>
                        <input name="Status" type="radio" value="Admin Day" />
                        </label>
                      Admin Day </strong></td>
                                <td> </td>
                              </tr>
                  <tr>
                    <td align="left" class="style8 style16"><strong>
                      <input name="Status" type="radio" value="DSR Ride Along" />
                      DSR Ride Along </strong></td>
                                <td align="left"><label>
                                  <input name="DSRName" type="text" id="DSRName" />
                                </label></td>
                              </tr>
                  <tr>
                    <td align="left" class="style8 style16"><strong>
                      <label>
                        <input name="Status" type="radio" value="ServiceCall" />
                        </label>
                      Service Calls </strong></td>
                                <td align="left"><label>
                                  <input type="text" name="ServiceName" />
                                </label></td>
                              </tr>
                  <tr>
                    <td align="left"> </td>
                                <td align="left"> </td>
                              </tr>
                  <tr>
                    <td colspan="2" align="center"><label>
                      <input type="submit" value="Submit" />
                      </label>
                      <label>
                        <input type="reset" value="Reset" />
                        </label></td>
                              </tr>
                </table>
              </div>
            </form>

            • 3. Re: Javascript calendar does not save date...HELP!!!!!!
              Adam Cameron. Level 5

              Ah

              See... here's a case in point of why it's good to post as little code as possible (whilst also making sure all the relevant code is posted!  It's a tricky balance sometimes).  I didn't look @ your initial code at all, and didn't notice you've rolled your own calendar control.

               

              Now my first reaction is why you're not using <cfcalendar> for this: http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_c_02.html#3798877 ?

               

              Secondly... I'm not sure what you're asking is actually a ColdFusion question, possibly more a JS or DHTML question.

               

              Still, some thoughts:

              * is your calendar control actually capturing a date value properly on the client side?  IE: when one selects a date, is it a) actually recording a value (can you pop-up an alert() with the correct value); b) is the value going into a form control.  I'm not going to pore over your logic to follow what happens, but at some stage you need to be putting a value into a form field.  I'm guessing it's a hidden one... change it to a text input to make sure it's actually getting populated.

              * is the value making it through to the action page?  Replace your current action code with <cfdump var="#form#"><cfabort>.  Are the dates there?

              * how are you putting the data into the DB?  One bit of code you don't post is the action page.

               

              If there's a problem with the first bullet point above, it's really a JS question not a CF question.

               

              --

              Adam

              • 4. Re: Javascript calendar does not save date...HELP!!!!!!
                emartek1 Level 1

                Adam, when you're right you're right! I have been staring at this code for so long searching for some complicated answer that I neglected to look anywhere else. You got me to look at my action page and voila there was the problem. I wish I would have reviewed the page two days ago but what can you do. Thank you so much for pointing me in the right direction as well as for your advice on how to troubleshoot and post. You and the other experts on this forum are lifesavers and I for one appreciate you taking the time to coach us newbies! Thanks again!

                • 5. Re: Javascript calendar does not save date...HELP!!!!!!
                  Adam Cameron. Level 5

                  Good stuff.

                   

                  Take it easy.

                   

                  --

                  Adam