Anea
|
| Posted: 04/27/2005, 10:06 AM |
|
When used the checkboxes in my search form find no records.
ASP/Access, grid with search builder.
I have tried various combinations of bollean types in ccs and access, tried setting checked, unchecked values in properties but nothing seems to work.
This seems like a simple search type but i can't find what's wrong. Looked for relavant posts but failed to find solution.
Can someone point out some common faults. Thanks
|
|
|
 |
Nicole
Posts: 586
|
| Posted: 04/28/2005, 2:18 AM |
|
Anea,
In general to search using checkbox (i.e. Boolean values) you need to configure the WHERE parameter on a grid form in a special way. But before you start make sure that you set valid Boolean format in database Connection dialog-> Server tab
About WHERE settings. I successfully use the following in my project
Field
Name: Boolean_field_name
Type: Boolean
Format: true;false (the same format I set in Connection dialog/Server)
Parameter Source
Name: parameter_name
Type: URL
Format: 1;0. In fact you need to notice what values are passed via URL for checked and unchecked checkbox and put that values here.
_________________
Regards,
Nicole |
 |
|
Anea
|
| Posted: 04/28/2005, 8:08 AM |
|
Thanks that worked first time, don't know why i did'nt find out first time. But i am left with displaying 1 and 0 in my column instead of Yes, No.
How would i correct this or better still, display a different picture for true and false.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 04/28/2005, 10:34 PM |
|
You can specify those values in the format property of your label, for example:
Format = Yes;No
Or you can specify some HTML, like:
<font color=green>Yes</font>;<font color=red>No</font>
Of course you can use other HTML that displays images as well.
Don't forget to set Content=HTML when using HTML.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Anea
|
| Posted: 04/29/2005, 1:00 AM |
|
Thanks, didn't know you could set properties of the label as well as the control. It's fantastic how easy it is to integrate HTML, the options are endless.
In the Store example how is the less than/more than search fields setup.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 04/29/2005, 1:09 AM |
|
Glad you like it 
The search forms are actually not performing any searches, just accepting user input. However in the Grid that displays the results you can create WHERE parameters that are not only equal (=) to a Search/URL parameter, but also smaller than (<) or bigger (>) than a parameter. Look in the same WHERE parameter area as you've been discussing above with Nicole.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
