Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Date null = 0000-00-00

Quote Reply
Date null = 0000-00-00
I want to get rid of displaying 0000-00-00 if date value is left unfilled.

On original add form, it shows fine ie blank textbox, but when I submit, it and then later try to modify it, it shows 0000-00-00 on text box.



How do I get rid of these 0's.

Do I need to add clobal template maybe? Or is it just setting up the values. Currently I have set date box to NULL in MySQL.

Thx



On original add recored the textbox value is set to: value=""

And on modify form is set to: value="<%Birthday%>"

Last edited by:

Suomi: Mar 17, 2002, 10:12 AM
Subject Author Views Date
Thread Date null = 0000-00-00 Suomi 8162 Mar 17, 2002, 10:01 AM
Thread Re: [Suomi] Date null = 0000-00-00
604 8072 Mar 18, 2002, 9:13 AM
Thread Re: [TheStone] Date null = 0000-00-00
Suomi 8100 Mar 18, 2002, 9:51 AM
Thread Re: [Suomi] Date null = 0000-00-00
604 8100 Mar 18, 2002, 9:57 AM
Thread Re: [TheStone] Date null = 0000-00-00
Suomi 8099 Mar 18, 2002, 10:21 AM
Thread Re: [Suomi] Date null = 0000-00-00
604 8045 Mar 18, 2002, 10:40 AM
Thread Re: [TheStone] Date null = 0000-00-00
Suomi 8051 Mar 18, 2002, 11:10 AM
Post Re: [Suomi] Date null = 0000-00-00
604 8063 Mar 18, 2002, 11:30 AM
Thread Re: [Suomi] Date null = 0000-00-00
Paul 8028 Mar 18, 2002, 1:03 PM
Thread Re: [Paul] Date null = 0000-00-00
Suomi 8026 Mar 18, 2002, 4:14 PM
Thread Re: [Suomi] Date null = 0000-00-00
Halito 8030 Apr 2, 2002, 1:10 AM
Post Re: [Halito] Date null = 0000-00-00
Suomi 8037 Apr 2, 2002, 7:53 PM
Post Re: [Halito] Date null = 0000-00-00
Reena0330 7737 Aug 7, 2002, 2:12 PM