Re: Inventory lookup & display...
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 47313
interpreted = N
texte = Hi Alan, it looks like you have a variable naming error.change your [theID] to [the_ID] and try that... see below.DonovanAlan White wrote:>Hi>[showif [lookup >db=products.db&value=[the_ID]&lookinfield=ID&returnfield=NO_INVENTORY]>0]
nt color=#999999>[lookup>db=products.db&value=[theID]&lookinfield=ID&returnfield=NO_INVENTORY] IN>STOCK[/showif]>>I have also tried this (adding the text tag):->>[showif [lookup >db=products.db&value=[the_ID]&lookinfield=ID&returnfield=NO_INVENTORY]>0]nt color=#999999>[text][lookup>db=products.db&value=[the***add a _ here***ID]&lookinfield=ID&returnfield=NO_INVENTORY][/text]>IN STOCK[/showif]>-- -Donovan Brooke-Administrator of IT /-Assc. Art Director-Creative Services-Epsen Hillmer Graphics-402.342.1169-------------------------------------------------------------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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi Alan, it looks like you have a variable naming error.change your [theID] to [the_ID] and try that... see below.DonovanAlan White wrote:>Hi>[showif [lookup >db=products.db&value=[the_ID]&lookinfield=ID&returnfield=NO_INVENTORY]>0]nt color=#999999>[lookup>db=products.db&value=[theID]&lookinfield=ID&returnfield=NO_INVENTORY] IN>STOCK[/showif]>>I have also tried this (adding the text tag):->>[showif [lookup >db=products.db&value=[the_ID]&lookinfield=ID&returnfield=NO_INVENTORY]>0]nt color=#999999>[text][lookup>db=products.db&value=[the***add a _ here***ID]&lookinfield=ID&returnfield=NO_INVENTORY][/text]>IN STOCK[/showif]>-- -Donovan Brooke-Administrator of IT /-Assc. Art Director-Creative Services-Epsen Hillmer Graphics-402.342.1169-------------------------------------------------------------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://webdna.smithmicro.com/
Donovan
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:
Nested tags count question (1997)
Date problems-more (1997)
HELP WITH DATES (1997)
find with exceptions (1997)
Share Bulletin Board? (1998)
Using copyfolder (2001)
Nested Loops and SHOWIFs (1997)
[LOOKUP] (1997)
Email Spam a bit of Hell (2004)
Re:quit command on NT (1997)
founditems and setheader (2000)
Emailer setup (1997)
To Err or Not Custom Error (1999)
Exclamation (2002)
Search Form (2000)
A multi-processor savvy WebCatalog? (1997)
b12 cannot limit records returned and more. (1997)
Size limit for tmpl editor ? (1997)
Calendar using WebCatalog? (1997)
New Weird Behavior (bug report) (2000)