Jerry
|
Posted: 05/23/2003, 9:59 AM |
|
using ASP and Access.
I am getting errors from a check box when I submit the page.
When I let the grid wizard create the check box in the grid I get this
error:
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'CBool'
/bb/bb20/Common.asp, line 196
line 196 in common.asp reads as:
For I = 0 To TreeSize
I wouldn't think these are related???
The database is set to take Yes/No data. I tried to set the checked and
unchecked value and default value, but when I do the page wont even come up
at all.
I have tried to do it several different ways, even changing the format from
Boolean to text but with no luck. Anyone have any ideas?
Thanks in advance,
Jerry
|
|
|
Robert Rodgers
|
Posted: 05/23/2003, 12:06 PM |
|
Jerry,
There are a number of things to check.
On the Project Settings screen try setting your Boolean format to something
else, besides what ever it is now.
Make sure the DataType for the control properties is appropriate for the DB
column datatype.
Make sure your Checked Value and Unchecked Value for the control properties
are appropriate for the DB column datatype.
Because of issues in CCS1.0 I stopped using Bools in the DB. I started
using Int or TinyInt if the DB supports it. Then I made Checked Value = 1
and Unchecked Value = 0 with a Data Type of Int.
rob
--
"Every absurdity has a champion to defend it"
Oliver Goldsmith
++++++++++++++++++++++++++++++
"Jerry" <noneya@hotmail.com> wrote in message
news:balk0q$jju$1@news.codecharge.com...
using ASP and Access.
I am getting errors from a check box when I submit the page.
When I let the grid wizard create the check box in the grid I get this
error:
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'CBool'
/bb/bb20/Common.asp, line 196
line 196 in common.asp reads as:
For I = 0 To TreeSize
I wouldn't think these are related???
The database is set to take Yes/No data. I tried to set the checked and
unchecked value and default value, but when I do the page wont even come up
at all.
I have tried to do it several different ways, even changing the format from
Boolean to text but with no luck. Anyone have any ideas?
Thanks in advance,
Jerry
|
|
|
francine
|
Posted: 07/07/2003, 3:45 AM |
|
I had the same problem and I resolve it like this :
1) Table access : your field type : put : booleean
format : yes/no
2) property of the project for bolean put : nothing
3) generate your page (don't publish) or your project to have check box in
your page
4) property check box :
data type : boolean
checked value : nothing
unchecked : nothing
4) change the type in access and put : text instead boolean
5) now "live data " your page and it's ok , no error message.
If you look in access you can see : true for checked and false for
unchecked.
francine
"Jerry" <noneya@hotmail.com> a écrit dans le message denews:
balk0q$jju$1@news.codecharge.com...
> using ASP and Access.
> I am getting errors from a check box when I submit the page.
>
> When I let the grid wizard create the check box in the grid I get this
> error:
>
> Error Type:
> Microsoft VBScript runtime (0x800A000D)
> Type mismatch: 'CBool'
> /bb/bb20/Common.asp, line 196
>
> line 196 in common.asp reads as:
> For I = 0 To TreeSize
>
> I wouldn't think these are related???
>
> The database is set to take Yes/No data. I tried to set the checked and
> unchecked value and default value, but when I do the page wont even come
up
> at all.
>
> I have tried to do it several different ways, even changing the format
from
> Boolean to text but with no luck. Anyone have any ideas?
> Thanks in advance,
> Jerry
>
>
|
|
|
|