ok i have a form which updates my table<form action="update.cfm" method="post">
i need to do a few things when the update btn is clicked.
1. when click i need to put the actual date into my table column
"datelastupdated"
2. then i need the "facilityname" (which is an update field in my form) to be
sent to "Administrator.cfm" also with the "datelastupdated"
so in "Administrator.cfm" there will be a list
"FacilityName" "DateLastUpdated"
"FacilityName" "DateLastUpdated"
"FacilityName" "DateLastUpdated"
3. when it get to "Update.cfm" can i auto redirect to "Admin.cfm"
Many thanks
Craig...

form submit actions

ok i have a form which updates my table<form action="update.cfm" method="post">
i need to do a few things when the update btn is clicked.

1. when click i need to put the actual date into my table column
"datelastupdated"
2. then i need the "facilityname" (which is an update field in my form) to be
sent to "Administrator.cfm" also with the "datelastupdated"

so in "Administrator.cfm" there will be a list
"FacilityName" "DateLastUpdated"
"FacilityName" "DateLastUpdated"
"FacilityName" "DateLastUpdated"

Re: form submit actions

macca2727 wrote:

Should be simple enough--either give that field in your database a
default value of the current date (how you do this will depend on the
specific database you're using), or pass the date in from CF:
<cfqueryparam value="#Now()#" cfsqltype="cf_sql_timestamp" />

The datatype you use (cfsqltype) may be slightly dependent upon your
specific database as well.

Not sure what you mean by "sent to." If all you need is to pull a list
on Administrator.cfm you don't really need to "send" the updates to this
page; rather, you could just run a query when the user hits this page
that pulls this data. Since what you updated just got committed to the
database it would pull the data. (Let me know if I'm not understanding
what you're trying to do.)