The error is saying "PID is undefined in TESTFORM". Do you have TESTFORM.pid anywhere?
Adrian -----Original Message----- From: alex poyaoan [mailto:[EMAIL PROTECTED] Sent: 23 April 2008 15:23 To: CF-Talk Subject: Re: problem with form field undefined Hi Adrian with that cfdump it gives me this struct struct FIELDNAMES SUBMIT,PID,SID,ID INFID 18276 PID 17047 SID 17734 SUBMIT associate all of it is defined but still it gets the undefined error on the form thanks >To see what's in the FORM scope, add this above the point it errors. > ><cfdump var="#FORM#"> ><cfabort> > >See what that shows you. > >Adrian >http://www.adrianlynch.co.uk/ > >HI everybody below is the error which Coldfusion gives me: > >Element PID is undefined in TESTFORM. (this is the error that coldfusion >gives me as soon as I press the ok button that should update the info table) > >action.cfm > >The error occurred in C:\CFusionMX7\wwwroot\db\db1.cfm: line 4 > >2 : UPDATE info >3 : SET >4 : pID = #form.PID#, >5 : sID = #form.SID# >6 : WHERE id=#form.ID# > >I have this form on the first template that calls the action.cfm >it gets it's data from a query named check > ><cfoutput> ><CFFORM ACTION="action.cfm" format="xml" skin="lightgray" width="500" >preservedata="yes" METHOD="Post"> ><!--- <cfinput type="hidden" name="Tab" value="1"> ---> ><cfinput type="text" name="PID" value="#check.PID#"> ><cfinput type="text" name="SID" value="#check.SID#"> ><cfinput type="text" name="ID" value="#check.ID#"> > ><cfinput type="submit" name="Submit" value=" ok "> ></cfform> ></cfoutput> > >I don't know what's getting this error since PID is defined in the form > >please help ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

