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

Report · Sep 07, 2009

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:

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

.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>

// 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();"><<</td>'
   + '<td class="ds_head" style="cursor: pointer" onclick="ds_pm();"><</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();">></td>'
   + '<td class="ds_head" style="cursor: pointer" onclick="ds_ny();">>></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));
}
// 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>

<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_menu_r2_c3_f3.jpg',1);" onMouseOver="MM_nbGroup('over','manna_premier_menu_r2_c3','images/manna_premier_menu_r2_c3_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_menu_r4_c3_f3.jpg',1);" onMouseOver="MM_nbGroup('over','manna_premier_menu_r4_c3','images/manna_premier_menu_r4_c3_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_menu_r6_c3_f3.jpg',1);" onMouseOver="MM_nbGroup('over','manna_premier_menu_r6_c3','images/manna_premier_menu_r6_c3_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_menu_r8_c3_f3.jpg',1);" onMouseOver="MM_nbGroup('over','manna_premier_menu_r8_c3','images/manna_premier_menu_r8_c3_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_menu_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_menu_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_menu_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>

Report · Sep 07, 2009

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

Report · Sep 07, 2009

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>

Report · Sep 07, 2009

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

Report · Sep 07, 2009

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!

Report · Sep 07, 2009

Good stuff.

Take it easy.

--

Adam

Adobe Community

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

1 Correct answer