Re: [lookup] is case-sensitive, [lookup] is case sensitive...

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 50889
interpreted = N
texte = It has to be something in your lookup or with the variables being used.I replaced all variables and the lookup and it works fine. ----- Original Message ----- From: Dan Strong To: WebDNA Talk Sent: Tuesday, June 03, 2003 7:38 AM Subject: Re: [lookup] is case-sensitive, [lookup] is case sensitive... > I spoke too soon....Anybody see any syntax errors with the following code? My brain hurts. > > -------------------------------------------------------------------------- ----------------------- > [format .2f][math][payment_gross]-([lookup > db=IPN.db&lookinfield=INVOICE&value=[invoice]&returnfield=CPG_subtotal]+[tax ]+[payment_fee])[/math][/format] > -------------------------------------------------------------------------- ----------------------- > > > Thanks, > > -Dan > ------------------------------------------------------------ > http://www.StrongGraphicDesign.com > (208) 319-0137 | Toll-free p/f 877-561-1656 > ------------------------------------------------------------ > > > On Tue, 03 Jun 2003 07:34:11 > Dan Strong wrote: > >Just thought I'd remind anyone who doesn't want to spend the better part of a weekend debugging > >otherwise well-working code... > > > > > >grrrr. > > > >-Dan > >------------------------------------------------------------ > >http://www.StrongGraphicDesign.com > >(208) 319-0137 | Toll-free p/f 877-561-1656 > >------------------------------------------------------------ > > > >------------------------------------------------------------- > >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/ > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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:

    
  1. Re: [lookup] is case-sensitive, [lookup] is case sensitive... (Dan Strong 2003)
  2. Re: [lookup] is case-sensitive, [lookup] is case sensitive... (Kenneth Grome 2003)
  3. Re: [lookup] is case-sensitive, [lookup] is case sensitive... (Dan Strong 2003)
  4. Re: [lookup] is case-sensitive, [lookup] is case sensitive... (WebCat @ Inkblot Media 2003)
  5. Re: [lookup] is case-sensitive, [lookup] is case sensitive... (WJ Starck 2003)
  6. Re: [lookup] is case-sensitive, [lookup] is case sensitive... (Dan Strong 2003)
  7. [lookup] is case-sensitive, [lookup] is case sensitive... (Dan Strong 2003)
It has to be something in your lookup or with the variables being used.I replaced all variables and the lookup and it works fine. ----- Original Message ----- From: Dan Strong To: WebDNA Talk Sent: Tuesday, June 03, 2003 7:38 AM Subject: Re: [lookup] is case-sensitive, [lookup] is case sensitive... > I spoke too soon....Anybody see any syntax errors with the following code? My brain hurts. > > -------------------------------------------------------------------------- ----------------------- > [format .2f][math][payment_gross]-([lookup > db=IPN.db&lookinfield=INVOICE&value=[invoice]&returnfield=CPG_subtotal]+[tax ]+[payment_fee])[/math][/format] > -------------------------------------------------------------------------- ----------------------- > > > Thanks, > > -Dan > ------------------------------------------------------------ > http://www.StrongGraphicDesign.com > (208) 319-0137 | Toll-free p/f 877-561-1656 > ------------------------------------------------------------ > > > On Tue, 03 Jun 2003 07:34:11 > Dan Strong wrote: > >Just thought I'd remind anyone who doesn't want to spend the better part of a weekend debugging > >otherwise well-working code... > > > > > >grrrr. > > > >-Dan > >------------------------------------------------------------ > >http://www.StrongGraphicDesign.com > >(208) 319-0137 | Toll-free p/f 877-561-1656 > >------------------------------------------------------------ > > > >------------------------------------------------------------- > >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/ > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/ WebCat @ Inkblot Media

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:

Can't Update records (1997) Weird bug, or is there something amiss? (1997) [no_cache]?! (2000) Sorting by date (1997) Searching for ALL / empty form field (1997) Not really WebCat (1997) WebCatalog 2.0 b 15 mac (1997) Database (2000) SKU lookup (1997) WebCat2: Items xx to xx shown, etc. (1997) pc (1997) Errata: WCS Newbie question (1997) practicing safe queries.. (2000) UPS uber integration (2007) RE: [WebDNA] Conversion of 500.000 records; advise needed (2008) [ot] table gap help?!? (2001) [input]?? (1998) 2.1b3 --> way slow (1997) Re:What file? (1997) Problems getting parameters passed into email. (1997)