Re: Shopping with Accounts
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 48328
interpreted = N
texte = I generally use the same name, but with a three-letter prefix to identify the source of the field. So, if I had the address stored in member.db, the field name would be memShipToAddress1 and when written into order.db it would be ordShipToAddress1. I make sure that all fields in a given db begin with the sam three-letter prefix. For me, this cuts down on both the confusions you mention. I use similar techniques in naming my form, math and text variables.- brianOn Tuesday, March 4, 2003, at 09:43 AM, Kimberly D. Walls wrote:> I am looking for direction here... > > When you have a shopping site, where the shoppers' information (name, > address, etc.) are stored in a database... do most of you use the same > fieldnames to match the orderfile or not? For example, in the account > database, should I use shiptoaddress1 or should I use > address1ship? I > can see how using the same names would save confusion, but at the same > time, > I can see how it would create confusion... any feedback or opinion on > this? > > Thanks, > Kim > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com -- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I generally use the same name, but with a three-letter prefix to identify the source of the field. So, if I had the address stored in member.db, the field name would be memShipToAddress1 and when written into order.db it would be ordShipToAddress1. I make sure that all fields in a given db begin with the sam three-letter prefix. For me, this cuts down on both the confusions you mention. I use similar techniques in naming my form, math and text variables.- brianOn Tuesday, March 4, 2003, at 09:43 AM, Kimberly D. Walls wrote:> I am looking for direction here... > > When you have a shopping site, where the shoppers' information (name, > address, etc.) are stored in a database... do most of you use the same > fieldnames to match the orderfile or not? For example, in the account > database, should I use shiptoaddress1 or should I use > address1ship? I > can see how using the same names would save confusion, but at the same > time, > I can see how it would create confusion... any feedback or opinion on > this? > > Thanks, > Kim > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com -- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Brian Fries
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:
SiteGaurd file Cache vs webcatalog cache (1997)
[format xs] freeze (1997)
profiles (1999)
Storing calculated data (2002)
international time (1997)
Google image search results (2004)
Generating unique SKU from [cart] - Still Stumped... (1997)
transferring values (1998)
Paradata/Moneris Gateway (2005)
RE: protect tag on NT (1997)
Searching multiple fields (1997)
Date problems (1997)
TCPConnect strange behaviour (2004)
Limiting user access to .tmpl files (1997)
WCS Newbie question (1997)
no global [username] or [password] displayed ... (1997)
Multiple prices (1997)
Webcat listserver - WAS - webcat method for waitingspecific amount of time? (2000)
Dubble Sku's in a Database (1999)
Linux/webcat points (2000)