Re: [WebDNA] users.db

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103306
interpreted = N
texte = Eddie Z wrote: > Is naming a database users.db a no no? I’m pretty sure I just found out > the hard way that it is, but wanted to clarify. I’m not sure why I added > an s to the end of a database I normally would call user.db, but for > some reason I did and then I couldn’t figure out why my searches weren’t > working. This is a good time to revisit 'convensions' once again I think. ;-) Because WebDNA is written in basic English, it is *always* a good idea to use naming conventions that are not basic English... such as: Text vars prefixed with "T_": [text]T_name=Donovan[/text] Form vars prefixed with "F_": Math vars prefixed with "M_": [math show=f]M_total=3000[/math] Global text vars "G_": [text scope=global]G_T_var=somevalue[/text] Customers Database that is specific to a site called "yourdomain" could be called "YD_customers.db", then the fields: [YDC_NAME] [YDC_ADDRESS] etc.. You don't have to use what I have above, rather roll your own. Conventions help insure that you don't run into reserved names, and they can make it much clearer for a 3rd party programmer to see what is going on. Just my .02¢ :-) Donovan -- Donovan Brooke WebDNA Software Corporation http://www.webdna.us **[Square Bracket Utopia]** Associated Messages, from the most recent to the oldest:

    
Eddie Z wrote: > Is naming a database users.db a no no? I’m pretty sure I just found out > the hard way that it is, but wanted to clarify. I’m not sure why I added > an s to the end of a database I normally would call user.db, but for > some reason I did and then I couldn’t figure out why my searches weren’t > working. This is a good time to revisit 'convensions' once again I think. ;-) Because WebDNA is written in basic English, it is *always* a good idea to use naming conventions that are not basic English... such as: Text vars prefixed with "T_": [text]T_name=Donovan[/text] Form vars prefixed with "F_": Math vars prefixed with "M_": [math show=f]M_total=3000[/math] Global text vars "G_": [text scope=global]G_T_var=somevalue[/text] Customers Database that is specific to a site called "yourdomain" could be called "YD_customers.db", then the fields: [YDC_NAME] [YDC_ADDRESS] etc.. You don't have to use what I have above, rather roll your own. Conventions help insure that you don't run into reserved names, and they can make it much clearer for a 3rd party programmer to see what is going on. Just my .02¢ :-) Donovan -- Donovan Brooke WebDNA Software Corporation http://www.webdna.us **[Square Bracket Utopia]** Donovan Brooke

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Re:Dumb Question about Docs (1997) Generating unique SKU from [cart] - Still Stumped... (1997) [searchString] (1997) japanese characters (1997) SERIAL NUMBER BEING LOST AGAIN!!! (1999) Date or time comparisons have bugs ... (1998) Date fun with MySQL (2004) [WebDNA] Using WebDNA with MAMP (2010) forming a SKU (1999) Mac installer (2000) [Sum] function? (1997) WebTen and WebCat (1997) Search with Special Chars (1997) Testing (2003) OT Cookie limit (2001) How do you cause a new window to appear behind the currentwindow? (1999) WebCatalog2 Feature Feedback (1996) Running _every_ page through WebCat ? (1997) Shopping Cart Problem (1998) How About Credit Card Transactions (1998)