Multiple price fields
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 32344
interpreted = N
texte = I get a database export from a customer, where are 3 prices for eachproduct:db_prod_id db_price_1 db_price_2 db_price_31 10 20 302 40 50 603 70 80 90No [price] would go to the cart, because there is no such field.I think about two options:1 - I could write a [price] field to a seperate database before each[addlineitem] and [setlineitem], and put this field into the cart: No needto change the original database, but much more database access during work.2 - I could rearrange the database like this:db_prod_id db_group price1 1 101 2 201 3 302 1 402 2 502 3 603 1 703 2 803 3 90This involves a change of the original database but less db access andshould be faster, even on Linux. Ok, I loose the ability to use [lookup],but since I can do a case sensitive search for the product ID it shouldn'tbe slower.The second option is better, right?Peter-------------------------------------------------------------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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
|
- Multiple price fields (Peter Ostry 2000)
|
I get a database export from a customer, where are 3 prices for eachproduct:db_prod_id db_price_1 db_price_2 db_price_31 10 20 302 40 50 603 70 80 90No [price] would go to the cart, because there is no such field.I think about two options:1 - I could write a [price] field to a seperate database before each[addlineitem] and [setlineitem], and put this field into the cart: No needto change the original database, but much more database access during work.2 - I could rearrange the database like this:db_prod_id db_group price1 1 101 2 201 3 302 1 402 2 502 3 603 1 703 2 803 3 90This involves a change of the original database but less db access andshould be faster, even on Linux. Ok, I loose the ability to use [lookup],but since I can do a case sensitive search for the product ID it shouldn'tbe slower.The second option is better, right?Peter-------------------------------------------------------------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://search.smithmicro.com/
Peter Ostry
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:
quantity minimum problem (1997)
Missing Cart Information (2003)
WebCat2b15MacPlugin - showing [math] (1997)
iis 4.0 (1997)
anyone using Webcat 4.x in production? (2000)
[WebDNA] Apache 2 Error Log Entry (2009)
access denied problem (1997)
A Global Variable (1997)
IP address & domain name problem (2003)
WC2b15 File Corruption (1997)
Almost a there but..bye bye NetCloak (1997)
no template caching (1997)
Banner DNA (1997)
Applescript error (1998)
Error 11 (1996)
Are they really global tags? (2002)
retain raw [cart] submitted value (2004)
Support ?? (1997)
time + (1998)
Help!!!! Purchases not going through! (1997)