Radicore Forum: Bug Reports » Error with date field

Home » RADICORE development » Bug Reports » Error with date field

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Error with date field [message #7819 is a reply to message #7818]

Sun, 26 March 2023 05:29

htManager
Messages: 439
Registered: May 2014

Senior Member

Yes, I know. I thought that if I set NULL as default in the table structure, this would be made automatically. I attached a picture of my table structure.

If I execute "INSERT INTO test_datum SET `id`='4', `test_datum`=NULL" instead of "INSERT INTO test_datum SET `id`='4', `test_datum`=''" the record will be inserted correctly without "0000-00-00".

Is there a setting to handle a blank value '' explecitly as NULL?

Attachment: Structure date.jpg
(Size: 42.42KB, Downloaded 809 times)

Report message to a moderator

[Message index]

		Error with date field By: htManager on Tue, 28 February 2023 06:01
		Re: Error with dictionary import By: AJM on Tue, 28 February 2023 07:02
		Re: Error with dictionary import By: htManager on Wed, 01 March 2023 12:30
		Re: Error with dictionary import By: AJM on Wed, 01 March 2023 13:11
		Re: Error with dictionary import By: htManager on Wed, 01 March 2023 16:55
		Re: Error with dictionary import By: AJM on Thu, 02 March 2023 04:42
		Re: Error with dictionary import By: htManager on Thu, 02 March 2023 12:22
		Re: Error with dictionary import By: AJM on Fri, 03 March 2023 04:42
		Re: Error with dictionary import By: htManager on Tue, 07 March 2023 18:16
		Re: Error with date field By: htManager on Thu, 23 March 2023 10:51
		Re: Error with date field By: AJM on Fri, 24 March 2023 05:28
		Re: Error with date field By: htManager on Fri, 24 March 2023 11:40
		Re: Error with date field By: AJM on Sat, 25 March 2023 05:27
		Re: Error with date field By: htManager on Sat, 25 March 2023 06:58
		Re: Error with date field By: htManager on Sat, 25 March 2023 08:02
		Re: Error with date field By: AJM on Sun, 26 March 2023 04:16
		Re: Error with date field By: htManager on Sun, 26 March 2023 05:29
		Re: Error with date field By: AJM on Mon, 27 March 2023 04:45
		Re: Error with date field By: htManager on Mon, 27 March 2023 05:18
		Re: Error with date field By: AJM on Tue, 28 March 2023 04:40
		Re: Error with date field By: htManager on Fri, 31 March 2023 12:49
		Re: Error with date field By: AJM on Sat, 01 April 2023 04:50
		Re: Error with date field By: htManager on Sat, 01 April 2023 09:00
		Re: Error with date field By: AJM on Sun, 02 April 2023 04:43
		Re: Error with date field By: htManager on Sun, 02 April 2023 05:29
		Re: Error with date field By: AJM on Mon, 03 April 2023 04:37
		Re: Error with date field By: htManager on Mon, 03 April 2023 09:09
		Re: Error with date field By: AJM on Tue, 04 April 2023 04:44
		Re: Error with date field By: htManager on Wed, 05 April 2023 09:48

Previous Topic:	PHP 8 - ListViewPrintAfter()
Next Topic:	File classes/mnu_chart.class.inc is missing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 28 20:36:35 EST 2024

Total time taken to generate the page: 0.01244 seconds