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 wastold not to use variables reserved by WebDNA when I first started ;-).  However, I'msure variables that are named the same can be coded in a way to avoid conflict. It justmakes 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 justan 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:

Re: Shopping with Accounts (Donovan 2003) Re: Shopping with Accounts (Kimberly D. Walls 2003) Re: Shopping with Accounts (Brian Fries 2003) Re: Shopping with Accounts (marc@kaiwi.com (Marc Kaiwi) 2003) Re: Shopping with Accounts (Dan Strong 2003) Re: Shopping with Accounts (Donovan 2003) Re: Shopping with Accounts (marc@kaiwi.com (Marc Kaiwi) 2003) Re: Shopping with Accounts (Donovan 2003) Re: Shopping with Accounts (Charles Kline 2003) Re: Shopping with Accounts (marc@kaiwi.com (Marc Kaiwi) 2003) Re: Shopping with Accounts (Clint Davis 2003) 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 wastold not to use variables reserved by WebDNA when I first started ;-).  However, I'msure variables that are named the same can be coded in a way to avoid conflict. It justmakes 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 justan 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:

Been meaning to ask... (1997) test (1999) WebCatalog can't find database (1997) Mass Mail (2000) bug in [SendMail] (1997) [WebDNA] v7 thisurl has different behavour (2012) Implementing Gift Certificates in online store (1998) grep matching (2003) A good idea? (1998) RE: shrink-wrapped version out yet? (1997) advise!! (2001) Newbie Tax Question (1997) Not really WebCat (1997) unable to launch acgi in WebCat (1997) PCS Frames-Default page is solution! (1997) Sami (1998) using cookies to prevent access (2000) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Plugin or CGI or both (1997) I have troubles to send message out (1998)