Inserting Radio Button Data

Report · Jun 18, 2009

I am not able to get <cfinsert> to work to insert into a remote DB2 database. I have been able to get cfquery INSERT's to insert into the DB2 database. I have not been able to get radio button data to INSERT into this database.

This is what I have tried:

___________________________________________________
surveyForm.cfm:
<html>
<head>
<title>Survey Form</title>
</head>
<body>
<h2>Enter a Survey Form</h2>

Branch:
<cfinput type="text" name="BRANCH" size="4" maxlength="4"><br><br>

Contact Name:
<cfinput type="text" name="CONTACT_NAME" size="40" maxlength="40"><br><br>

Did you get what you needed today? &nbsp
<cfinput type="radio" name="NEED_FLAG" id="radio" value="Y">Yes
<cfinput type="radio" name="NEED_FLAG" id="radio" value="N">No
<cfinput type="radio" name="NEED_FLAG" id="radio" value="X">Did Not Answer<br><br>

</cfform>
</body>
</html>
___________________________________________________
surveyAction.cfm:
<html>
<head> <title>Insert Survey Form</title> </head>
<body>

<cfquery datasource="AXMISC_SURVEY">
   INSERT INTO SURVEY.CAF_SURVEY
   (BRANCH, CONTACT_NAME, NEED_FLAG)
   VALUES
   ( <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.BRANCH#">,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.CONTACT_NAME#">
     <cfqueryparam cfsqltype="cf_sql_char" value="#form.NEED_FLAG#">
   )
</cfquery>

</body>
</html>
___________________________________________________

Thanks,
Jeanne

Report · Jun 18, 2009

zer0Weaver wrote:



<cfquery datasource="AXMISC_SURVEY">
   INSERT INTO SURVEY.CAF_SURVEY
   (BRANCH, CONTACT_NAME, NEED_FLAG)
   VALUES
   ( <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.BRANCH#">,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.CONTACT_NAME#">
     <cfqueryparam cfsqltype="cf_sql_char" value="#form.NEED_FLAG#">
   )
</cfquery>
</body>
</html>

Hi Jeanne,

Thanks for posting the relevant information, but you forgot to mention what _is_ happening now 😉 Does an error occur, and if so what is the error message, etcetera.. ? But my guess would be you are missing a comma in the VALUES (...) clause:

VALUES
(
<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.BRANCH#"> ,
<cfqueryparam cfsqltype="cf_sql_char" value="#form.CONTACT_NAME#"> , 
<cfqueryparam cfsqltype="cf_sql_char" value="#form.NEED_FLAG#">
)

Report · Jun 18, 2009

Also, radio buttons only exist if they were checked. So you should verify the fields exists before using it, or define a default values with cfparam

Report · Jun 18, 2009

That was it! Thanks

Inserting Radio Button Data

1 Correct answer