Radio button insert

[Abdlah]

Hello,
I have the following code in my project:

<cfinput type="radio" name="gender" value="Female" checked="yes"> Female
<cfinput type="radio" name="gender" value="Male"> Male

Now i want to save the value of the selected radio button i.e. Male or Female
into a database and I use the following code

Insert into Consumer(...., gender,...) values (..., FORM.gender,...) but I get
a no/yes value in my database instead of Female/Male.

How do I get Female/Male to be recorded in the database instead of a yes/no
depending on what the user selects?

[jdeline]

What is the data type of the field in the database. I'd bet it is not text. Also, I you need '#FORM.gender#' in your values list in the insert statement.

[Abdlah]

The datatype of the gender field is text, also I do have '#TRIM(Form.gender)#' in my insert statement, yet the value posted to the database is a yes/no type.

[Dan Bracuk]

If you do <cfdump var="#form#"> what do you get for the gender?

Originally posted by: Abdlah
The datatype of the gender field is text, also I do have '#TRIM(Form.gender)#'
in my insert statement, yet the value posted to the database is a yes/no type.

[Abdlah]

Hi,
when I do <cfdump var="#form#"> I get male or female for gender.

[Dan Bracuk]

You don't need to trim the form variable, even though that is probably not what
is causing your problem. If you have debugging turned on, put a cfabort after
your input query so you can read the sql.

Do all the other fields receive their expected values?

[Abdlah]

Actually, something really weird happened, I accidentally closed dreamweaver
and had to start it again, and now the database recieves the right value. I
don't understand what happned. Now I have a series of On values and one Male
value for my last submission.

This happened after I tested the action page with the cfdump you suggested.

Thanks for the help.