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/plain X-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 to publish, and want to separate the price for smart updates.So what do i do now to make the [SubTotal] to calculate the order, there must be a solution to the problem for its the fastest database i have seen please 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/-- -------------------------------- Janne Webdesigner IT-City web produktion Sweden ------------------------------- Content-Type: text/x-vcard; charset=us-ascii; name=vcard.vcf Content-Description: Kort f#246#r Jan Jageblad Content-Disposition: attachment; filename=vcard.vcf Content-Transfer-Encoding: 7bitAttachment converted: Hard Disk:vcard.vcf (TEXT/ttxt) (0000FB9B) Associated Messages, from the most recent to the oldest:

    
  1. Re: [subTotal] pricefield in another database It#180#s not working!? (Jan Jageblad 1998)
Content-Type: text/plain X-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 to publish, and want to separate the price for smart updates.So what do i do now to make the [SubTotal] to calculate the order, there must be a solution to the problem for its the fastest database i have seen please 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/-- -------------------------------- Janne Webdesigner IT-City web produktion Sweden ------------------------------- Content-Type: text/x-vcard; charset=us-ascii; name=vcard.vcf Content-Description: Kort f#246#r Jan Jageblad Content-Disposition: attachment; filename=vcard.vcf Content-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)