Update table query won't actually update the table.

 Is startDate a column of type DateTime and does it contain the time as well as the date?

 If so, it will not match just the date.

 That is, if startDate contains  '12/31/2006 12:15 pm' it will not match '12/31/2006'

UPDATE Timeoff
SET Status='#FORM.Status#', Occurrence='#FORM.Occurrence#'
WHERE GlobalID = '#FORM.GlobalID#'
AND Type = '#FORM.Type#'


AND StartDate = '#FORM.StartDate#'

TRY...

AND   dateDiff(D,StartDate , #createODBCdate(form.stateDate)# ) = 0

StartDate is just a date, no time involved. The error I'm getting off of my above code now is: "[Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting the varchar value 'URL.GlobalID' to a column of data type int." This I'm confused by as the GlobalID value is an INT everywhere in the database but I can't get it to leave the URL.GlobalID variable as INT.

Remove the quotes from around the global ID

UPDATE Timeoff
SET Status='#FORM.Status#', Occurrence='#FORM.Occurrence#'
WHERE GlobalID = '#FORM.GlobalID#'
                         ^^^  Remove quotes which make it a string, this would appear as   = '123'  
AND Type = '#FORM.Type#'
AND StartDate = '#FORM.StartDate#'




UPDATE Timeoff
SET Status='#FORM.Status#'
    , Occurrence='#FORM.Occurrence#'
WHERE GlobalID = #val(FORM.GlobalID)#
AND Type = '#FORM.Type#'
<Cfif IsDate(FORM.StartDate)>
AND StartDate = #createODBCdate(FORM.StartDate)#
<cfelse>  AND 1 = 2  --- pull no records
</cfif>


will form.startDate always have a value?
This CFIF statement will ensure that its a date before placing in the where clause
<Cfif IsDate(FORM.StartDate)>
AND StartDate = #createODBCdate(FORM.StartDate)#
<cfelse>   <!---- what to do it its not a date?  Pull No Records or Pull All ? ---->
AND 1 = 2  --- pull no records
</cfif>

Thanks for replying.

I made the change as above:

UPDATE Timeoff
SET Status='#FORM.Status#', Occurrence='#FORM.Occurrence#'
WHERE GlobalID = #val(FORM.GlobalID)#
AND Type = '#FORM.Type#'
AND StartDate = '#FORM.StartDate#'

I've made all the URL.GlobalID variables #val(URL.GlobalID)# in the form and now when I click on the link, this page pops up as it should. I've got it displaying the URL Variables as it should and they look fine. When I click the submit button the form processes, closes the window, and refreshes the parent window like it should but does not update the Status or Occurrence portions of the database. It doesn't change anything in the db.

The code as it stands now:

<cfset title = "Time Off Admin">
<cfinclude template="/unisys/includes/header_style.cfm">
<!--- Take values from Mypage and query database with them --->
<!--- End Take values from Mypage and query database with them --->
<!--- Check if form is submitted and process --->
<cfif IsDefined('form.timeoff')>
            <cfquery datasource="csc">
            UPDATE Timeoff
            SET Status='#FORM.Status#', Occurrence='#FORM.Occurrence#'
            WHERE GlobalID = #val(FORM.GlobalID)#
            AND Type = '#FORM.Type#'
            AND StartDate = '#FORM.StartDate#'
            </cfquery>
                              <!---<cfif #FORM.Status# IS "Denied">
                                    <cfmail to="#getInfo.Email#" from="Service Desk Supervisors" subject="Your #getInfo.Type# request for #getInfo.StartDate# to #getInfo.EndDate# has been #FORM.Status#" type="html">
                                    Your request has been #FORM.Status# for the following reasons:<br />
                                    #FORM.Reason#
                                    </cfmail>
                              <cfelseif #FORM.Status# IS "Approved">
                                    <cfmail to="#getInfo.Email#" from="Service Desk Supervisors" subject="Your #getInfo.Type# request for #getInfo.StartDate# to #getInfo.EndDate# has been #FORM.Status#" type="html">
                                    Your request has been #FORM.Status# and is on the calendar.<br />
                                    </cfmail>
                              </cfif>--->
                        <script language="javascript" type="text/javascript">
                        opener.window.location.reload();
                        self.close();
                        </script>
<cfelse>
            <cfquery datasource="csc" name="getInfo">
            SELECT *
            FROM Timeoff
            WHERE GlobalID = #val(URL.GlobalID)#
            AND Type = '#URL.Type#'
            AND StartDate = '#URL.StartDate#'
            </cfquery>
                        <cfoutput>
                        #URL.GlobalID#<br />
                        #URL.Type#<br />
                        #URL.StartDate#<br />
                        </cfoutput>
                        <form action="<cfoutput>#CGI.SCRIPT_NAME#</cfoutput>" method="post">
                        <select name="Status" size="1">
                        <option value="Approved">Approved</option>
                        <option value="Denied">Denied</option>
                        </select><br />
                        Occurrence: <input type="text" name="Occurrence" /><br />
                        If request is denied, submit reason:<br />
                        <textarea name="Reason" cols="80%" rows="10"></textarea>
                        <input type="hidden" name="GlobalID" value="#val(URL.GlobalID)#" />
                        <input type="hidden" name="Type" value="#URL.Type#" />
                        <input type="hidden" name="StartDate" value="#URL.StartDate#" />
                        <input type="submit" name="timeoff" value="Approve / Deny Request" class="submitbutton" />
                        </form>
</cfif>
<!--- End Check if form is submitted and process --->

 Turn on your coldfusion debugging view and see what the Update statement looks like as it is passed to the database.

 You can cut and paste the update statement directly into SQL server's query analyer page to see what happens when you run it without the whole coldfusion page.

  You can also cut and paste that update statement in here so we can see it...

Here is the query from when the variables are passed:

getInfo (Datasource=csc, Time=0ms, Records=1) in C:\CFusionMX7\wwwroot\supervisor\timeoff_admin.cfm @ 12:16:28.028

            SELECT *
            FROM Timeoff
            WHERE GlobalID = 2037503
            AND Type = 'Vacation'
            AND StartDate = '11/01/2006'
            

Here is the query from when the form is processed:

 (Datasource=csc, Time=0ms, Records=0) in C:\CFusionMX7\wwwroot\supervisor\timeoff_admin.cfm @ 12:17:52.052

            UPDATE Timeoff
            SET Status='Approved', Occurrence=''
            WHERE GlobalID = 0
            AND Type = '#URL.Type#'
            AND StartDate = '#URL.StartDate#'

I do see the problem, but I don't rightly see the solution. It's losing the variables somehow after the form is processed. Any thoughts?

I can't tell you how embarrassed I am that I missed something like that! But I'm glad to know it wasn't something more serious. Points Awarded!