Gossamer Forum
Home : Products : Others : MySQLMan :

Re: [brewt] entering a default value of 0 with not null for an int column

Quote Reply
Re: [brewt] entering a default value of 0 with not null for an int column In reply to
Thanks for the fix Adrian it worked....
there is something else I noticed, unlike mysql 4 mysql 5 gives back 'NO' instead of '' for a column that is not null, this meant the selector in the alter form was defaulting to null even when the column was marked as not null so I mad a fix for it.

mysqlman/html.pl
sub html_alter_col

changed:
if ($null) { $null_select = '<option>null</option>' }
to:
if ($null eq 'YES') { $null_select = '<option>null</option>' }

Cheers
Subject Author Views Date
Thread entering a default value of 0 with not null for an int column chmodphil 13396 Apr 18, 2009, 7:33 AM
Thread Re: [chmodphil] entering a default value of 0 with not null for an int column
brewt 13015 Apr 18, 2009, 3:40 PM
Post Re: [brewt] entering a default value of 0 with not null for an int column
chmodphil 12994 Apr 18, 2009, 4:32 PM
Thread Re: [brewt] entering a default value of 0 with not null for an int column
brewt 12943 Apr 24, 2009, 8:15 PM
Post Re: [brewt] entering a default value of 0 with not null for an int column
chmodphil 12862 May 8, 2009, 6:37 AM