Don't unsubscribe because of that, cf-talk is the best one for answers to your questions.
Ade -----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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
