Re: LookUp Tag

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15309
interpreted = N
texte = Try this:[LOOKUP db=Prices.db&value=FP60Q&lookInField=ModuleNo&returnField=Price1¬Found=no price available]Get rid of the brackets around Price1. As you've set it up, the field name Price1 gets replaced with a blank. Lookup then looks for a field with a blank name, and finds nothing. Ray Hatch wrote: > > What is the field you are trying to return, here you are trying to bring > back information from [price1] which in this format is coming from > someother search you have done. What are you trying to find? > > At 04:26 PM 12/2/97 -0000, you wrote: > >I can not for the life of my work out lookup tags. This is the command > >that I am using > > > >[LOOKUP > >db=Prices.db&value=FP60Q&lookInField=ModuleNo&returnField=[Price1]¬Fo > >und=no price available] > > > >I know that lookup is sensitive, but the tag never finds anything. Does > >anyone have any suggestions or had the same problem and found out a > >solution ? > > > >Thanks All > > > >Paul Keen, Technical Director > >Internet UK Services Ltd, Port Hamble Marina, > >Hamble, Hampshire, UK, SO31 4QD > >t: + 44 (0) 1703 452409 x 204 > >f: + 44 (0) 1703 458409 > >paulk@inter.net.uk, www.inter.net.uk > > > > Associated Messages, from the most recent to the oldest:

    
  1. Re: LookUp Tag (Pat McCormick 1997)
  2. RE: LookUp Tag (Paul Keen 1997)
  3. Re: LookUp Tag (Ray Hatch 1997)
  4. LookUp Tag (Paul Keen 1997)
Try this:[LOOKUP db=Prices.db&value=FP60Q&lookInField=ModuleNo&returnField=Price1¬Found=no price available]Get rid of the brackets around Price1. As you've set it up, the field name Price1 gets replaced with a blank. Lookup then looks for a field with a blank name, and finds nothing. Ray Hatch wrote: > > What is the field you are trying to return, here you are trying to bring > back information from [price1] which in this format is coming from > someother search you have done. What are you trying to find? > > At 04:26 PM 12/2/97 -0000, you wrote: > >I can not for the life of my work out lookup tags. This is the command > >that I am using > > > >[LOOKUP > >db=Prices.db&value=FP60Q&lookInField=ModuleNo&returnField=[Price1]¬Fo > >und=no price available] > > > >I know that lookup is sensitive, but the tag never finds anything. Does > >anyone have any suggestions or had the same problem and found out a > >solution ? > > > >Thanks All > > > >Paul Keen, Technical Director > >Internet UK Services Ltd, Port Hamble Marina, > >Hamble, Hampshire, UK, SO31 4QD > >t: + 44 (0) 1703 452409 x 204 > >f: + 44 (0) 1703 458409 > >paulk@inter.net.uk, www.inter.net.uk > > > > Pat McCormick

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:

Multiple prices (1997) Separate SSL Server (1997) Constructive criticism (2000) Webcat/Webmerchant part II (1998) form data submission gets truncated (1997) my price won't move (1997) shipping calculations, lookup command (1997) with Link i need to (1997) WebSTAR and WebSTAR/SSL with WebCatalog plugins (1998) Webstar 1.3.1 PPC (1997) Modify Database (1998) Web DNA rates (2000) [WebDNA] Authorize working connection... (2020) ups quickcost [repost] (1999) WC1.6 to WC2 date formatting (1997) Generating Options for a Form. (1997) (2000) Setting up WebCatalog with Retail Pro data (1996) Calculating multiple shipping... (1997) [WebDNA] 301 redirect (2016)