ColdFusion help

Hi,

I've tried to re-develop an application that I used for myself but can't
seem to get it. What I'm doing is trying to update the database based on a
form based on the ID of the item (in this case a persons name). I was able
to do it right once, but then gave me error messages. I didn't change the
code between the successful attempt and the error message so I can't figure
it out.

The Error message is:

An error occurred while evaluating the expression:
#form.department_id#
Error near line 111, column 16.
----------------------------------------------------------------------------
----

Error resolving parameter FORM.DEPARTMENT_ID

The specified form field cannot be found. This problem is very likely due to
the fact that you have misspelled the form field name.


the SQL is as follows:

UPDATE 	Tuesdays
			SET		first_name = '#form.firstname#',
					last_name = '#form.lastname#',
					wins = '#form.wins#',
					loses = '#form.loses#',
					rating = '#form.rating#'
			WHERE	ID = #form.department_id#

The Form Is:

<INPUT TYPE="hidden" NAME="gogo" VALUE="yes">
<INPUT TYPE="hidden" NAME="action" VALUE="#action_field#">
<INPUT TYPE="hidden" NAME="department_id" VALUE="#form.department_id#">

Any Suggestions?

Thanks!

_____________________________

InterDesign - Designing Tomorrow, Today!
52 Franklin Ave.
Box 22
Clinton, NY 13323
http://www.inter-design.net
questions(at)inter-design.net

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA