troubleshooting Question

UPDATE A TABLE IN ACCESS

Avatar of trifecta2k
trifecta2k asked on
Web Servers
41 Comments2 Solutions634 ViewsLast Modified:
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/yyyy")>
<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.gif" 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>
                              &nbsp
                        </cfoutput>
                        
                      <td rowspan="5" width="10" bgcolor="FF8040"><img src="../images/dot_clear.gif" 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>Harrisburg Actual</b></td>
                                        <td align="center"><b>Harrisburg Req</b></td>  
                                    </tr>
                  <CFOUTPUT query="OT" group="Date">
                        <TR class="subheadblue">
                        <TD colspan="6"><b>#dateformat(date,"dddd, 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#</td>                        
                  </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.  
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 41 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 41 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros