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:

Sorting Round 2 plus (1998) Nested Lookups (1998) da webcat, da merchant, da auth (1998) IP Address (2001) expire headers in mac305b11 (1999) Grant, please help me ... (1997) [WebDNA] MacWorld - Jan 2009 (2008) Passing variables to Realm Authentication - WebStar (1998) [SHOWIF AND/OR] (1997) credit card authorization question (1997) [WebDNA] New Webdna framework (2012) Help name our technology! I found it (1997) Too many webcat comments. [WAS- Large founditems loops] (2000) WebCatalog2 Feature Feedback (1996) Formula Question (1998) Format all of a sudden doesn't work (1997) Security Issue (1999) [countWords]? (1997) suffix mapping for NT? (1997) Failure to document significant changes ... (2000)