Worked! Thanks for the advice. What is a bit daunting about CF for newbies is the various valid approaches to accomplish the same task.
Rick -----Original Message----- From: Kreig Zimmerman [mailto:kkz@;foureyes.com] Sent: Friday, 01 November, 2002 10:54 To: CF-Talk Subject: Re: Check Boxes - another NUG question Oh yeah, I may have slightly misunderstood the last question, so to add: The way to do this on the form page is this: <input type="checkbox" name="thisBox" value="1"#iif(Query.thisBox, DE(' checked'),DE(''))#> .since it is a boolean we are using as a value, in the IIF, "1" evaluates to "true", and "0" to false. Thus only "1"s make the checkbox be checked. Randell B Adkins wrote: >In the database field you can set the value to anything you want, >however you will need to test for the value to properly >set the checkboxes on the form to be checked or unchecked. > >Example: >CheckBoxField: Value could be "AGREE" or DISAGREE" > >on the Form: ><input type="checkbox" name="abc" value="Agree" <CFIF >qMyQuery.CheckBoxField EQ 'AGREE'>checked</cfif>> > > > > >>>>[EMAIL PROTECTED] 11/01/02 10:29AM >>> >>>> >>>> >When querying a db where some original input fields were check boxes >and >were inserted into the db as a binary (yes/no, 1/0, on/off), is the >only way >to display a check box on the query page, either checked or unchecked, >to >create a form and add an insert field? If so, I'm having trouble with >the >conditional logic. Is there an approach I'm overlooking. > >Rick > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com