1) the error refers to TESTFORM... which page has #TESTFORM.PID# in it? 2) in your posted code the ACTION attrib of your cfform tag is set to 'action.cfm'... the error states it occurred in page 'db1.cfm'... some template confusion going on?
Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ alex poyaoan wrote: > 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:304079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
