Barry G. Sumpter
|
| Posted: 05/04/2002, 4:06 PM |
|
Hi all,
I go t a record with multiple checkbox fields.
The search fails to recognize checkbox values.
Whats the trick behind using checkboxs.
Thanks,
Barry G. Sumpter
|
|
|
 |
Michael Fisher
|
| Posted: 05/26/2002, 5:50 PM |
|
I have the same problem.
Boolean data types tied to a checkbox object will not set the checkbox
object to the value of the field, although it *will* gladdly reset the
fields to false.  "Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote in
messagenews:ab1pi5$a4$1@news.codecharge.com...
> Hi all,
> I go t a record with multiple checkbox fields.
>
> The search fails to recognize checkbox values.
>
> Whats the trick behind using checkboxs.
>
> Thanks,
> Barry G. Sumpter
>
>
|
|
|
|
Jeff Turkington
|
| Posted: 05/26/2002, 11:04 PM |
|
Same problem here on B4... Tried all sorts of combinations of server type
parameters (0/1, Y/N.... SQL, Ansi...) to make it work but no go. (what
else do you do on a 5hr fltight?)
Jeff
"Michael Fisher" <codecharge@j-zone.com> wrote in message
news:acrvt7$20m$1@news.codecharge.com...
> I have the same problem.
> Boolean data types tied to a checkbox object will not set the checkbox
> object to the value of the field, although it *will* gladdly reset the
> fields to false. "Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote in
> messagenews:ab1pi5$a4$1@news.codecharge.com...
> > Hi all,
> > I go t a record with multiple checkbox fields.
> >
> > The search fails to recognize checkbox values.
> >
> > Whats the trick behind using checkboxs.
> >
> > Thanks,
> > Barry G. Sumpter
> >
> >
>
>
|
|
|
|
Sanddy
|
| Posted: 05/26/2002, 11:20 PM |
|
In ASP.NET (CCS B4), if the database field is Boolean, then set the Checked
value to True and UnChecked value to False.On each CheckBox.
If you want to set the "Default" value of the checkbox, you will have to
manually go and change the value, since there is a BUG in B4 !
--
Regards,
Saurabh Nandu
[ Microsoft MVP ]
www.MasterCSharp.com
Master C#, the easy way...
|
|
|
|
Alexey Alexapolsky
|
| Posted: 05/27/2002, 1:18 AM |
|
If you set 1;0 boolean format on checkbox control, you should set the same
boolean format
Project Setting/Connection/Server/Boolean Format.
Hopefully this helps.
--
Alex
CodeCharge Developer
"Michael Fisher" <codecharge@j-zone.com> wrote in message
news:acrvt7$20m$1@news.codecharge.com...
> I have the same problem.
> Boolean data types tied to a checkbox object will not set the checkbox
> object to the value of the field, although it *will* gladdly reset the
> fields to false. "Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote in
> messagenews:ab1pi5$a4$1@news.codecharge.com...
> > Hi all,
> > I go t a record with multiple checkbox fields.
> >
> > The search fails to recognize checkbox values.
> >
> > Whats the trick behind using checkboxs.
> >
> > Thanks,
> > Barry G. Sumpter
> >
> >
>
>
|
|
|
|
Jeff Turkington
|
| Posted: 05/27/2002, 2:50 PM |
|
Alex,
I dug a little deeper this afternoon and the problem isn't with the
insert/update but rather select code & control binding. For some reason, a
true/1 state in the db (SQL 2000 bit column) was not checking the box on
show.
After messing with the db parameters as you suggested with no result I tried
converting the check box into a text box... what do you know, a true state
displayed as -1 not 1. This gave me an idea and after coverting back to a
check box, and selecting '0' for the unchecked state and 'NOT 0' for the
checked state all works fine now.
This is a kludge though and I am still after an answer/fix to this.
Thanks,
Jeff
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:acsq43$el2$2@news.codecharge.com...
> If you set 1;0 boolean format on checkbox control, you should set the same
> boolean format
> Project Setting/Connection/Server/Boolean Format.
> Hopefully this helps.
>
> --
> Alex
> CodeCharge Developer
>
>
> "Michael Fisher" <codecharge@j-zone.com> wrote in message
>news:acrvt7$20m$1@news.codecharge.com...
> > I have the same problem.
> > Boolean data types tied to a checkbox object will not set the checkbox
> > object to the value of the field, although it *will* gladdly reset the
> > fields to false. "Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote in
> > messagenews:ab1pi5$a4$1@news.codecharge.com...
> > > Hi all,
> > > I go t a record with multiple checkbox fields.
> > >
> > > The search fails to recognize checkbox values.
> > >
> > > Whats the trick behind using checkboxs.
> > >
> > > Thanks,
> > > Barry G. Sumpter
> > >
> > >
> >
> >
>
>
|
|
|
|
Alexey Alexapolsky
|
| Posted: 05/28/2002, 4:31 AM |
|
Can you email me a non-working project+db, but with my solution implemented
in it?
--
Alex
CodeCharge Developer
"Jeff Turkington" <jeff@turkington.net> wrote in message
news:acu9mp$8n4$1@news.codecharge.com...
> Alex,
>
> I dug a little deeper this afternoon and the problem isn't with the
> insert/update but rather select code & control binding. For some reason,
a
> true/1 state in the db (SQL 2000 bit column) was not checking the box on
> show.
>
> After messing with the db parameters as you suggested with no result I
tried
> converting the check box into a text box... what do you know, a true
state
> displayed as -1 not 1. This gave me an idea and after coverting back to a
> check box, and selecting '0' for the unchecked state and 'NOT 0' for the
> checked state all works fine now.
>
> This is a kludge though and I am still after an answer/fix to this.
>
> Thanks,
> Jeff
>
> "Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
>news:acsq43$el2$2@news.codecharge.com...
> > If you set 1;0 boolean format on checkbox control, you should set the
same
> > boolean format
> > Project Setting/Connection/Server/Boolean Format.
> > Hopefully this helps.
> >
> > --
> > Alex
> > CodeCharge Developer
> >
> >
> > "Michael Fisher" <codecharge@j-zone.com> wrote in message
> >news:acrvt7$20m$1@news.codecharge.com...
> > > I have the same problem.
> > > Boolean data types tied to a checkbox object will not set the checkbox
> > > object to the value of the field, although it *will* gladdly reset the
> > > fields to false. "Barry G. Sumpter" <bsumpter@bigpond.net.au> wrote
in
> > > messagenews:ab1pi5$a4$1@news.codecharge.com...
> > > > Hi all,
> > > > I go t a record with multiple checkbox fields.
> > > >
> > > > The search fails to recognize checkbox values.
> > > >
> > > > Whats the trick behind using checkboxs.
> > > >
> > > > Thanks,
> > > > Barry G. Sumpter
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
|
