Thanks for the responses.

I tried that but I got the same result.

I also changed the update_process.cfm page to the following...

<cfif isDefined("form.resolution")>

<cfquery name="update_ticket" datasource="helpdesk" dbtype="ODBC">
        update tickets 
        set resolution = '#resolution#', 
            date_closed = '#date_closed#', 
            closed = '#closed#'
            where ticket_id = <cfqueryparam value="#url.ticket_id#"
cfsqltype="cf_sql_numeric">
</cfquery>
</cfif>

But now it doesn't even display the page.

Thanks again for the help.
Scott


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3192
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15

Reply via email to