I am pretty new to Cold Fusion...
I have created a page that reads from a table in my access database. The table itself has 11 columns. There is an ID, Date, Time, HarAct, HarReq, MemAct, MemReq, RanReq, RanAct, SprReq, and SprAct. Basically the table shows OT requirements and actual OT worked in 4 different call centers. The page I created so far is for Call Center Har. The page has Time, HarAct, and HarReq with ID as a hidden field. The only field the user can update is the HarAct. I have created the form and here is the code:
<!-- BEGIN QUERY SECTION -->
<cfset todaydate = dateformat(now(),"mm/dd/yy
yy")>
<cfquery datasource="harprod" name="OT" Blockfactor="100">
select * from tbl_OT_Requirements where date = ###todaydate###
</cfquery>
<!-- END QUERY SECTION -->
!-- BEGIN USER SECTION -->
<FORM action="OTupdate_post.cfm"
method="POST">
<TABLE width="100%" cellspacing="2" cellpadding="2" border="0">
<TABLE width="100%" cellspacing="2" cellpadding="2" border="0">
<TR>
<td width="200" height="500" bgcolor="FF8040">
<!-- User Menu Section code shown just before the /BODY tag -->
<img src="../images/dot_clear.g
if" width="200" height="500">
</TD>
<TD valign="top">
<!-- BEGIN Employee Profile Section -->
<table width="100%" cellspacing="2" cellpadding="2" border="0">
<tr>
<td colspan="3" width="98%" bgcolor="FF8040" class="smallwhite">
<cfoutput>
 
</cfoutput>
<td rowspan="5" width="10" bgcolor="FF8040"><img src="../images/dot_clear.g
if" width="10" height="100%"></td>
</tr>
<tr>
<td rowspan="2" width="100%" valign="top">
<CFIF UserClass IS "1" OR UserClass IS "5" OR UserClass IS "6" OR UserClass IS "7" OR UserClass IS "9" OR UserClass IS "12">
<table width="100%" cellspacing="2" cellpadding="2" border="0">
<tr>
<td colspan="2" class="headerblue"><b>OT Information</b> </td>
</tr>
</table>
<table bgcolor="6699CC" width="60%" border="0" cellspacing="2" cellpadding="4">
<tr class="tinysilver" bgcolor="333333">
<td align="center"><b>Time</b>
</td>
<td align="center"><b>Harrisbu
rg Actual</b></td>
<td align="center"><b>Harrisbu
rg Req</b></td>
</tr>
<CFOUTPUT query="OT" group="Date">
<TR class="subheadblue">
<TD colspan="6"><b>#dateformat
(date,"ddd
d, mm/dd/yyyy")#</b></TD>
</TR>
<CFOUTPUT>
<!-- Primary Key value indicating record to update. -->
<cfoutput><INPUT TYPE="Hidden" NAME="ID" VALUE="#ID#"></cfoutput>
<tr class="tiny" bgcolor="C0C0C0">
<td align="center">#TimeFormat
(time, "hh:mm tt")#</td>
<td align="center"><INPUT TYPE="Text" NAME="HarAct" VALUE="#Haract#" size="5"></td>
<td align="center">#HarReq#</t
d>
</CFOUTPUT>
</CFOUTPUT>
</tr>
<tr>
<td><INPUT type="submit" value="Edit"></td>
<td><INPUT type="Reset" value="Clear Form"></td> </tr>
</table>
</table>
</form>
When they hit submit i want it to go to an action page that updates my table. I tried using CFUPDATE, CFLOOP and a few other ways but I can't get it to work. Can someone please guide me in the right direction.
