Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

style question

Aug 3, 2010, 1:35 PM
delicia
User (393 posts)
Aug 3, 2010, 1:35 PM
Post #1 of 9
Views: 1499
Shortcut
Quote Reply
style question
just wondering if there is a recommended style for capitalization of table and field names etc. thanks
Aug 3, 2010, 3:23 PM
MJB
Enthusiast (511 posts)
MJB's avatar
Aug 3, 2010, 3:23 PM
Post #2 of 9
Views: 1470
Shortcut
Quote Reply
Re: [delicia] style question In reply to
Try this (or rather, one of these):

Code:
strong {
text-transform: lowercase; /* force text to lowercase */
text-transform: uppercase; /* force text to uppercase */
text-transform: capitalize; /* force text to proper case */
}

or

Code:
div.uppercase {text-transform: uppercase;}

div.caps {text-transform: capitalize;}

Last edited by:

MJB: Aug 3, 2010, 3:24 PM
Aug 3, 2010, 3:25 PM
MJB
Enthusiast (511 posts)
MJB's avatar
Aug 3, 2010, 3:25 PM
Post #3 of 9
Views: 1468
Shortcut
Quote Reply
Re: [MJB] style question In reply to
Some more examples here.
Aug 4, 2010, 12:15 AM
Andy
Veteran / Moderator (17364 posts)
Andy's avatar
Aug 4, 2010, 12:15 AM
Post #4 of 9
Views: 1461
Shortcut
Quote Reply
Re: [delicia] style question In reply to
delicia wrote:
just wondering if there is a recommended style for capitalization of table and field names etc. thanks

Are you refering to the actual field/table names themselves, OR as MJB suggested with the CSS?

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Aug 4, 2010, 10:18 AM
delicia
User (393 posts)
Aug 4, 2010, 10:18 AM
Post #5 of 9
Views: 1442
Shortcut
Quote Reply
Re: [Andy] style question In reply to
you got it - the actual field names and table names, i.e. username vs Username
Aug 4, 2010, 10:32 AM
Andy
Veteran / Moderator (17364 posts)
Andy's avatar
Aug 4, 2010, 10:32 AM
Post #6 of 9
Views: 1446
Shortcut
Quote Reply
Re: [delicia] style question In reply to
Hi,

Well, personally I prefer "Username", over "username" .. and if you have multiple words, i.e "User_Password" instead of "user_password"

To be honest though, there is no "standard" as such. Some people even do it as USERNAME or USER_PASSWORD (not my cup of tea though =))

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Aug 4, 2010, 3:11 PM
delicia
User (393 posts)
Aug 4, 2010, 3:11 PM
Post #7 of 9
Views: 1432
Shortcut
Quote Reply
Re: [Andy] style question In reply to
well, if there's no standard, i like your style best.
Aug 4, 2010, 4:16 PM
brewt
Staff (4071 posts)
brewt's avatar
Aug 4, 2010, 4:16 PM
Post #8 of 9
Views: 1431
Shortcut
Quote Reply
Re: [Andy] style question In reply to
See: http://en.wikipedia.org/...on_%28programming%29

You usually don't put delimiters between words when you do camel case (eg. UserPassword).

Adrian
Aug 4, 2010, 11:30 PM
Andy
Veteran / Moderator (17364 posts)
Andy's avatar
Aug 4, 2010, 11:30 PM
Post #9 of 9
Views: 1420
Shortcut
Quote Reply
Re: [brewt] style question In reply to
brewt wrote:
See: http://en.wikipedia.org/...on_%28programming%29

You usually don't put delimiters between words when you do camel case (eg. UserPassword).

True - I was just giving some examples Angelic

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates