Re: Help! SQL/Cold Fusion Error

Create a test table that mirrors M_COMPDISC and take your insert statement down to a single field. Then build up field by field until you find the problem.

Daniel Morgan

The Shirt wrote:

> Hi there,
> I'm having a problem with an error as below. The GEN_ID is a foreign key in
> the M_COMPDISC table. The GEN_ID foreign key is the primary key in table
> M_GENRE. The spelling is fine. I'm tearing my hair out trying to get to the
> bottom of this and would appreciate any help at all anyone can offer. The
> error codes and my code are below.
>
> Error Diagnostic Information
>
> An error occurred while evaluating the expression:
>
> #form.GEN_ID#
>
> Error near line 43, column 141.
> ----------------------------------------------------------------------------
> ----
>
> Error resolving parameter FORM.GEN_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 error occurred while processing an element with a general identifier of
> (#form.GEN_ID#), occupying document position (43:140) to (43:152).
>
> My code is below;
>
> insert into M_COMPDISC values(#get_pk.CDID#,'#form.CD_TITLE#',
>
> '#form.CD_ASIN#','#form.CD_PRICE#','#form.CD_LPRICE#','#form.CD_DATEREC#','#
> form.CD_NUMREC#','#form.CD_NUMSTOCK#','#form.CD_LEVREORDER#','#form.GEN_ID#'
> ,'#form.ART_ID#')
>
> Any help will be gratefully appreciated.
>
> Thanks
> Peter
>
> --
> peter123_at_cheerful.com
Received on Sun Apr 14 2002 - 18:31:14 CDT