For a checkbox handling a yes/no column (or a bit column), you want the
value attribute of the checkbox to always be "yes" (or 1 or on or true or
whatever works for your db).
If the current value in the db is yes, you include include the Checked
attribute in your checkbox tag, e.g.
<input type="checkbox" name="cabinPets" value="yes" <CFIF cabinPets EQ
"yes">"CHECKED"</CFIF> >
If you set the value of the checkbox to the current db value, sometimes the
value of the checkbox will be "no", and if someone checks it, you would be
updating the db in exactly the wrong way.
-----Original Message-----
From: P@tty Ayers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 8:22 AM
To: CF-Talk
Subject: Displaying yes/no field dynamically in checkboxes?
Friends,
I would much appreciate any help with a problem I'm stuck on.
I'm writing a page that will allow my client to edit a record. I've got it
so that the page queries the table and inserts the values from the record
specified by the numeric variable passed to it. The numeric fields, text
fields and memo fields appear, but I can't figure out how to make the
checkboxes display a check when the yes/no field is "yes".
Here's my code (below), such as it currently is. UltraDev wrote some of it
and I wrote the rest. The first few yes/no fields are "cabinHottub",
"cabinJettedtub", "cabinFireplace" and "cabinPets".
I would be grateful for any help; thanks very much in advance.
P@tty Ayers
<cfinclude template="Connections/connAsheville.cfm">
<cfparam name="cabintoedit" default="0">
<cfparam name="rsEdit__varcabintoedit" default="#cabintoedit#">
<cfquery name="rsEdit" datasource=#MM_connAsheville_DSN#
username=#MM_connAsheville_USERNAME# password=#MM_connAsheville_PASSWORD#>
SELECT * FROM cabinQuery WHERE cabinID = #rsEdit__varcabintoedit#
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Edit a Record Page</title>
</head>
<body bgcolor="#FFFFFF">
<!-- FORM SECTION -->
<cfoutput query = "rsEdit">
<form name="add_form" method="post" action="editsuccess.cfm">
<input type="hidden" name="cabinID" value="#cabinID#">
<table width="90%" border="1" cellspacing="0" cellpadding="5"
align="center" bordercolor="##CCCCCC">
<tr>
<td>Cabin Name:</td>
<td>
<input type="text" name="cabinName" maxlength="50"
value="#cabinName#">
</td>
<td>Location (City):</td>
<td>
<input type="text" name="cabinCity" maxlength="50"
value="#cabinCity#">
</td>
</tr>
<tr>
<td>Distance from Asheville:</td>
<td>
<input type="text" name="cabinDistance" maxlength="3" size="3"
value="#cabinDistance#">
</td>
<td>Number of Bedrooms:</td>
<td>
<input type="text" name="cabinBedrooms" maxlength="2" size="2"
value="#cabinBedrooms#">
</td>
</tr>
<tr>
<td>Number of Bathrooms:</td>
<td>
<input type="text" name="cabinBathrooms" maxlength="2" size="2"
value="#cabinBathrooms#">
</td>
<td>Sleeps:</td>
<td>
<input type="text" name="cabinSleeps" maxlength="2" size="2"
value="#cabinSleeps#">
</td>
</tr>
<tr>
<td>Hot tub:</td>
<td>
<input type="checkbox" name="cabinHottub" value="#cabinHottub#">
</td>
<td>Jetted tub:</td>
<td>
<input type="checkbox" name="cabinJettedtub"
value="#cabinJettedtub#">
</td>
</tr>
<tr>
<td>Fireplace:</td>
<td>
<input type="checkbox" name="cabinFireplace"
value="#cabinFireplace#">
</td>
<td>Pet-friendly:</td>
<td>
<input type="checkbox" name="cabinPets" value="#cabinPets#">
</td>
</tr>
<tr>
<td>Nightly Rate:</td>
<td> $
<input type="text" name="cabinNightly" size="4" maxlength="4"
value="#cabinNightly#">
</td>
<td>Weekly Rate:</td>
<td> $
<input type="text" name="cabinWeekly" size="4" maxlength="4"
value="#cabinWeekly#">
</td>
</tr>
<tr>
<td>Bedroom 1:</td>
<td>
<input type="text" name="cabinBedroom1" maxlength="50"
value="#cabinBedroom1#">
</td>
<td>Bedroom 2:</td>
<td>
<input type="text" name="cabinBedroom2" maxlength="50"
value="#cabinBedroom2#">
</td>
</tr>
<tr>
<td>Bedroom 3:</td>
<td>
<input type="text" name="cabinBedroom3" maxlength="50"
value="#cabinBedroom3#">
</td>
<td>Bedroom 4:</td>
<td>
<input type="text" name="cabinBedroom4" maxlength="50"
value="#cabinBedroom4#">
</td>
</tr>
<tr>
<td>Bedroom 5:</td>
<td>
<input type="text" name="cabinBedroom5" maxlength="50"
value="#cabinBedroom5#">
</td>
<td>Sleep Sofa:</td>
<td>
<input type="text" name="cabinSleepsofa" maxlength="50"
value="#cabinSleepsofa#">
</td>
</tr>
<tr>
<td>Loft:</td>
<td>
<input type="text" name="cabinLoft" maxlength="50"
value="#cabinLoft#">
</td>
<td>Dishwasher:</td>
<td><input type="checkbox" name="cabinDishwasher"
value="#cabinDishwasher#"></td>
</tr>
<tr>
<td>Microwave:</td>
<td><input type="checkbox" name="cabinMicrowave"
value="#cabinMicrowave#"</td>
<td>Air Conditioning:</td>
<td><input type="checkbox" name="cabinAC" value="#cabinAC#"</td>
</tr>
<tr>
<td>Stereo/CD Player:</td>
<td><input type="checkbox" name="cabinStereoCD"
value="#cabinStereoCD#"</td>
<td>TV:</td>
<td>
<input type="text" name="cabinTV" maxlength="50" value="#cabinTV#">
</td>
</tr>
<tr>
<td>VCR:</td>
<td><input type="checkbox" name="cabinVCR" value="#cabinVCR#"</td>
<td>Washer/Dryer:</td>
<td>
<input type="text" name="cabinWashdry" maxlength="50"
value="#cabinWashdry#">
</td>
</tr>
<tr>
<td>Deck/Porch:</td>
<td><input type="checkbox" name="cabinDeckporch"
value="#cabinDeckporch#"</td>
<td>Grill:</td>
<td>
<input type="text" name="cabinGrill" maxlength="50"
value="#cabinGrill#">
</td>
</tr>
<tr>
<td>View:</td>
<td>
<input type="text" name="cabinView" maxlength="50"
value="#cabinView#">
</td>
<td>Fireplace Style:</td>
<td>
<input type="text" name="cabinFirestyle" maxlength="50"
value="#cabinFirestyle#">
</td>
</tr>
<tr>
<td colspan="4">
<p align="center">Description:<br>
<textarea name="cabinsDescription" cols="60"
rows="5">#cabinsDescription#</textarea>
</p>
</td>
</tr>
<tr>
<td colspan="4">
<div align="center">
<input type="submit" value="Submit Edited Record to Database">
</div>
</td>
</tr>
</table>
</form>
</cfoutput>
<!-- END FORM SECTION -->
</body>
</html>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists