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:5203 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
