N Smyrk On your update form page you are passing the ID as a URL parameter. Are you ensuring that the ID is passed to the form everytime?
-----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] _______________________________________________________________________ Confidentiality: This e-mail and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. Security Warning: Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. Viruses: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free. ________________________________________________________________________
