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 #7820 is a reply to message #7819]

Mon, 27 March 2023 04:45

AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK

Senior Member

No, there is not. If your CREATE TABLE script states "DEFAULT NULL" then if you do not supply a value in an INSERT statement then MySQL will use that default value instead. If you want to remove the value in an update then you must explcity set it to NULL, not ''.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

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 18:24:13 EST 2024

Total time taken to generate the page: 0.01476 seconds