Re: [subTotal] pricefield in another database It#180#s not working!?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17619
interpreted = N
texte = Content-Type: text/plainX-MIME-Autoconverted: from 8bit to quoted-printable by maila.telia.com id UAA28101I put this command in Formulas.db[Lookup db=db/price.db&Lookinfield=sku&value=[artikelnr]&returnfield=price]and switch artikelnr to sku in price.db but the problem remains intact.In price.db is only two field now [sku] [price], so i want to compare[artikelnr] in data.db to [sku] in price.db to return price to [SubTotal]The reasen to use two databases is for my client have round 50000 articles topublish,and want to separate the price for smart updates.So what do i do now to make the [SubTotal] to calculate the order, there mustbea solution to the problem for its the fastest database i have seenplease help!!!! i´m sorry i cant figure it out.http://shop.widik.seJannePCS Technical Support skrev:> >I have my pricefield in another database> >the problem are when i use the tag [subtotal]> >subtotal think that i have the pricefield in my ordinary database>> Change your formulas.db file so that the price formula uses the other> database for the lookup:>> -- Formulas.db --> price [Lookup> db=db/price.db&Lookinfield=Artikelnr&value=[artikelnr]&returnfield=price]>> I also recommend you use SKU instead of artikelnr to represent the> unique product identity, because SKU is used automatically by WebCatalog in> lots of places.>> Technical Support | ==== eCommerce and Beyond ====> Pacific Coast Software | WebCatalog, WebMerchant,> 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,> San Diego, CA 92128 | Typhoon> 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/----------------------------------JanneWebdesignerIT-City web produktionSweden-------------------------------Content-Type: text/x-vcard; charset=us-ascii; name=vcard.vcfContent-Description: Kort f#246#r Jan JagebladContent-Disposition: attachment; filename=vcard.vcfContent-Transfer-Encoding: 7bitAttachment converted: Hard Disk:vcard.vcf (TEXT/ttxt) (0000FB9B)
Associated Messages, from the most recent to the oldest:
|
- Re: [subTotal] pricefield in another database It#180#s not working!? (Jan Jageblad 1998)
|
Content-Type: text/plainX-MIME-Autoconverted: from 8bit to quoted-printable by maila.telia.com id UAA28101I put this command in
formulas.db[Lookup db=db/price.db&Lookinfield=sku&value=[artikelnr]&returnfield=price]and switch artikelnr to sku in price.db but the problem remains intact.In price.db is only two field now [sku] [price], so i want to compare[artikelnr] in data.db to [sku] in price.db to return price to [SubTotal]The reasen to use two databases is for my client have round 50000 articles topublish,and want to separate the price for smart updates.So what do i do now to make the [SubTotal] to calculate the order, there mustbea solution to the problem for its the fastest database i have seenplease help!!!! i´m sorry i cant figure it out.http://shop.widik.seJannePCS Technical Support skrev:> >I have my pricefield in another database> >the problem are when i use the tag [subtotal]> >subtotal think that i have the pricefield in my ordinary database>> Change your
formulas.db file so that the price formula uses the other> database for the lookup:>> --
formulas.db --> price [Lookup> db=db/price.db&Lookinfield=Artikelnr&value=[artikelnr]&returnfield=price]>> I also recommend you use SKU instead of artikelnr to represent the> unique product identity, because SKU is used automatically by WebCatalog in> lots of places.>> Technical Support | ==== eCommerce and Beyond ====> Pacific Coast Software | WebCatalog, WebMerchant,> 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,> San Diego, CA 92128 | Typhoon> 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/----------------------------------JanneWebdesignerIT-City web produktionSweden-------------------------------Content-Type: text/x-vcard; charset=us-ascii; name=vcard.vcfContent-Description: Kort f#246#r Jan JagebladContent-Disposition: attachment; filename=vcard.vcfContent-Transfer-Encoding: 7bitAttachment converted: Hard Disk:vcard.vcf (TEXT/ttxt) (0000FB9B)
Jan Jageblad
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:
Web Catalog 2 demo (1997)
unsubscribe (1997)
Whats up with emailer? (1998)
Checkboxes to add to cart... (1998)
A Global Variable (1997)
RAM variables (1997)
SKU Question (1999)
webcat serving multiple copies of same db from ram (2000)
Document Contains No Data! (1997)
Smith Micro - no competition (2000)
Problems getting parameters passed into email. (1997)
Find one not all, code not working (2003)
Template Not Found (1998)
Dismissing dialogs (was 2.1b3 --> way slow) (1997)
Frames and WebCat (1997)
my price won't move (1997)
Thanks and Big News!!! (1997)
[WriteFile] problems (1997)
Beta 3.0.3 fix for serial# problem (Mac) (1998)
Date format question (1998)