Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Date field defaults to 31/01/1900

  1. #11
    Sencha - Community Support Team Condor's Avatar
    Join Date
    Mar 2007
    Location
    The Netherlands
    Posts
    24,246
    Vote Rating
    118
      0  

    Default

    Are you getting any javascript exceptions?

  2. #12
    Sencha User
    Join Date
    Sep 2010
    Posts
    38
    Vote Rating
    1
      0  

    Default the program is not responding

    No, nothing. 'Just the program is not responding.'

  3. #13
    Sencha User
    Join Date
    Oct 2011
    Posts
    6
    Vote Rating
    0
      0  

    Default datefield issue

    Hello,

    I am using dateField with allowBlank = true because it is no mandatory to fill this field in the form. But when i click save I get an error : save Failed, sql error:PreparedStatementCallback; uncategorized SQLException for SQL [ INSERT INTO tableName (....) VALUES ( .....) ]; SQL state [null]; error code [17004]; Invalid column type; nested exception is java.sql.SQLException: Invalid column type.

    Please any help ?

    Thanks in advance.

  4. #14
    Sencha User
    Join Date
    Oct 2011
    Posts
    6
    Vote Rating
    0
      0  

    Default Insert null value for date field in oracle

    Hello,
    how can i insert a null value for a datefield in oracle database....
    i've used Date d = new Date(java.sql.Types.NULL);
    if (...) {
    sql = "INSERT INTO tableName( a, b, c, date) values (?, ?, ?, ?)";
    params = new Object[] {.... ,
    .... ,
    .... , (var.getaDate()==null)?d:var.getaDate() };
    }
    else{
    .... }
    try {
    jdbcTemplate.update(sql, params);
    return 0;
    } catch (Exception ex) {
    log.error("save() Failed, sql error:" + ex.getMessage());
    return -1;
    }
    using Date d = new Date(java.sql.Types.NULL); i get the date Jan 1, 1970 whenthe var.getDate()==null
    Thanks in advance !!!
    Best regards

Page 2 of 2 FirstFirst 12

Similar Threads

  1. using field.markInvalid() always defaults to 'side'
    By JeanNiBee in forum Ext 3.x: Help & Discussion
    Replies: 1
    Last Post: 16 Feb 2010, 3:15 AM
  2. How to change date format after a date field has been created?
    By lensesby in forum Ext 2.x: Help & Discussion
    Replies: 2
    Last Post: 3 Mar 2009, 7:11 AM
  3. Week Number in Date field / Date Packer
    By speedytangent in forum Ext 2.x: Help & Discussion
    Replies: 4
    Last Post: 15 Oct 2008, 2:01 AM
  4. Newbie Question about disable shadow of the date picker's date field
    By fm424946 in forum Ext 2.x: Help & Discussion
    Replies: 0
    Last Post: 13 Nov 2007, 9:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •