Well...I tried to read up on the etiquette but I couldn't find it anywhere.
On Fri, 1 Nov 2002 15:04:59 -0000, Robertson-Ravo, Neil (REC) wrote: > its nothing to do with annoying people...its list etiquette.... > > LOOK AT THE BOTTOM OF ALL CF_TALK EMAILS > > -----Original Message----- > From: FlashGuy [mailto:flashmx@;rogers.com] > Sent: 01 November 2002 15:03 > To: CF-Talk > Subject: Re: Unsubscribe > > > Due to me posting the same question on multiple lists which has been > annoying some people > I've decided to take their advice and only post to one mailing list > cf-community. > > How can I unsubscribe from this list? > > On Fri, 01 Nov 2002 09:53:45 -0500, Kreig Zimmerman wrote: > > > 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/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
