Re: Date format problems

  •  04-13-2005, 10:31 AM

    Re: Date format problems

    Thanks for the swift reply,

    I have downloaded the standalone version again and tested it for you - same result I'm afraid. I assume the vital file to update is the CuteSoft.Chat assembly - I am now using a version time stamped 05/04 22:28 v2.0.0.0

    I have got a workaround now as I have been able to add a new user onto the production server which has its default language set to english (As opposed to british), this cures the problems I am seeing but for the record I did investigate a bit more for you:

    When profiling the issue I get the following SQL which causes issues:

    exec sp_executesql N'INSERT [Chat_Message] ([MessageTime],[ChannelId],[ChannelType],[ActionTime],[Location],[MessageType],[DetailsType],[DetailsReason],[TargetUserId],[TargetDisplayName],[TargetDeleted],[SenderUserId],[SenderDisplayName],[SenderDeleted],[Whisper],[Bold],[Italic],[Underline],[ForeColor],[FontName],[FontSize],[MessageText],[MessageHtml],[Info1],[Info2],[Info3],[Info4],[Info5],[InfoXml]) VALUES (CONVERT(DATETIME,@cdq_1),@cdq_2,@cdq_3,CONVERT(DATETIME,@cdq_4),@cdq_5,@cdq_6,@cdq_7,@cdq_8,@cdq_9,@cdq_10,@cdq_11,@cdq_12,@cdq_13,@cdq_14,@cdq_15,@cdq_16,@cdq_17,@cdq_18,@cdq_19,@cdq_20,@cdq_21,@cdq_22,@cdq_23,@cdq_24,@cdq_25,@cdq_26,@cdq_27,@cdq_28,@cdq_29)', N'@cdq_0 nvarchar(50),@cdq_1 nvarchar(50),@cdq_2 uniqueidentifier,@cdq_3 nvarchar(4000),@cdq_4 nvarchar(50),@cdq_5 nvarchar(4000),@cdq_6 nvarchar(4000),@cdq_7 nvarchar(4000),@cdq_8 nvarchar(50),@cdq_9 nvarchar(50),@cdq_10 nvarchar(50),@cdq_11 bit,@cdq_12 nvarchar(50),@cdq_13 nvarchar(50),@cdq_14 bit,@cdq_15 nvarchar(50),@cdq_16 nvarchar(50),@cdq_17 nvarchar(50),@cdq_18 nvarchar(50),@cdq_19 nvarchar(50),@cdq_20 nvarchar(50),@cdq_21 nvarchar(50),@cdq_22 nvarchar(50),@cdq_23 nvarchar(50),@cdq_24 nvarchar(50),@cdq_25 nvarchar(50),@cdq_26 nvarchar(50),@cdq_27 nvarchar(50),@cdq_28 nvarchar(50),@cdq_29 nvarchar(4000)', @cdq_0 = NULL, @cdq_1 = N'2005-04-13 15:24:15.625', @cdq_2 = 'EF47230F-882D-4D3A-B31E-7E20731B1E2E', @cdq_3 = N'Lobby', @cdq_4 = N'2005-04-13 15:24:15.625', @cdq_5 = N'Channel', @cdq_6 = N'Event', @cdq_7 = N'AddActiveOnline', @cdq_8 = NULL, @cdq_9 = NULL, @cdq_10 = NULL, @cdq_11 = 0, @cdq_12 = NULL, @cdq_13 = NULL, @cdq_14 = 0, @cdq_15 = NULL, @cdq_16 = NULL, @cdq_17 = NULL, @cdq_18 = NULL, @cdq_19 = NULL, @cdq_20 = NULL, @cdq_21 = NULL, @cdq_22 = NULL, @cdq_23 = NULL, @cdq_24 = NULL, @cdq_25 = NULL, @cdq_26 = NULL, @cdq_27 = NULL, @cdq_28 = NULL, @cdq_29 = N'<DataItem Type="CuteSoft.Chat.Chat_Active_Online"><Column Name="ChannelId" Value="ef47230f-882d-4d3a-b31e-7e20731b1e2e" /><Column Name="OnlineId" Value="13" /><Column Name="ClientId" Value="761d6d3a-a119-4598-ab9f-b53532911c88" /><Column Name="UserId" Value="13" /><Column Name="DisplayName" Value="al04" /><Column Name="IPAddress" Value="127.0.0.1" /><Column Name="BeginTime" Value="632490026556093750" /><Column Name="ActiveTime" Value="632490026556093750" /><Column Name="MessageTime" Value="632490026556093750" /><Column Name="OnlineStatus" Value="Online" /><Column Name="UserType" Value="NotSet" /><Column Name="Avatar" Value="administrators_default.gif" /><Column Name="TypingTime" /><Column Name="BlockedList" Value="" /></DataItem>'

    Hope this is enough detail for you. I do have a couple of other issues but I will post them separately.

View Complete Thread