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:
in header include files? (1998)
Avery 5160 Mailing Labels SOLVED (2003)
Emailer Problem (2000)
Searching Multiple DBs (1997)
Couple of questions (1999)
breaking & sorting (2000)
Quit revisited (1997)
WebDelivery downloads alias, not original ? (1997)
[getchars] questions (1997)
RE: Adding headers to email (1997)
Problem with updating 2.1b7 -> 2.1.1 (1998)
Trouble creating a temp database (2000)
# fields limited? (1997)
Extended [ConvertChars] (1997)
problems with 2 tags (1997)
Make sure I understand this??? (1997)
[OT] JavaScript Error (2002)
reading a email (2000)
Card clearance, problems - solutions? (1997)
system crashes, event log (1997)