I'm sure this is one of those blatantly simple problems where I'm
overlooking something simple but for the life of me I can't see the
<CF_WOODS_FOR_THE TREES>.
I'm trying to get a database to update from the execution of a link from a
page on our non-CF server that goes via our CF server using this template,
and then back to the non-CF sever. I've tried INSERT INTO and CFUPDATE and
the variation below but none of them update the database - the CFLOCATION
bit does execute OK. There are two other fields in the table, an AutoNumber
field and a DateTime field which has a default value of DATE()+TIME(). Can
this only be achieved coming from a POST?
<CFSET PageName = "Work To Live">
<!--- Update the database --->
<cfinsert datasource="wc_general"
tablename="CorpPlan"
dbtype="ODBC"
formfields="PageName">
<!--- Now relocate the user to the correct page --->
<CFLOCATION url="http://www.workcover.com/worktolive/worktolive.html"
addtoken="No">
********************************
Kevin Parker
Service and Communication
WorkCover Corporation
[EMAIL PROTECTED]
ph: +61 8 82332548
fax: +61 8 82332000
********************************
****************************************************************************
This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.
****************************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.