Web Wiz Support and Community Forums : Invalid use of Null: 'CBool' https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 15:04:40 +0000 Fri, 26 May 2006 12:17:51 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19996 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Invalid use of Null: 'CBool' : -boRg- wrote:UPDATE tblThread...]]> https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107804.html#107804 Author: MortiOli
Subject: 19996
Posted: 26 May 2006 at 12:17pm

Originally posted by -boRg- -boRg- wrote:

UPDATE tblThread set Show_signature = 1
 
Perfect!  Thanks!
]]> Fri, 26 May 2006 12:17:51 +0000 https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107804.html#107804 <![CDATA[Invalid use of Null: 'CBool' : Try:-UPDATE tblThread set Show_signature...]]> https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107796.html#107796 Author: WebWiz-Bruce
Subject: 19996
Posted: 26 May 2006 at 11:46am

Try:-

UPDATE tblThread set Show_signature = "True"

OR

UPDATE tblThread set Show_signature = 1]]> Fri, 26 May 2006 11:46:13 +0000 https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107796.html#107796 <![CDATA[Invalid use of Null: 'CBool' : I&#039;d rather run a script if...]]> https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107760.html#107760 Author: MortiOli
Subject: 19996
Posted: 25 May 2006 at 8:55pm

I'd rather run a script if possible, to set all values to 'True'.

Could you advise on what SQL query would I need to run to update them?

I thought it would be the following;

UPDATE tblThread set Show_signature = True

But my host is coming back with a message, saying that the above throws up the following error;

Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'True'.]]> Thu, 25 May 2006 20:55:37 +0000 https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107760.html#107760 <![CDATA[Invalid use of Null: 'CBool' : Probally the simplest way is delete...]]> https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107705.html#107705 Author: WebWiz-Bruce
Subject: 19996
Posted: 24 May 2006 at 10:17pm

Probally the simplest way is delete the field then recreate it setting the default value to 'False', as SQL server places the defeault value in the column for all records when you create a new column, Access doesn't do this.

This will recerate the column with false in all records. This will mean that signatures will not display in old messages but it will clear up the problem and new messages can still include signatures.
]]> Wed, 24 May 2006 22:17:10 +0000 https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107705.html#107705 <![CDATA[Invalid use of Null: 'CBool' : I&#039;m not 100% sure, but yes,...]]> https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107692.html#107692 Author: MortiOli
Subject: 19996
Posted: 24 May 2006 at 6:53pm

I'm not 100% sure, but yes, I think my host has recently upgraded.
 
Would you be able to write a quick script that I could run, to update the blanks to, for example, True, please?
]]> Wed, 24 May 2006 18:53:43 +0000 https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107692.html#107692 <![CDATA[Invalid use of Null: 'CBool' : Have you moved from SQL Server...]]> https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107665.html#107665 Author: WebWiz-Bruce
Subject: 19996
Posted: 24 May 2006 at 1:51pm

Have you moved from SQL Server 2000 to 2005?

If so then this could have happened when making the transfer as SQL server 2000 shows bits as 1 or 0 and SQL 2005 uses True and False
]]> Wed, 24 May 2006 13:51:19 +0000 https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107665.html#107665 <![CDATA[Invalid use of Null: 'CBool' : I&#039;ve checked the table /...]]> https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107661.html#107661 Author: MortiOli
Subject: 19996
Posted: 24 May 2006 at 12:59pm

I've checked the table / fields, and Show_signature is set as bit.

What I've noticed is that Thread_ID 1 to 97584 has Show_signature as blank, and then 97585 - 114441 Thread_ID's has True or False in Show_signature.

I assume they should all be either True or False?

However, there are also the odd Thread_ID scattered amongst the blank Show_signature's with True or False set against them.]]> Wed, 24 May 2006 12:59:56 +0000 https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107661.html#107661 <![CDATA[Invalid use of Null: 'CBool' : OK, I&#039;ve looked into some...]]> https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107657.html#107657 Author: WebWiz-Bruce
Subject: 19996
Posted: 24 May 2006 at 10:26am

OK, I've looked into some more and found the line in question, in this case, reads in if a signature is to be shown in a post or not, by reading in the value from the field Thread.Show_signature in the database.

This field should be of the data type 'bit' so that it can be read in as a boolean.

Have a look in your database at this field to see if there are any un-usual entries and make sure it is set to the 'bit' data type.
]]> Wed, 24 May 2006 10:26:13 +0000 https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107657.html#107657 <![CDATA[Invalid use of Null: 'CBool' : But these topics aren&#039;t deleted,...]]> https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107655.html#107655 Author: MortiOli
Subject: 19996
Posted: 24 May 2006 at 9:17am

But these topics aren't deleted, and could be viewed fine in 7.x

Or do you mean the topics include posts that have been deleted?
]]> Wed, 24 May 2006 09:17:30 +0000 https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107655.html#107655 <![CDATA[Invalid use of Null: 'CBool' : This happens if you try and view...]]> https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107607.html#107607 Author: WebWiz-Bruce
Subject: 19996
Posted: 23 May 2006 at 4:41pm

This happens if you try and view a post that is deleted.

I have been working on a fix for the next release
]]> Tue, 23 May 2006 16:41:10 +0000 https://forums.webwiz.net/invalid-use-of-null-cbool_topic19996_post107607.html#107607