Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - CDate problem in some posts
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

CDate problem in some posts

 Post Reply Post Reply Page  <12
Author
sfd19 View Drop Down
Senior Member
Senior Member


Joined: 20 December 2004
Status: Offline
Points: 263
Post Options Post Options   Thanks (0) Thanks(0)   Quote sfd19 Quote  Post ReplyReply Direct Link To This Post Posted: 20 January 2005 at 8:06pm
Originally posted by martionline martionline wrote:

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
 
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: StudentsforDemocracy.net
Back to Top
rdfonseca View Drop Down
Newbie
Newbie


Joined: 27 January 2005
Location: Portugal
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote rdfonseca Quote  Post ReplyReply Direct Link To This Post Posted: 27 January 2005 at 8:12am

My error is:

  • Error Type:
    Microsoft VBScript runtime (0x800A000D)
    Type mismatch: 'CDate'
    /website/forum/default.asp, line 154

  • Back to Top
    b_w_t View Drop Down
    Newbie
    Newbie


    Joined: 28 January 2005
    Location: Netherlands
    Status: Offline
    Points: 6
    Post Options Post Options   Thanks (0) Thanks(0)   Quote b_w_t Quote  Post ReplyReply Direct Link To This Post Posted: 28 January 2005 at 4:22pm
    Originally posted by sfd19 sfd19 wrote:

    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.
     
    This solved my problem too after I had re-located my website to a european server.
    Back to Top
    sfd19 View Drop Down
    Senior Member
    Senior Member


    Joined: 20 December 2004
    Status: Offline
    Points: 263
    Post Options Post Options   Thanks (0) Thanks(0)   Quote sfd19 Quote  Post ReplyReply Direct Link To This Post 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: StudentsforDemocracy.net
    Back to Top
    sfd19 View Drop Down
    Senior Member
    Senior Member


    Joined: 20 December 2004
    Status: Offline
    Points: 263
    Post Options Post Options   Thanks (0) Thanks(0)   Quote sfd19 Quote  Post ReplyReply Direct Link To This Post Posted: 03 February 2005 at 8:19pm
    Originally posted by rdfonseca rdfonseca wrote:

    My error is:

  • Error Type:
    Microsoft VBScript runtime (0x800A000D)
    Type mismatch: 'CDate'
    /website/forum/default.asp, line 154

  •  
    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: StudentsforDemocracy.net
    Back to Top
    TomBrien View Drop Down
    Newbie
    Newbie


    Joined: 01 May 2005
    Status: Offline
    Points: 1
    Post Options Post Options   Thanks (0) Thanks(0)   Quote TomBrien Quote  Post ReplyReply Direct Link To This Post 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
    Back to Top
     Post Reply Post Reply Page  <12

    Forum Jump Forum Permissions View Drop Down

    Forum Software by Web Wiz Forums® version 12.08
    Copyright ©2001-2026 Web Wiz Ltd.


    Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
    About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

    Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
    Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

    Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

    Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.