BUG: Datasource with SQL Database with Datetime will not save into database
I have a form with a datasource of a SQL Database table. There are no foreign keys on the table. There are 2 datetime items in the table. When I save the form, it does not get saved into the database. There is no error given. It just does not save into the database. However, if I do not include the 2 datetime fields in the form, it saves into the database just fine. I don't know if this is also possibly a culture problem as I am using EN-gb.
.NET 4
Umbraco 4.7.1
Contour 1.1.11
Here is a copy of my sql script to create the database table:
To recreate just use this table as a datasource for a form and then fill out the form and it will not save into the database.
BUG: Datasource with SQL Database with Datetime will not save into database
I have a form with a datasource of a SQL Database table. There are no foreign keys on the table. There are 2 datetime items in the table. When I save the form, it does not get saved into the database. There is no error given. It just does not save into the database. However, if I do not include the 2 datetime fields in the form, it saves into the database just fine. I don't know if this is also possibly a culture problem as I am using EN-gb.
.NET 4
Umbraco 4.7.1
Contour 1.1.11
Here is a copy of my sql script to create the database table:
To recreate just use this table as a datasource for a form and then fill out the form and it will not save into the database.
CREATE TABLE [dbo].[ClubOrder](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Title] [nvarchar](255) NOT NULL,
[FirstName] [nvarchar](255) NOT NULL,
[Surname] [nvarchar](255) NOT NULL,
[Address1] [nvarchar](255) NOT NULL,
[Address2] [nvarchar](255) NULL,
[City] [nvarchar](255) NOT NULL,
[State] [nvarchar](255) NOT NULL,
[Postcode] [nvarchar](255) NOT NULL,
[Dob] [datetime] NOT NULL,
[PaymentStatus] [nvarchar](255) NULL,
[Telephone] [nvarchar](255) NOT NULL,
[Email] [nvarchar](255) NOT NULL,
[TwitterUsername] [nvarchar](255) NULL,
[DateOfNextStay] [datetime] NULL,
[Interests] [nvarchar](255) NULL,
[OtherInterests] [nvarchar](255) NULL,
[Amount] [decimal](18, 2) NULL
PRIMARY KEY (Id))
GO
Forgot to mention, I am using SQL Server 2005.
Does the datetime work for anyone with a SQL Database source? If so, what version of SQL server are you using?
Has anyone tried to use the SQL Database as a source on a contour form?
is working on a reply...