Gossamer Forum
Quote Reply
Creating a column ENUM
I am creating a couple of columns in a custom table and I want this particular one to be an ENUM (boolean?) with the options exclusivley 'Yes' or 'No'. What should I change to do this?

'ShowEmail' => {
pos => 12,
type => 'ENUM',
not_null => 1,
default => 'Yes',
size => 3
},



Also, I understand you can display 'Yes' or 'No' but record 1 or 0 in the database for performance gain. Is this really worth it? and if it is, how do I change this code to do it?

Thanks.


http://www.iuni.com/...tware/web/index.html
Links Plugins
Quote Reply
Re: [sooke] Creating a column ENUM In reply to
This is really a links sql specific question but the answer can be found in the help docs in your links sql admin panel.

admin.cgi?do=help&topic=help_guide_libs.html

SQL > Creator

Last edited by:

Paul: May 18, 2002, 2:10 AM
Quote Reply
Re: [] Creating a column ENUM In reply to
I've moved this thread for you.

- wil
Quote Reply
Re: [Wil] Creating a column ENUM In reply to
Sorry, yes... I was thinking that a while after I made the postBlush. I'll try to be more careful.

Thanks Paul. (to the rescue again!). You should be made honorary support desk by GT.

You know I looked through the manual, but never thought that there was that much in the inbuild version. This has opened new doorsSmile


http://www.iuni.com/...tware/web/index.html
Links Plugins

Last edited by:

sooke: May 18, 2002, 8:56 AM