Not too sure whats going on here But the first thing is to stop using cfupdate.
As a rule try to avoid using cfinsert and cfupdate. Try replacing cfupdate and see if you are still having issues The fact Mike mentions also is very valid, you seem to be trying to check for the existance of ID at the top, but there is no cfif statement(??) hth Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 10 September 2004 08:58 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Update form inconcistent Can anyone shed any light as to why an update page will update 50% of the time but sometimes return the error <TABLE cellSpacing=0 cellPadding=0 width=500 border=0> <TR> <TD id=tableProps2 vAlign=center align=left width=500> <H1 id=textSection1 style="FONT: 13pt/15pt verdana; COLOR: black">Primary key field "ID," not found. </H1></TD></TR> <TR> <TD id=tablePropsWidth width=400 colSpan=2><FONT style="FONT: 8pt/11pt verdana; COLOR: black">The field "ID," was not found in the Form input. This field is required in order to do an UPDATE because it is part of the primary key for the "faith" table. </FONT></TD></TR> <TR> <TD> </TD></TR> <TR> <TD width=400 colSpan=2><FONT style="FONT: 8pt/11pt verdana; COLOR: black"></FONT></TD></TR> <TR> <TD colSpan=2><PRE>5 : <body> 6 : [B]7 : <cfupdate datasource="Weddings" tablename="faith">[/B] 8 : 9 : <h1>Details Updated</h1> </PRE></TD></TR></TABLE> <P>The code is:<BR><BR>[U]UPDATE FORM PAGE<BR>[/U]<BR><html><BR><head><BR><title>update_form< /title><BR><link href="style2.css" rel="stylesheet" type="text/css"><BR></head></P> <P><body></P> <P><cfquery name="update" datasource="Weddings"><BR> SELECT * FROM faith<BR></cfquery></P> <P><BR><cfoutput query="update"></P> <P><table width="100%"><BR><cfform name="update_details" action="update_action.cfm?ID=<cfoutput>#URL.ID#</cfoutput>" method="Post"><BR><BR>[U]UPDATE ACTION PAGE[/U]<BR><BR><html><BR><head><BR> <title>update_action</title><BR></head><BR><body></P > <P><cfupdate datasource="Weddings" tablename="faith"></P> <P><h1>Details Updated</h1></P> <P>You have updated the details for the couples in the database.</P> <P><BR></body><BR></html><BR><BR>Many Thanks<BR><BR>Nigel Smyrk</P> N Smyrk This message has been sent from CFdeveloper with username smyrk ([EMAIL PROTECTED]) -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
