Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Seth Niemuth 275 posts 397 karma points
    Nov 25, 2011 @ 16:05
    Seth Niemuth
    0

    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

     

  • Seth Niemuth 275 posts 397 karma points
    Nov 25, 2011 @ 16:07
    Seth Niemuth
    0

    Forgot to mention, I am using SQL Server 2005. 

  • Seth Niemuth 275 posts 397 karma points
    Nov 29, 2011 @ 12:45
    Seth Niemuth
    0

    Does the datetime work for anyone with a SQL Database source? If so, what version of SQL server are you using?

  • Seth Niemuth 275 posts 397 karma points
    Nov 30, 2011 @ 15:56
    Seth Niemuth
    0

    Has anyone tried to use the SQL Database as a source on a contour form?

Please Sign in or register to post replies

Write your reply to:

Draft