DeWebDude
|
| Posted: 06/04/2003, 9:27 AM |
|
I have set the checked value to Y, but want a BLANK value for none, when I leave it blank it returns ' ' (including the single quotes). When I put it does the same. I just want it to show nothing when I display the values, except when the value you is Y it would show Y.
Thanks
|
|
|
 |
rclay
|
| Posted: 06/04/2003, 9:31 AM |
|
With no idea what language, platform, etc you are using - You might try setting it to NULL. A space is an empty string.
|
|
|
|
DeWebDude
|
| Posted: 06/04/2003, 1:09 PM |
|
Sorry about that, using PHP.
The result in the table when I type NULL is 'NULL' ( including quotes ).
Thanks !
|
|
|
|
DeWebDude
|
| Posted: 06/04/2003, 1:35 PM |
|
Sorry about that...I am using PHP.
I tried NULL, but the result was simply a quoted null 'NULL'
Thanks
|
|
|
|
Mickster
|
| Posted: 06/09/2003, 11:11 PM |
|
I have a similar need, anyone have an answer ?
Using Code Charge, with PHP.
I would like to use a checked value to store a value lets say Y, but if nothing is stored then when I display the results of the field I just want it to be blank.
Thanks
|
|
|
|
Marcus
|
| Posted: 06/10/2003, 2:34 AM |
|
I have form that save 'Y' value if checkbox was checked and blank value otherwise and it's works perfect for me.
Here the properties from my checkbox control on record form.
Name: checkbox_name
Default Value: BLANK
Data Type: Text
Unique: UNCHECKED
Required: UNCHECKED
Checked Value: Y
Unchecked Value: BLANK
Hope it's help.
|
|
|
|
Mickster
|
| Posted: 06/10/2003, 3:35 PM |
|
This is an example ( minus table ) for the results from the form.
If I put NOTHING ( leave blank ) or if I put the word BLANK or the word NULL, I get the result you see below:
Urgent'Y'
Returned Your Call'NULL'
Potential Client'Y'
Wants An Appointment'NULL'
Looking For Status'Y'
I would like to only have Y without the single quotes, and also nothing printed at all instead of the word NULL.
If I have no value I will simply get '' as the result.
Thanks !
|
|
|
|
