Re: lookups
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28273
interpreted = N
texte = on 2/29/2000 1:44 PM, Eric palhof at eric@pcproduction.com wrote:> I am trying to write a lookup and nothing works.> > ....TD>[lookup > db=Briggs.db&value=[sku]&lookInfield=[Quantity]&returnfield=[Quantity]&NA]> > > I want to lookup the values in the Quantity field of the DB. These values> are different than Quantity in a WebCatalog tag. They are actually Quantity> On Hand and I want the viewer to see their exisitng inventory to decide how> much they can order. I then want to substract the ordered amount from the> existing total. Can anyone help?> > -------------------------------------------------------------> Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.> To end your Mail problems go to
.> > 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> Remove the brackets, unless your field is named [Quantity] literally.Should read:[lookup db=Briggs.db&value=[sku]&lookInfield=Quantity&returnfield=Quantity&NA]but I doubt you are going to find the SKU value in your Quantity field. Youprobably want to do this:[lookup db=Briggs.db&value=[sku]&lookInfield=sku&returnfield=Quantity&NA]Mike-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
Associated Messages, from the most recent to the oldest:
on 2/29/2000 1:44 PM, Eric palhof at eric@pcproduction.com wrote:> I am trying to write a lookup and nothing works.> > ....TD>[lookup > db=Briggs.db&value=[sku]&lookInfield=[Quantity]&returnfield=[Quantity]&NA]> > > I want to lookup the values in the Quantity field of the DB. These values> are different than Quantity in a WebCatalog tag. They are actually Quantity> On Hand and I want the viewer to see their exisitng inventory to decide how> much they can order. I then want to substract the ordered amount from the> existing total. Can anyone help?> > -------------------------------------------------------------> Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.> To end your Mail problems go to .> > 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> Remove the brackets, unless your field is named [Quantity] literally.Should read:[lookup db=Briggs.db&value=[sku]&lookInfield=Quantity&returnfield=Quantity&NA]but I doubt you are going to find the SKU value in your Quantity field. Youprobably want to do this:[lookup db=Briggs.db&value=[sku]&lookInfield=sku&returnfield=Quantity&NA]Mike-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
Mike Davis
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:
WebDNAMonitor (2002)
PSC recommends what date format yr 2000??? (1997)
Instructions for Digest (1997)
Here's how to kill a Butler Database. (1997)
CC and Europe (1999)
PSC recommends what date format yr 2000??? (1997)
OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998)
Extended [ConvertChars] (1997)
HTML file size limit (1998)
database paths/names, and a typo (1997)
[WebDNA] limit found per row (2011)
Help! WebCat2 bug (1997)
WebCat 5 Intranet Question (2003)
MacOS 9 => ODBC=> Ms SQL Server 7 (2000)
Hello??? (1997)
[Include] within a .dna file *further weirdness* (2005)
Price (2000)
[defined]ish (1997)
Updating a database once per day - An example (1998)
Please.. copies of Digest for 7/29 and 7/30? (1997)