Hi
I have
recently convert my Access DB up to MsSql and done the necessary changes to
connect to the SQL DB. All that, went just fine.
The forums,
and topics are fully readable, but are not able to post anything. When I press “Post”
I end up with the following error:
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'CBool'
/_forum_beta/forum_posts.asp,
line 310
Any help is much appreciated
Small update
The error
only occurs when posting a new topic in any forum. Reply in already existing
topic, works fine.
Line 310 in forum_posts.asp:
'Read in the topic details
lngPollID = CLng(rsCommon("Poll_ID"))
strSubject = rsCommon("Subject")
strTopicIcon = rsCommon("Icon")
blnTopicLocked = CBool(rsCommon("topicLocked"))
intPriority = CInt(rsCommon("Priority"))
-----
FUNCTION OF CBool
Description
Returns an expression that has been converted to a Variant of subtype Boolean.
Syntax
CBool(expression)
The expression argument is any valid expression.
Remarks
If expression is zero, False is returned; otherwise, True is returned. If expression can't be interpreted as a numeric value, a run-time error occurs.
-----
Edited by Andreas.E - 03 April 2008 at 10:00am