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 each product:db_prod_id db_price_1 db_price_2 db_price_3 1 10 20 30 2 40 50 60 3 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 need to change the original database, but much more database access during work.2 - I could rearrange the database like this: db_prod_id db_group price 1 1 10 1 2 20 1 3 30 2 1 40 2 2 50 2 3 60 3 1 70 3 2 80 3 3 90 This involves a change of the original database but less db access and should 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't be 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 each product:db_prod_id db_price_1 db_price_2 db_price_3 1 10 20 30 2 40 50 60 3 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 need to change the original database, but much more database access during work.2 - I could rearrange the database like this: db_prod_id db_group price 1 1 10 1 2 20 1 3 30 2 1 40 2 2 50 2 3 60 3 1 70 3 2 80 3 3 90 This involves a change of the original database but less db access and should 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't be 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:
THANKS (1997)
WebCatalog for Mac 2.0.1 Released (1997)
Using Plug-In while running 1.6.1 (1997)
[searchString] (1997)
Bug Report, maybe (1997)
template cache problem (1998)
Add to Cart & List of Products (1997)
Re2: frames & carts (1997)
Using Applescript to process WebCatalog functions (1998)
WebCat2b13 Command Reference Doc error (1997)
ssl and invoic.tpl and back bttn (2002)
Weird problems with [SHOWIF]s (1997)
Document Contains No Data! (1997)
WC1.6 to WC2 date formatting (1997)
Execute Applescript (1997)
WebCat2b13MacPlugIn - syntax to convert date (1997)
off topic - dna snipets (1997)
OT - ImageMagick on MacOS X (2004)
time sort question (2005)
[WebDNA] Error: template... (2009)