You need to Register for free and Login to post a message in the forum.

Forum

Subject: Date time issues
Prev Next
You are not authorized to post a reply.

Author Messages
ALEXw
Nuker
Nuker
Posts:19

22 Feb 2008 3:31 AM  
I've created a modules for an international company which adds tickets(jobs) to a database and gives specific people rights to alter those tickets.

The problem I have is additions of datetime. Every stored procedure (Select, Insert, Update) begins with :-

'SET DATEFORMAT dmy; INSERT INTO......' etc.

All SQLDatasource scripts begin with the same.

If someone adds a record, after clicking the UK locale, he/she can alter the record as many times as they want. If someone attempts to alter that record at a later date using the US locale I get the following error:-

Arithmetic overflow error converting expression to data type datetime. The statement has been terminated.

Can anyone help?

I used to use 'session.LCID = 2057' before I started using DNN, is there something you could recommend?

Every record MUST be added in the UK format. The US mdy or ymd will not be acceptable by the Company because they access the data from differnt software which requires the date to be in the UK format.

PS When populating the formview1 I specify DateTime.now and populating/updating uses the following:-

Public Shared Sub FormViewUpdateEventHandler(ByVal sender As Object, ByVal e As _

System.Web.UI.WebControls.FormViewUpdateEventArgs) _

Handles FormView1.ItemUpdating

e.NewValues("ChangedAt") = DateTime.Now

e.NewValues("ChangedBy") = Entities.Users.UserController.GetCurrentUserInfo.DisplayName


Can anyone help?

Alex

ALEXw
Nuker
Nuker
Posts:19

09 Mar 2008 12:30 PM  
Dont all rush to reply.....I think I have sorted it anyway as a quick fix.......I just decoded the date and set the DBs date fields to NVarchar. Frigging Microsoft need yo get their finger out of their arse and fix this issue. They have to realise that not everyone comes from the states!!!!!!

If anyone needs to know what I've done....reply....you too can be deafened by silence.

Alex
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2318


09 Mar 2008 12:44 PM  
Alex,

I'm sorry that we weren't able to help you, but I'm glad that your were able to work around the issue.

Joe Craig
DNN Creative Support
Subscribe to the website
You are not authorized to post a reply.



ActiveForums 3.7

Latest Forum Posts

Site is not opening by kaustav_kar
Hi,Whenever I'm writing the url (http://tajfood.com.sa/) it's showing the following error; Index of...
RE: SolPart Menu Font Color Control by cdees
 Lee, Is there documentation, or perhaps a tutotial on activating and using Nav menu?  Where would I...
RE: EasyCGI help? by Dr Joe
I found some interesting posts on some other sites that explain some of the challenges I've been exp...
RE: Menu's, menu's, and more menu's! by roadshow41
Thanks! I'm still a bit curious about some of the other options, but I think that gives me enough c...
RE: Menu's, menu's, and more menu's! by leesykes
Hello,Yes that should be possible with snapsis, I have used snapsis CSS with flyout menus on a horiz...
RE: Menu's, menu's, and more menu's! by roadshow41
I typically end up using a hybrid of a vertical menu and a horizontal menu due to the sheer number o...
DotNetNuke SEO (Search Engine Optimization) by leesykes
Hello,I regularly get asked for tips on SEO with DotNetNuke, there are several resources available o...
RE: Menu's, menu's, and more menu's! by leesykes
Hello,If you are looking for a menu for SEO reasons, any CSS based unordered list menu will be SEO f...
Menu's, menu's, and more menu's! by roadshow41
Well, I've been trying to steam ahead with the DNN sites I inherited a few months ago.  I've found l...
RE: EasyCGI help? by derpir
Hi Lee I told them that solution two days ago and still no answer, but thanks for suggesting that s...
RE: quick question by derpir
Hithanks! yes I understand. I will deal with my skins more tomorrow, maybe some questions will arriv...
RE: Restart Application by leesykes
It will restart your DotNetNuke installation and reload the application.Clearing cache will clear th...
RE: How can i edit any module from front end by leesykes
hello,I have just tested this and can see exactly the same as you, I suspect the core team have set ...
RE: EasyCGI help? by leesykes
You may want to ask them to reset the correct permissions on your DotNetNuke installation files, som...
RE: quick question by leesykes
Hello,It will be possible to a degree, but it depends on how both of the skins have been built. You ...
RE: EasyCGI help? by Dr Joe
I'll let you know how it works out. I think I opened up about 6 tickets with them so far. ...
RE: EasyCGI help? by derpir
Hi Joe amazing to say the least! I will change host to PowerDNN as soon as possible, seems to me t...
RE: EasyCGI help? by Dr Joe
Amazing - I'm going through this exact same thing with EasyCGI! I managed to successfully instal...
Running the local host installation after building the application by saintX
My localhost installation of DNN was running blameless. After I oppened the application with VWD it ...
RE: quick question by derpir
Hello Is it possible to buy two skins and combine them? for example put one skins visual attributes...
DotNetNuke Modules
RSS Feeds