Is line 111 inside a <cfoutput> tag, so coldfusion knows to process
#form.department_id#?

On Wed, 5 Jun 2002, Phillip Perry wrote:

> Date: Wed, 5 Jun 2002 22:37:29 -0400
> From: Phillip Perry <pperry(at)inter-design.net>
> To: hwg-languages(at)hwg.org
> Subject: 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