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