kburnett
|
| Posted: 04/05/2003, 11:20 AM |
|
anyone noticed a changed in how ccs2 handles mysql boolean? i have a project build in 1.7 and now in 2.0 the boolen settings error.
case in point...
i have a tinyint(1) field that is either 1 or 0. in ccs1.7 i have datatype as boolean with a format value of Yes/No. but the page errors telling me "The value in field featured is not valid. Use the following format: Yes;No".
so i tried different settings like dbformat = 1/0. same result.
anyone else seen this?
thanks.
|
|
|
 |
bens
|
| Posted: 04/07/2003, 12:17 PM |
|
Yes, I'm not sure if the problem is the same, but I had to struggle with mssql booleans, called 'bit' data type.
I've got arround this by changing all my mssql BIT data types to tinyints after ccs2.
I could not get any credible answer from Codecharge as why booleans don't work, and why boolean format in site settings has no visible effect.
Finaly, I can see no benefit using booleans values rather than tinyints, so I gave up.
I think that rather than a 'magic' solution, we need a clear explanation of how booleans are handled from the user keyboard to the user checkbox, via its windows, the odbc connector, the database settings and back.
And this with various combinations of 'boolean type' and 'database' type in site settings.
Bens
|
|
|
|
mhamilton
|
| Posted: 04/08/2003, 5:33 AM |
|
I found that by changing the data type from boolean to integer that the "Boolean" functionality was restored.
|
|
|
|
GreggB
|
| Posted: 04/08/2003, 8:32 AM |
|
Never had to us Boolean until lately for a "Check List Project". But I don't think there's a problem? The checks boxes all seem to be working correctly in the Editable Grid I'm using.
I'm using ASP and MS SQL:
---MS SQL 2000---
Field: bit
---CCS 2.0.5.6 Properties---
Data Type: Boolean
Checked Value: 1
UnChecked Value: 0
Default Value: UnChecked
This setup is working for me and thought it was the correct setting for Boolean. I haven't tried this with PHP but will tonight at home.
GreggB
|
|
|
|
kburnett
|
| Posted: 04/08/2003, 9:11 PM |
|
well, the boolean does work with select lists, but it does not work for display on a label.
no biggy, i will set the display manually with the mysql query.
|
|
|
|
kburnett
|
| Posted: 04/09/2003, 2:15 PM |
|
ok - i solved my boolean problem.
on a boolean field (tinyint(1) in the mysql db), placed on a display grid, ccs2 pukes if...
you set the format to something like yes/no AND the ccs field default value as 0.
ccs1.x did not mind that but ccs2 does. i know this for a fact as i have a project created in 1.x that has run great for 6 months. and i just opened it into 2.x last week to make some changes and this was now a problem.
don't get me wrong, i ain't complaining. just sharing my experience.
2.x is a great step forward.
|
|
|
|
|
