Hey.. Just my 2 cents on the database / table names... I agree.. the 'q' - is useless - not even sure how that came to be, but I'd like to shoot the guy who first suggested it.
I also prefer colum names: nameID, productID and table names to be relavent to the content. The first case Cap or not is your preference; but at a minimum the labelilng method you choose should be human readable and not some wacked out abbrevation that only you can decifer. Put your self in the next developer's shoes - could *YOU* figure it out if you had no knowledge of what the database was for? Just sayin'... On Fri, Jan 14, 2011 at 3:13 PM, Phillip Vector <[email protected]>wrote: > > On Fri, Jan 14, 2011 at 10:22 AM, Adam Parker <[email protected]> wrote: > > > > Thanks again for the help. > > Not a problem. Reason why the list is here. :) > > > Out of curiosity, what is it about the naming convention that does not > appeal to you? > > It may just be me. But the q is pointless. It looks out of place and > we already know it's a query. I also personally like the first letter > to be capital. > > > Regarding the ids, I have a habit of creating tables and plugging in an > id field as the PK. > Should I not be doing this? Are you suggesting using > poemID as the ID field and PK? > > Like I said, when you do queries that have multiple tables, you are > going to run into trouble when you have 2 or more fields labeled ID > and you won't know which one came from which table. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5204 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
