CDate problem in some posts
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=13374
Printed Date: 05 April 2026 at 10:10am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: CDate problem in some posts
Posted By: jurgen
Subject: CDate problem in some posts
Date Posted: 16 January 2005 at 9:46am
this problem occurs sometimes on opening posts.
It occurs always on the same posts, but not all posts get this error. this one gives that problem: http://forum.visualbasic.be/forum_posts.asp?TID=1990&PN=1 - http://forum.visualbasic.be/forum_posts.asp?TID=1990&PN=1
this one not: http://forum.visualbasic.be/forum_posts.asp?TID=1985&PN=1 - http://forum.visualbasic.be/forum_posts.asp?TID=1985&PN=1
The rest of the forum seems to work properly.
Is anyone familiar with this problem?
Thx,
Jürgen
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 16 January 2005 at 9:48am
|
Turn off the fetaure to display who the post was edited by. This can be done in the admin area under the 'forum configuration' page. ------------- 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: jurgen
Date Posted: 16 January 2005 at 9:55am
| No, that didn't do it. |
Posted By: WebWiz-Bruce
Date Posted: 16 January 2005 at 10:53am
|
The
problem is with the date that is being converted to show the time the
post is edited. It is within this function that the error on line 839 of the /functions/functions_format_post.asp is occuring. If you disable the option to have the edit date and person being displayed at the bottom of posts it will prevent this error from occuring. The option can be dispabled from:- 'forum configuration' found in the admin area ------------- 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: jurgen
Date Posted: 16 January 2005 at 11:29am
As I said, changing this configuration didn't solve the problem.
Why? |
jurgen wrote:Posted By: jurgen
Date Posted: 16 January 2005 at 4:41pm
|
The problem seems to be occuring on the old posts which have been edited.
Changing the configuration doesn't solve that because the editor's message is already in the database.
There is some problem configuring the date/time written with the old version of WWF. Has anyone a solution for this problem?
|
Posted By: sfd19
Date Posted: 17 January 2005 at 5:03am
|
We had the same problem after switching from an American server to a German server and then back to an American. It was annoying
Right before this line in /functions/functions_format_post.asp
If isNumeric(dtmEditedDate) Then dtmEditedDate = CDate(dtmEditedDate) Else dtmEditedDate = 0
add a new line.
When your server is using "." in the date format (eg German servers) then add
dtmEditedDate = Replace(dtmEditedDate,",",".")
or when your server is using "," in the date format (eg American servers) then add
dtmEditedDate = Replace(dtmEditedDate,".",",")
When you are not sure what format your current server is using then check for a message in your database that has been edited with the current server settings and see if that server is using "," or "." in the number of the edited date. Then apply the fitting code line from above.
That should help. ------------- Politics, economy & social issues: http://www.studentsfordemocracy.net - StudentsforDemocracy.net |
Posted By: martionline
Date Posted: 20 January 2005 at 6:17pm
|
in common.asp line 56
'Set the date time format to your own if you are getting a CDATE error
'Session.LCID = 1033 ==>make this Session.LCID = 1033 erase single quota |
Posted By: sfd19
Date Posted: 20 January 2005 at 8:06pm
That does not help when you have already stored edited dates in different formats in your database (by changing the host, for example). Then you either have to run a query against the database that re-formats the edited date in all posts or you can use my code above.
The Session.LCID only applies to new posts. Not to already stored ones. ------------- Politics, economy & social issues: http://www.studentsfordemocracy.net - StudentsforDemocracy.net |
Posted By: rdfonseca
Date Posted: 27 January 2005 at 8:12am
|
My error is: Microsoft VBScript runtime (0x800A000D) Type mismatch: 'CDate' /website/forum/default.asp, line 154 |
Posted By: b_w_t
Date Posted: 28 January 2005 at 4:22pm
This solved my problem too after I had re-located my website to a european server.
|
Posted By: sfd19
Date Posted: 28 January 2005 at 7:44pm
|
It should solve all problems with forums that were moved from one region to another. ------------- Politics, economy & social issues: http://www.studentsfordemocracy.net - StudentsforDemocracy.net |
Posted By: sfd19
Date Posted: 03 February 2005 at 8:19pm
Clear your cookies. You have stored a cookie with a different date format on your computer than the one the server is using. ------------- Politics, economy & social issues: http://www.studentsfordemocracy.net - StudentsforDemocracy.net |
Posted By: TomBrien
Date Posted: 01 May 2005 at 4:28pm
|
Ok my problem is:
Microsoft VBScript runtime error '800a000d' Type mismatch: 'CDate' /forum4/common.asp, line 448 I have tried editting the common.asp files and clearing cookies no luck. Any one have any ideas?
Tom
|