You will need to do a <cfif> around SELECTED.
<input type="checkbox" name="cabinDishwasher" <cfif #cabindishwasher# IS
1>SELECTED</cfif>>
Thank You,
Peter
Peter J. MacDonald II
Creative Computing, Inc.
100 Middle Street
Lincoln, RI 02865
Phone: 401.727.0183 x123
Fax: 401.727.4998
Portable: 401.965.3661
E-MAIL: [EMAIL PROTECTED]
Web Page: www.creatcomp.com
-----Original Message-----
From: P@tty Ayers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 10:45 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
