Related Items for product number [SKU] Related Items for product number [SKU] DOWNLOAD WEBDNA NOW! 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...
[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
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]
[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
Top Articles:
Talk List
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)