Answered
why I cannot update?
In the MemberUpdateForm.cfm, I have the following
......
<cfFORM ACTION="MemberUpdateActionPage.cfm" METHOD="Post">
...........
<table border="1" height="350">
.....
....
<P>
<INPUT TYPE="text" Name="MembersID" size="15" maxlength="50" required="yes"
VALUE="<CFOUTPUT QUERY="MemberRecord">#MembersID#</CFOUTPUT>">
</P>
<P>
<b>My handle name is</b><INPUT TYPE="Text" Name="HandleName" size="15" maxlength="50" required="yes" disabled="disabled"
VALUE="<CFOUTPUT QUERY="MemberRecord">#HandleName#</CFOUTPUT>">
</P>
<P>
<INPUT TYPE="submit" NAME="SUBMIT" VALUE="Submit Data">
<INPUT TYPE="reset" NAME="Clear" VALUE="Clear Form">
</P>
<br>
</center>
</cfform>
In the MemberUpdateActionPage.cfm page, I have the following
...........
<CFQUERY NAME="MemberRecordUpdate" DATASOURCE="Contact">
UPDATE Members
SET HandleName='#Form.HandleName#'
WHERE MembersID=#Form.MembersID#
</CFQUERY>
When I submit the form, I have this error from the log
"Error","http-nio-8500-exec-5","04/02/25","21:12:03","","Element HANDLENAME is undefined in FORM. The specific sequence of files included or processed is: C:\ColdFusion2025\cfusion\wwwroot\CFIDE\Club\AAE\membership\us\MemberUpdateActionPage.cfm, line: 36"
Can someone see what wrong with my HandleName?
AdChoices