Using CFquery to insert

[JohnCHill]

Hello,

I am using CFquery to insert data from a form into an Access database. If all fields are not entered a message is returned indicating that "Element X is undefined in FORM." The Access database fields allow null values. If I entered data into every field it works fine. I have tried using cfqueryparam to check for null but have had no luck. My code is below. Any help is greatly appreciated.

INSERT INTO ISDSUserSurvey
(1)
VALUES <cfqueryparam value="#trim(form.1)#" cfsqltype="CF_SQL_VARCHAR" null="#YesNoFormat(not(len(trim(form.1))))#"/>

and this code:

INSERT INTO ISDSUserSurvey
(1)
VALUES (<cfif IsDefined("#Form.1#") AND "#Form.1#" NEQ "">
'#Form.1#',
<cfelse>
NULL,
</cfif>

[Dan_Bracuk]

On your form, what type of element is form1?

[JohnCHill]

Hello, the input type is radio button with three options.

[Dan_Bracuk]

If nothing is selected, your variable won't be defined. That's why your cfqueryparam didn't work. Your approach only works when the input is a text box or drop down,

Your 2nd attempt failed because "#Form.1#" is a string, it is not outputting a variable. The simplest thing is to get rid of it.

[JohnCHill]

Great thanks!

Do you have a method that will work for radio buttons, check boxes, and text fields?

[Dan_Bracuk]

the cfparam tag may be helpful. details are in the cfml reference manual. If you don't have one, the internet does.