Re: Shopping with Accounts

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 48310
interpreted = N
texte = Kimberly D. Walls wrote:>I am looking for direction here... > I always head west, but I have been thinking about the east quite a bit lately. :-o> >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? > I guess I don't use the same name for the possible instance of confusion. And, because I was told not to use variables reserved by WebDNA when I first started ;-). However, I'm sure variables that are named the same can be coded in a way to avoid conflict. It just makes it easier for me to grasp when things are different. A confusing example might be (below):[orderfile cart=[cart]] [COMPANY]'s orders:
[search db=prev_orders.db&eqCOMPANYdatarq=[company]] [founditems] [index], [company],[shiptoname], [shiptoemail], [ordernumber]
[!] does WebDNA see the database field name company etc. or the company in the orderfile?? (I don't know)[/!] [/founditems]
[/search] [lineitems]

Related Items for product number [SKU]
[search db=related.db&eqSKUdatarq=[SKU]] [founditems]   [index], [SKU], [PRICE]
[!] does WebDNA see the database field name SKU and PRICE etc.. or the SKU and PRICE in the lineitems?? (I don't know)[/!] [/founditems] [/search] [/lineitems][/orderfile]Again, there are ways to code the above to get it to do what you want, so consider the above just an example of the possible confusion.Donovan > 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 > > -- -Donovan Brooke -Administrator of IT / -Assc. Art Director -Creative Services -Epsen Hillmer Graphics-402.829.0123 ------------------------------------------------------------- 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:

    
  1. Re: Shopping with Accounts (Donovan 2003)
  2. Re: Shopping with Accounts (Kimberly D. Walls 2003)
  3. Re: Shopping with Accounts (Brian Fries 2003)
  4. Re: Shopping with Accounts (marc@kaiwi.com (Marc Kaiwi) 2003)
  5. Re: Shopping with Accounts (Dan Strong 2003)
  6. Re: Shopping with Accounts (Donovan 2003)
  7. Re: Shopping with Accounts (marc@kaiwi.com (Marc Kaiwi) 2003)
  8. Re: Shopping with Accounts (Donovan 2003)
  9. Re: Shopping with Accounts (Charles Kline 2003)
  10. Re: Shopping with Accounts (marc@kaiwi.com (Marc Kaiwi) 2003)
  11. Re: Shopping with Accounts (Clint Davis 2003)
  12. Shopping with Accounts (Kimberly D. Walls 2003)
Kimberly D. Walls wrote:>I am looking for direction here... > I always head west, but I have been thinking about the east quite a bit lately. :-o> >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? > I guess I don't use the same name for the possible instance of confusion. And, because I was told not to use variables reserved by WebDNA when I first started ;-). However, I'm sure variables that are named the same can be coded in a way to avoid conflict. It just makes it easier for me to grasp when things are different. A confusing example might be (below):[orderfile cart=[cart]] [COMPANY]'s orders:
[search db=prev_orders.db&eqCOMPANYdatarq=[company]] [founditems] [index], [company],[shiptoname], [shiptoemail], [ordernumber]
[!] does WebDNA see the database field name company etc. or the company in the orderfile?? (I don't know)[/!] [/founditems]
[/search] [lineitems]

Related Items for product number [SKU]
[search db=related.db&eqSKUdatarq=[SKU]] [founditems]   [index], [SKU], [PRICE]
[!] does WebDNA see the database field name SKU and PRICE etc.. or the SKU and PRICE in the lineitems?? (I don't know)[/!] [/founditems] [/search] [/lineitems][/orderfile]Again, there are ways to code the above to get it to do what you want, so consider the above just an example of the possible confusion.Donovan > 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 > > -- -Donovan Brooke -Administrator of IT / -Assc. Art Director -Creative Services -Epsen Hillmer Graphics-402.829.0123 ------------------------------------------------------------- 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/ Donovan

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:

[Announce]: Web server security and password protection (1997) problem serving foreign languages text (1997) NT Manual (1997) textarea inputs and returns (1999) 2.0 Info (1997) Forms Search Questions (1997) [OT] - CyberCash/Verisign (2001) WebCat2 - [format thousands] (1997) Separate SSL Server (1997) Automatically submitting form with web cat. (2001) Switching from merge to tab delimited..(v 2.x) (2000) Multiple security dbs (1997) NT Setup (1998) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) carriage returns in data (1997) Re:2nd WebCatalog2 Feature Request (1996) Max Record length restated as maybe bug (1997) [protect] locks out anyone (2003) Re:PCS Customer submissions ? (1997) WebCat2b13 Command Reference Doc error (1997)