Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...

Or... now make it easy with Facebook Integration
Connect via Facebook

Top Sellers

Dynamic Registration 4.0

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery 4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

XMod Pro 2.7 - Forms and Views for Databases

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

Smith Shopping Cart v3.88

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

Event Calendar and Registration 4.0

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

DNN Modules

Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
inserting null value for date field
Last Post 05-22-2009 09:22 AM by Nathan Botts. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Nathan BottsUser is Offline
wading in the water
wading in the water
Posts:20
Avatar

--
05-20-2009 06:10 AM

    Hello,

    I have a form that at times people will be inserting null date values for. Currently when a null is entered it automatically assigns the date "01/01/1900". I looked for a function in the module that controls this, but can't seem to find anything.

    How can I keep it from doing this?

     

    Thanks, Nathan
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    05-20-2009 06:41 AM
    HI Nathan, you won't find the control for this in the module. I believe it's hard-coded into the programming source code. -- David
    Nathan BottsUser is Offline
    wading in the water
    wading in the water
    Posts:20
    Avatar

    --
    05-20-2009 06:47 AM

    Hi David,

    Ok, so what is my option for fixing this?

    -Nathan
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    05-20-2009 07:22 AM
    You can perform an SQL update statement to change the value of the date to something else other 1/1/1900 under HOST / SQL or SQL management studio. Did you save the DF form submission to a custom SQL table with the datefield? If not, then the default sql table should be under dynamicforms_questionresponse and dynamicforms_question. Note the "DynamicQuestionID" is the one you want to match as well as the ModuleID. Dynamicforms_question has all the questions that you created on all your DF forms (all the modules) so you need to get the "DynamicQuestionID" for this moduleID you are wanting to change. And then match that "DynamicQuestionID" to the dynamicforms_questionresponse table to update the value for the date. -- David
    Nathan BottsUser is Offline
    wading in the water
    wading in the water
    Posts:20
    Avatar

    --
    05-20-2009 09:21 AM
    Thanks David,

    I am using my own tables for this information so that part isn't a problem.

    I guess I would like to understand better why this is happening with the form. I'm sure there are many forms in which a date field might possibly be left blank and can't see that everyone would be creating some sort of update trigger.

    Not to belabor this, but is there a reason this is happening?

    Thanks, Nathan
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    05-20-2009 09:29 AM
    If a datefield is left blank, it actually has a message "Error saving date response". On your DF page, turn debug mode on and then fill out your form (leave the datefield blank) and click submit. You should see the values being passed. It doesn't like blank entries and will replace it with message "Error saving date response" so that's why that message gets converted to a datetime of 1/1/1900 when saving to the database. -- David
    Nathan BottsUser is Offline
    wading in the water
    wading in the water
    Posts:20
    Avatar

    --
    05-22-2009 09:22 AM

    Hmmmm, ok thanks, Nathan
    You are not authorized to post a reply.

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
     
     

    Join our mailing list...

    Get current news and events the easy way
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi