Coldfusion - showing initial value in radio button selection on form

I have a Coldfusion form that includes a radio button.  When I want to update a record, I can pull in all the original values into every form except the radio button. Is there a way to set the value of the radio buttons to what is in the database?
Who is Participating?
erikTsomikConnect With a Mentor System Architect, CF programmer Commented:
<input type="radio" name="xxx" value="house"<cfif query.filedname eq "house">checked</cfif>>
<input type="radio" name="xxx" value="village"<cfif query.filedname eq "village">checked</cfif>>

erikTsomikSystem Architect, CF programmer Commented:
sure it can be done
Once you get you query you just say this
<input type="radio" name="xxx" <cfif query.filedname eq 1>checked</cfif>>

ServalStudiosAuthor Commented:
I think we are close, but still not working..
my query is called "update" and my field is called "region", so I have

<cfif update.region eq 1>checked</cfif>

Would it be 1, or should it be something like text value in the field?
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

erikTsomikSystem Architect, CF programmer Commented:
what is the value that get store in region (1, yes , no and so on )
ServalStudiosAuthor Commented:
so if it is a value like "house" do I put eq "house" or?
<cfset fieldlist="car,house,boat,hole in the ground">
<cfloop list="#fieldlist#" index="ii">
      <input type="radio" name="xxx" value="#ii#"<cfif is ii>checked</cfif>>#ii#<br>
ServalStudiosAuthor Commented:
Thank you.. works great
All Courses

From novice to tech pro — start learning today.