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?

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies