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]