RE: Displaying yes/no field dynamically in checkboxes?

2001-04-03 Thread Jason Lees (National Express)
try something like this. input type="checkbox" name="cabinPets" value="#cabinPets#" cfif #ucase(Cabinpets)# eq "YES"Checked/cfif Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: P@tty Ayers [mailto:[EMAIL PROTECTED]] Sent: 03 April 2001 14:22 To:

RE: Displaying yes/no field dynamically in checkboxes?

2001-04-03 Thread James Maltby
You need to add a cfif sub-clause in your code: e.g. input type="checkbox" name="cabinHottub" value="#cabinHottub#" cfif #cabinHottub# eq "x"checked/cfif Where "x" is the value passed from your database. Try that out James Remember amateurs built the ark... Professionals built the Titanic

Re: Displaying yes/no field dynamically in checkboxes

2001-04-03 Thread Chris Michl
input type="checkbox" name="cabinVCR" value="#cabinVCR#"cfif Not CompareNoCase(rsEdit.CabinVCR,"yes") checked - Original Message - From: "P@tty Ayers" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 9:45 AM Subject: Displaying yes/no field dynamically in

RE: Displaying yes/no field dynamically in checkboxes?

2001-04-03 Thread Hayes, David
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

RE: Displaying yes/no field dynamically in checkboxes

2001-04-03 Thread Nathan Stanford
Here is one way you can do one. I will let you do the rest. tdVCR:/td td cfif #cabinVCR# eq 1 input type="checkbox" name="cabinVCR" checked cfelse input type="checkbox" name="cabinVCR"

RE: Displaying yes/no field dynamically in checkboxes

2001-04-03 Thread Peter J. MacDonald
You will need to do a cfif around SELECTED. input type="checkbox" name="cabinDishwasher" cfif #cabindishwasher# IS 1SELECTED/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:

RE: Displaying yes/no field dynamically in checkboxes?

2001-04-03 Thread Peter J. MacDonald
-Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 10:48 AM To: CF-Talk Subject: RE: Displaying yes/no field dynamically in checkboxes? try something like this. input type="checkbox" name="cabinPets" valu

Re: Displaying yes/no field dynamically in checkboxes?

2001-04-03 Thread Frank Hilliard
Hi Patty, Use a CFIF statement around the checkbox option CHECKED. If variable is 1 CHECKED, CFELSE empty. Frank Hilliard "P@tty Ayers" wrote: 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

RE: Displaying yes/no field dynamically in checkboxes?

2001-04-03 Thread Lamon, Alec
P@tty, Checkboxes work a bit differently. You'll need to use a simple cfif statement to set the checked property of the different checkboxes: tdHot tub:/td td input type="checkbox" name="cabinHottub" cfif rsEdit.cabinHottub EQ 1CHECKED/cfif" /td So if the value of

RE: Displaying yes/no field dynamically in checkboxes

2001-04-03 Thread Kelly Matthews
input type="checkbox" name="whatever" value="1" CFIF query.whatever EQ 1CHECKED/CFIFYes input type="checkbox" name="whatever" value="0" CFIF query.whatever EQ 0CHECKED/CFIFNo -Original Message- From: P@tty Ayers [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 10:45 AM To: