Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

INT default 0 comes up blank?

Quote Reply
INT default 0 comes up blank?
When trying to add a new field (in the links table for eg.), if I select...

test,INT,3,3,NOTNULL=Yes,default=0

and submit it - it does not for some reason add the default of 0 to the table data? If I input a default of 0.0 or 1 it works fine.

Am I wrong in thinking type INT can have a default value of 0?

Quote Reply
Re: INT default 0 comes up blank? In reply to
If it is not a PRIMARY key field, then you should use unassigned as well.

Regards,

Eliot Lee

Quote Reply
Re: INT default 0 comes up blank? In reply to
Thanks Eliot,

I see in mysql man it gives me that option, but with the standard install of Links I can't alter that to add a new field - which was where it is playing up.

I'm not sure where to enter the 'validation' field using mysqlman that is asked for when adding a new 'link' field in LinksSQL?

Does that make sense? Only just to me :)

Quote Reply
Re: INT default 0 comes up blank? In reply to
The validation takes place in the Validate table.

Regards,

Eliot Lee