Re: LookUp Tag
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 15309
interpreted = N
texte = Try this:[LOOKUPdb=Prices.db&value=FP60Q&lookInField=ModuleNo&returnField=Price1¬Found=noprice 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 blankname, 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:
Try this:[LOOKUPdb=Prices.db&value=FP60Q&lookInField=ModuleNo&returnField=Price1¬Found=noprice 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 blankname, 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:
how to put/keep product customization info in basket? (1998)
[WebDNA] Microsoft Server 2008 installation.... so close (2011)
multiple prices (1998)
I give up!! (1997)
Buying sans cart (1997)
Auto Unsubscribe (2000)
[WebDNA] Froala Editor working with WebDNA (2016)
WebMerchant - MacAuthorize (1999)
Extended [ConvertChars] (1997)
emailer 150 (1997)
[SHOWIF] (1997)
Hard Questions ? (1997)
Review comparison by PC Magazine: Open for On-line Business (1997)
Form/HTML Help (2000)
Squares instead of spaces (2001)
RE: Formulas.db + Users.db (1997)
WebCat2: Formulas.db question (1997)
WebCat2 - Getting to the browser's username/password data (1997)
[WebDNA] Windows & WSC (2012)
Great product and great job ! (1997)