I have a page that I am trying to use checkboxes and then update a database with the criteria from the checkboxes. The problem is: When all boxes are checked, the tables in the DB are updated correctly. However, when I uncheck one of the check boxes I get an error that states the following:
Error Diagnostic Information
An error occurred while evaluating the expression:
"#form.irw#"
Error near line 23, column 17.
Below is the code in the page where I am having the problems.
<cfparam name="#form.telco#" default="0">
<cfif #form.telco# is "1">
<cfquery name="telcorequest" datasource="teradata32" username="username" password="password">
insert into C_U_V.VCCRB044_USER_QUEST_VALIDATE
(USER_ID, UNV_REQUESTED)
VALUES ('#FORM.SBCID#','TELCO')
</cfquery>
</cfif>
<cfparam name="#form.irw#" default="0">
<cfif #form.irw# is "1">
<cfquery name="irwrequest" datasource="teradata32" username="username" password="password">
insert into C_U_V.VCCRB044_USER_QUEST_VALIDATE
(USER_ID, UNV_REQUESTED)
VALUES ('#FORM.SBCID#','IRW')
</cfquery>
</cfif>
<cfparam name="#form.orw#" default="0">
<cfif #form.orw# is "1">
<cfquery name="orwrequest" datasource="teradata32" username="username" password="password">
insert into C_U_V.VCCRB044_USER_QUEST_VALIDATE
(USER_ID, UNV_REQUESTED)
VALUES ('#FORM.SBCID#','ORW')
</cfquery>
</cfif>
Any help on this would greatly be appreciated
Error Diagnostic Information
An error occurred while evaluating the expression:
"#form.irw#"
Error near line 23, column 17.
Below is the code in the page where I am having the problems.
<cfparam name="#form.telco#" default="0">
<cfif #form.telco# is "1">
<cfquery name="telcorequest" datasource="teradata32" username="username" password="password">
insert into C_U_V.VCCRB044_USER_QUEST_VALIDATE
(USER_ID, UNV_REQUESTED)
VALUES ('#FORM.SBCID#','TELCO')
</cfquery>
</cfif>
<cfparam name="#form.irw#" default="0">
<cfif #form.irw# is "1">
<cfquery name="irwrequest" datasource="teradata32" username="username" password="password">
insert into C_U_V.VCCRB044_USER_QUEST_VALIDATE
(USER_ID, UNV_REQUESTED)
VALUES ('#FORM.SBCID#','IRW')
</cfquery>
</cfif>
<cfparam name="#form.orw#" default="0">
<cfif #form.orw# is "1">
<cfquery name="orwrequest" datasource="teradata32" username="username" password="password">
insert into C_U_V.VCCRB044_USER_QUEST_VALIDATE
(USER_ID, UNV_REQUESTED)
VALUES ('#FORM.SBCID#','ORW')
</cfquery>
</cfif>
Any help on this would greatly be appreciated