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
