Re: QF or FB: how to allow a NULL for date field?

On Fri, 7 Jan 2005 18:46:57 -0800 (PST), l Burnerheimerton <lburnerheimerton@yahoo.com> wrote: > > --- Justin Patrin <papercrane@gmail.com> wrote: > > > On Fri, 7 Jan 2005 18:27:10 -0800 (PST), l > > Burnerheimerton > > <lburnerheimerton@yahoo.com> wrote: > > > What I have so far is this: > > > > > > function preGenerateForm() { > > > $opt = array('Y' => 2002, 'M' => 12, 'd' => > > > 28); > > > $this->fb_selectAddEmpty['dateSTAT'] = > > > HTML_QuickForm::createElement('date', 'dateSTAT', > > > 'Date STAT: ',$opt); > > > > Get rid of that, you don't need it. > > > > > } > > It's not displaying the empty choice as default on a > new form. That;s what I want it to do. > > The code: > $opt = array('Y' => 2002, 'M' => 12, 'd' => 28); > > was just to see if I could set it's default which that > did not work. > > Any ideas to make it default to the empty choice in > the selection of date? Read my previous e-mail. > > > > > > var $fb_selectAddEmpty = array('dateSTAT'); > > > > The above line is right. > > > > > > > > It displays an empty choice but still defaults to > > > todays date. How do I get it to default to the > > empty > > > selection choice? > > > > > > I see no option for setting the default - yes I > > RTM. > > > If I set it directly, it overrides the record on > > edit. > > > > The _date2Array function converts NULL to the > > current date. You could > > define your own dateFromDatabaseCallback to handle > > this. > > > > > > > > > > > --- Justin Patrin <papercrane@gmail.com> wrote: > > > > > > > Please send text e-mails to the list, not HTML. > > Your > > > > inline comments > > > > are nearly indistinguishable from the mail I > > sent > > > > earlier. > > > > > > > > On Fri, 7 Jan 2005 13:51:34 -0800 (PST), l > > > > Burnerheimerton > > > > <lburnerheimerton@yahoo.com> wrote: > > > > > Justin Patrin <papercrane@gmail.com> wrote: > > > > > > > > > > > > > > > On Fri, 7 Jan 2005 12:27:12 -0800 (PST), l > > > > Burnerheimerton > > > > > wrote: > > > > > > I have several forms where that track status > > of > > > > a process. I have been > > > > > building the forms based on using a date field > > - > > > > if datefiled = '0000-00-00' > > > > > //default for database field, then that status > > has > > > > not happened yet. > > > > > > > > > > > > However, when using either QuickForm or > > > > FormBuilder, the date field is > > > > > generated in such a way that it will always > > enter > > > > a date in the field. > > > > > > > > > > > > OPTION 1 - figure out a way around this. > > > > > > > > > > > > OPTION 2 - restructure my tables to add an > > > > additional field (Yes/No) to > > > > > track each status. > > > > > > > > > > > > Your thoughts? > > > > > > > > > > > > > > > > Do you allow "null" in the date fields? Try > > > > putting the date field in > > > > > fb_selectAddEmpty. > > > > > > > > > > Here's what I tried: > > > > > > > > > > $this->fb_selectAddEmpty['dateStatusA'] = > > > > > HTML_QuickForm::createElement('date', > > > > 'dateStatusA', 'Status A Completed: > > > > > '); > > > > > > > > RTFM > > > > > > > > > > > http://opensource.21st.de/tiki-index.php?page=Formbuilder+configuration+options#id487538UH
þc| > +°‡ª·Oqáy > > > > This is an array of field *names*. You only put > > > > element objects in > > > > preDefElements. > > > > > > > > > > > > > > It did not present an empty data selection - > > > > displayed the nornal select > > > > > 1-31 for days, 1 - 12 for months... > > > > > > > > > > I don't think your other option would because > > when > > > > the form is displayed it > > > > > defaults to todays date. If no date is > > selected, > > > > that date - the default > > > > > date - is inserted in to the database. That > > MIGHT > > > > be the actual date the > > > > > user intended or maybe not. > > > > > > > > > > The only way I can tell is if the default data > > is > > > > 0000-00-00. > > > > > > > > > > If I can't get an empty default - my > > preference - > > > > to work, is there an > > > > > option for offering selection dates through an > > > > array consisting of a default > > > > > of 0000-00-00 and year 2001 - 2010? Right > > now, I > > > > can only see that if I > > > > > want the lower range to 0000-00-00 it will > > create > > > > 2005 selection choices for > > > > > years. > > > > > > > > > > Thanks for any ideas! > > > > > > > > > > > > > > > If that doesn't work you can also use > > > > preProcessForm to check for a > > > > > "null" date and either set it to "0000-00-00" > > or > > > > > DB_DataObject_Cast::sql('NULL'); > > > > > > > > > > > > > -- > > > > Justin Patrin > > > > > > > > -- > > > > PEAR General Mailing List (http://pear.php.net/) > > > > To unsubscribe, visit: > > http://www.php.net/unsub.php > > > > > > > > > > > > -- > > Justin Patrin > > -- Justin Patrin