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

  New Posts New Posts RSS Feed - Error DTMDATE in Version 7.6
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Error DTMDATE in Version 7.6

 Post Reply Post Reply Page  12>
Author
RAVALON View Drop Down
Groupie
Groupie
Avatar

Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132
Post Options Post Options   Thanks (0) Thanks(0)   Quote RAVALON Quote  Post ReplyReply Direct Link To This Post Topic: Error DTMDATE in Version 7.6
    Posted: 13 March 2005 at 7:38am
Hello....i use WebWizForum from 1 year...
 
yesterday i received a message like this
 
Type Mismatch: 'dtmdate'
in file functions_date_time_format.asp
 
I look for incriminated string and i obtain this code
 
-------------------------------------------------
If strTimeOffSet = "+" Then
            dtmTempDate = DateAdd("h", + intTimeOffSet, dtmDate)
ElseIf strTimeOffSet = "-" Then
            dtmTempDate = DateAdd("h", - intTimeOffSet, dtmDate)
End If
-------------------------------------------------
 
I can see in the posts where i obtain error, dtmdate is empty, so it cannot use for a date type...
 
How can i resolve this problem ?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 13 March 2005 at 7:59am
If you get this error then it means that for some reason a date is not being passed to the function.

You haven't said on what page and where the error is coming up, so it's hard to tell the exact problem.

If the date is coming from the database, then it could be that you have a corrupted database, if you are using access. Running a compact and repair on the database may resolve the issue.

If the date is coming from another source such as a cookie, then you may have a corrupted cookie, which is not uncommon with Internet Explorer, and you may need to clean out your cookie cache.
Back to Top
RAVALON View Drop Down
Groupie
Groupie
Avatar

Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132
Post Options Post Options   Thanks (0) Thanks(0)   Quote RAVALON Quote  Post ReplyReply Direct Link To This Post Posted: 13 March 2005 at 8:15am
yeah....i resolved problem...
 
The errorr appear because of different LCID value in common.asp and in my personal configuration file in my site....
 
in common asp i have LCID=1033 for UK server and in my configuration file i have 1044 for italian server....i modify the values for corresponding to italiana where needed and to uk where needed...
 
Sorry...and thanks !
Back to Top
RAVALON View Drop Down
Groupie
Groupie
Avatar

Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132
Post Options Post Options   Thanks (0) Thanks(0)   Quote RAVALON Quote  Post ReplyReply Direct Link To This Post Posted: 05 October 2005 at 10:38am
no....problem not resolved....
 
i obtain again this error....the page is Forum_Posts.asp
 
i put a response.write information, and i obtain, for the case with error (not in all thread i have error) data value passed as numeric value, .....some similar to this for example....
 
38553.7342013889  
 
...or empty value....so no date passed.....or passed as a number...
 
i don't know how...
 
someone could help me ?Confused
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 05 October 2005 at 11:17am
Becuase of problesm with verious date formats the date is strored as a number.

VBScript stores dates as a number in secounds since Jan 1st 1899, or some point around that time.

The number you see is the number of secounds since that date, by using the CDATE function VBScript is able to convert the number back into a date and time.
Back to Top
RAVALON View Drop Down
Groupie
Groupie
Avatar

Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132
Post Options Post Options   Thanks (0) Thanks(0)   Quote RAVALON Quote  Post ReplyReply Direct Link To This Post Posted: 05 October 2005 at 12:15pm

if i try to use CDATE function i have message "Type Mismatch :Cdate"

i don't understand...Confused
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 05 October 2005 at 12:18pm
This then means that the date is not being correctly save and/or read back in.

This is usually to do with locale issues on the server and without access to the server the best way to correct this is to change the LCID number in the common.asp file.

I am working on a more perminent robust solution for future versions that will use an alterntive method to get around these problems with servers not having the locale settings set properly on them.
Back to Top
RAVALON View Drop Down
Groupie
Groupie
Avatar

Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132
Post Options Post Options   Thanks (0) Thanks(0)   Quote RAVALON Quote  Post ReplyReply Direct Link To This Post Posted: 05 October 2005 at 12:22pm
ok Borg....and for the moment how could i resolve ? what do you think is best solution ?
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.