Web Wiz Forums - Error on GetMemberByName in HTTPApi

Print Page | Close Window

Error on GetMemberByName in HTTPApi

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25525
Printed Date: 03 April 2026 at 8:24pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error on GetMemberByName in HTTPApi

Posted By: vassabi
Subject: Error on GetMemberByName in HTTPApi
Date Posted: 02 April 2008 at 11:05pm

Hi Bruce, I got the following error when trying to use HTTPApi's GetMemberByName method

<?xml version="1.0" encoding="windows-1251" ?> <font face="Arial" size=2>
<p>Microsoft VBScript runtime </font> <font face="Arial" size=2>error '800a000d'</font>
<p>
<font face="Arial" size=2>Type mismatch: 'Server.HTMLEncode'</font>
<p>
<font face="Arial" size=2>/forum/HttpAPI.asp</font><font face="Arial" size=2>, line 309</font> 

After a deeper investigation I noticed that this error arise when trying to get a member with filled DOB in the profile, 
how can this be fixed?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 03 April 2008 at 10:06am

Looking at the code it doesn't look like an issue with the DOB field but possible with the 'Newsletter' field in tblAuthor. Check that you don't have any 'Null' fields in the database for this field and it is set to:-

Access - True/Flase
SQL Server - Bit
mySQL - tinyInt

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: vassabi
Date Posted: 03 April 2008 at 1:49pm

Bruce I checked, I use MS SQL database, Newsletter field is bit, and the Allow Nulls is unchecked so it is impossible to have nulls there.
Any other ideas?

Posted By: WebWiz-Bruce
Date Posted: 03 April 2008 at 2:02pm

Sorry looking at the error it's not a CBool error it's a Type mismatch: 'Server.HTMLEncode' so this would be for the part reading in the Gender.

Check that the Gender field in tblAuthor doesn't contain null's. It's a text field which should show the gender of the user or be blank.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: vassabi
Date Posted: 03 April 2008 at 3:31pm

Thanks Bruce that helps